Fastapi: I am new to fast api and I am working with sqlite3 database my issue is AttributeError: 'Depends' object has no attribute 'query'

[ganeshmastud]

First check

• [ ] I added a very descriptive title to this issue.
• [ ] I used the GitHub search to find a similar issue and didn't find it.
• [ ] I searched the FastAPI documentation, with the integrated search.
• [ ] I already searched in Google "How to X in FastAPI" and didn't find any information.
• [ ] I already read and followed all the tutorial in the docs and didn't find an answer.
• [ ] I already checked if it is not related to FastAPI but to Pydantic.
• [ ] I already checked if it is not related to FastAPI but to Swagger UI.
• [ ] I already checked if it is not related to FastAPI but to ReDoc.
• [ ] After submitting this, I commit to one of:
  
  
  
  • Read open issues with questions until I find 2 issues where I can help someone and add a comment to help there.
  
  
  • I already hit the "watch" button in this repository to receive notifications and I commit to help at least 2 people that ask questions in the future.
  
  
  • Implement a Pull Request for a confirmed bug.
  
  

Example

Here's a self-contained, minimal, reproducible, example with my use case:

from fastapi import FastAPI

app = FastAPI()


@app.get("/")
def read_root():
    return {"Hello": "World"}

Description

• Open the browser and call the endpoint /.
• It returns a JSON with {"Hello": "World"}.
• But I expected it to return {"Hello": "Sara"}.

Environment

• OS: [e.g. Linux / Windows / macOS]:
• FastAPI Version [e.g. 0.3.0]:

To know the FastAPI version use:

python -c "import fastapi; print(fastapi.__version__)"

• Python version:

To know the Python version use:

python --version

Additional context

[SirTelemak]

Can you share your code snippet please. I can't say what's wrong here without example :)

[ganeshmastud]

from typing import List

from fastapi import Depends, FastAPI, Request, HTTPException, Form
from sqlalchemy.orm import Session
import os
import models
from database import SessionLocal, engine
from fastapi.responses import HTMLResponse
from fastapi.staticfiles import StaticFiles
from fastapi.templating import Jinja2Templates
from pydantic import BaseModel

models.Base.metadata.create_all(bind=engine)

app = FastAPI()

app.mount("/static", StaticFiles(directory="static"), name="static")
templates = Jinja2Templates(directory="templates")

basepath = 'static/'
urls=[]
for entry in os.listdir(basepath):
    urls.append(entry)
class Senddata(BaseModel):
    is_sarcastic: bool
    cnt:int
    clip_url:str
    is_audio_rgt:bool
def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()
def check_url(db: Session, url: str):
    print(db.query(models.Sarcasm).filter(models.Sarcasm.clip_url == url).first())
    return db.query(models.Sarcasm).filter(models.Sarcasm.clip_url == url).first()
@app.post("/postdata/", response_model=Senddata)
def postdata(send:Senddata, db: Session = Depends(get_db)):
    data = models.Sarcasm()
    for i in send:
        url=check_url(db, i)
        if url:
            continue
        else:
            data.clip_url = url

            db.add(data)

    db.commit()
    return {"code": "sucess"}
postdata(urls)

Error is this.
File ".main.py", line 53, in
postdata(urls)
File ".main.py", line 43, in postdata
url=check_url(db, i)
File ".main.py", line 37, in check_url
print(db.query(models.Sarcasm).filter(models.Sarcasm.clip_url == url).first())
AttributeError: 'Depends' object has no attribute 'query'

[ganeshmastud]

Can you share your code snippet please. I can't say what's wrong here without example :)

you can check now :)

[SirTelemak]

Your mistake is calling postdata directly at line 53. FastAPI handles dependencies when you make http request. So you should launch you app uvicorn main:app and then make request to postdata. If you want to test API route from code, you should use TestClient

[ycd]

Is the problem resolved @ganeshmastud? If it is, do you mind closing the issue?

[tiangolo]

Thanks for the help here @SirTelemak ! :clap: :bow:

If that solves the original problem, then you can close this issue @ganeshmastud :heavy_check_mark: