import os from sqlalchemy import create_engine from sqlalchemy.orm import declarative_base, sessionmaker from dotenv import load_dotenv load_dotenv() # Get the URL and fix the postgres:// scheme for SQLAlchemy SQLALCHEMY_DATABASE_URL = os.getenv("DATABASE_URL") if SQLALCHEMY_DATABASE_URL and SQLALCHEMY_DATABASE_URL.startswith("postgres://"): SQLALCHEMY_DATABASE_URL = SQLALCHEMY_DATABASE_URL.replace("postgres://", "postgresql://", 1) engine = create_engine(SQLALCHEMY_DATABASE_URL) SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) Base = declarative_base() # Dependency to get the database session for each request def get_db(): db = SessionLocal() try: yield db finally: db.close()