/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

1 vote300 views1 answer
Python datetime round to nearest hour
Python
12 votes311 views4 answers
Get index of all element in list python
Python
13 votes282 views6 answers
How to open pickle file
Python
4 votes281 views1 answer
Python pygame screen example
Python
19 votes264 views1 answer
Python left string
Python
0 vote294 views3 answers
When iterating through a pandas dataframe using index, is the index +1 able to be compared
Python
4 votes340 views4 answers
Python find factors of a number
Python
68 votes295 views2 answers
Pyton do while loop+
Python
0 vote310 views3 answers
COVID-19)
Python
24 votes264 views2 answers
Python suppress warnings in function
Python