database/settings.py

# ============================================
# database/settings.py — إعدادات البوت الديناميكية
# ============================================

import logging
from database.connection import get_connection

logger = logging.getLogger(__name__)


def get_setting(key: str, default: str = "") -> str:
    """قراءة إعداد من قاعدة البيانات"""
    conn = get_connection()
    try:
        c = conn.cursor()
        c.execute("SELECT value FROM settings WHERE key = ?", (key,))
        row = c.fetchone()
        return row["value"] if row else default
    except Exception as e:
        logger.error(f"خطأ في get_setting key={key}: {e}", exc_info=True)
        return default
    finally:
        conn.close()


def set_setting(key: str, value: str) -> bool:
    """حفظ أو تحديث إعداد في قاعدة البيانات"""
    conn = get_connection()
    try:
        conn.execute(
            "INSERT OR REPLACE INTO settings (key, value) VALUES (?, ?)",
            (key, value)
        )
        conn.commit()
        return True
    except Exception as e:
        logger.error(f"خطأ في set_setting key={key}: {e}", exc_info=True)
        return False
    finally:
        conn.close()