Spaces:
Sleeping
Sleeping
File size: 1,750 Bytes
2e76a54 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | 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 |