db.py 485 B

12345678910111213141516171819
  1. from sqlalchemy import create_engine
  2. from sqlalchemy.orm import declarative_base, sessionmaker
  3. from .config import settings
  4. engine = create_engine(
  5. settings.DATABASE_URL,
  6. connect_args={"check_same_thread": False} if settings.DATABASE_URL.startswith("sqlite") else {},
  7. )
  8. SessionLocal = sessionmaker(bind=engine, autoflush=False, autocommit=False)
  9. Base = declarative_base()
  10. def get_session():
  11. db = SessionLocal()
  12. try:
  13. yield db
  14. finally:
  15. db.close()