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