/Python/Could not locate a bind configured on mapper mapped class class->tablename, SQL expression or this Session.

Could not locate a bind configured on mapper mapped class class->tablename, SQL expression or this Session.

# When working with FastAPI
# database.py

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

SQLALCHEMY_DATABASE_URL = "mysql://user:pwd@host:port/db"
engine = create_engine(SQLALCHEMY_DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)

Base = declarative_base()


# main.py

from fastapi import FastAPI, Depends
from sqlalchemy.orm import Session

from database import SessionLocal
import schema

def get_db():
    # The important thing here is to create an instance of SessionLocal
    # from database.py not Session from sqlalchemy
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()
        
@app.get("/user", response_model=schema.User)
def get_user(user_id: int, db: Session=Depends(get_db))
	user = crud.get_user(db, user_id=user_id)
    return user

Similar codes

4 votes219 views4 answers
How recursion works in python
Python
1 vote203 views1 answer
Python reload lib jupyter notebook %reload
Python
0 vote213 views1 answer
Python loop over s3 objects]
Python
0 vote204 views1 answer
Python chunk text
Python
1 vote212 views2 answers
Num1 = int(input('Enter The First No: ')) num2 = int(input('Enter The Second No: ')) print("Answer: "num1+num2)
Python
5 votes252 views1 answer
Pip3 install pyaml
Python
0 vote222 views1 answer
Python how to delete from dictionary a nan key
Python
0 vote198 views1 answer
How to create simple window in wxPython
Python
7 votes192 views6 answers
Python function
Python
14 votes204 views4 answers
Plt subplots figsize
Python