| from sqlalchemy import create_engine | |
| from sqlalchemy.ext.declarative import declarative_base | |
| from sqlalchemy.orm import sessionmaker | |
| from app.core.config import settings | |
| # Create SQLAlchemy engine | |
| engine = create_engine(settings.DATABASE_URL) | |
| # Create session factory | |
| SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) | |
| # Create base class for models | |
| Base = declarative_base() | |
| # Function to get database session | |
| def get_db(): | |
| """Dependency for getting DB session.""" | |
| db = SessionLocal() | |
| try: | |
| yield db | |
| finally: | |
| db.close() | |
| # Function to create all tables | |
| def create_tables(): | |
| """Create all tables in the database.""" | |
| Base.metadata.create_all(bind=engine) |