RamshaAnwar's picture
feat(db): add sqlalchemy models, pgvector, and alembic migrations (#1)
3e36c5e unverified
Raw History Blame Contribute Delete
487 Bytes
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker, declarative_base
from app.config import settings
engine = create_engine(
settings.DATABASE_URL,
pool_pre_ping=True,
pool_size=3,
max_overflow=2,
connect_args={"prepare_threshold": None}
)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()
def get_db():
db = SessionLocal()
try:
yield db
finally:
db.close()