"""
Base services module for common functionality.
"""

from typing import Optional
from sqlalchemy.orm import Session
from sqlalchemy import select

from src.apps.base.models.cdn import CDN


def get_active_cdn(db: Session) -> Optional[CDN]:
    """
    Get the active CDN configuration from the database.
    
    Args:
        db: Database session.
        
    Returns:
        CDN object with active CDN settings, or None if no active CDN is configured.
    """
    # Using SQLAlchemy 2.0 syntax
    stmt = select(CDN).where(CDN.is_active == True)
    result = db.execute(stmt)
    return result.scalar_one_or_none()