"""Helper to resolve API keys: DB (VideoProviderConfig) first, then .env fallback."""
from flask import current_app


def get_provider_key(provider_name: str, env_key: str, env_secret: str = None):
    """Return (api_key, api_secret) for a provider.
    
    Priority: DB VideoProviderConfig → Flask config (.env)
    """
    try:
        from app.models.features import VideoProviderConfig
        key, secret, _ = VideoProviderConfig.get_provider_config(provider_name)
        if key:
            return key, secret
    except Exception:
        pass

    api_key = current_app.config.get(env_key, "") if env_key else ""
    api_secret = current_app.config.get(env_secret, "") if env_secret else None
    return api_key, api_secret