Spaces:
Running
Running
File size: 1,986 Bytes
89ae94f |
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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
"""
Database configuration and setup for API.
"""
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy.orm import sessionmaker
import os
from typing import AsyncGenerator
import logging
# Configure logger
logger = logging.getLogger(__name__)
# Get database URL from environment (convert synchronous to async URL)
db_url = os.getenv("DATABASE_URL", "")
if db_url.startswith("postgresql://"):
# Remove sslmode parameter if present which causes issues with asyncpg
if "?" in db_url:
base_url, params = db_url.split("?", 1)
param_list = params.split("&")
filtered_params = [p for p in param_list if not p.startswith("sslmode=")]
if filtered_params:
db_url = f"{base_url}?{'&'.join(filtered_params)}"
else:
db_url = base_url
ASYNC_DATABASE_URL = db_url.replace("postgresql://", "postgresql+asyncpg://", 1)
else:
ASYNC_DATABASE_URL = "postgresql+asyncpg://postgres:postgres@localhost:5432/postgres"
# Create async engine
engine = create_async_engine(
ASYNC_DATABASE_URL,
echo=False, # Set to True for debugging
future=True,
pool_size=5,
max_overflow=10
)
# Create async session factory
async_session = sessionmaker(
engine,
class_=AsyncSession,
expire_on_commit=False
)
async def get_db() -> AsyncGenerator[AsyncSession, None]:
"""
Get database session generator.
Yields:
AsyncSession: Database session
"""
session = async_session()
try:
yield session
await session.commit()
except Exception as e:
await session.rollback()
logger.error(f"Database error: {e}")
raise
finally:
await session.close()
# Dependency for getting DB session
async def get_db_session() -> AsyncSession:
"""
Get database session.
Returns:
AsyncSession: Database session
"""
async with async_session() as session:
return session |