from sqlmodel import create_engine from sqlalchemy.pool import StaticPool from ..config import settings import urllib.parse import logging # Configure logging logging.basicConfig(level=logging.INFO) logger = logging.getLogger(__name__) # Global engine instance to reuse connection _engine = None # Function to create the database engine def get_engine(): global _engine if _engine is not None: return _engine logger.info(f"Creating database engine for: {settings.DATABASE_URL[:50]}...") # For SQLite, use StaticPool and check_same_thread=False if settings.DATABASE_URL.lower().startswith("sqlite"): _engine = create_engine( settings.DATABASE_URL, echo=True, connect_args={"check_same_thread": False}, # Required for SQLite in multithreaded environments poolclass=StaticPool ) else: # For PostgreSQL (including Neon), handle SSL requirements # Parse the database URL to check if it's a Neon URL if "neon.tech" in settings.DATABASE_URL.lower(): # For Neon databases, we need to add SSL parameters _engine = create_engine( settings.DATABASE_URL, echo=True, connect_args={ "sslmode": "require", # Required for Neon connections "channel_binding": "disable" # Changed from "require" to "disable" for broader compatibility } ) else: # Standard PostgreSQL connection _engine = create_engine( settings.DATABASE_URL, echo=True ) logger.info("Database engine created successfully") return _engine