File size: 1,259 Bytes
036b534 | 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 | # ============================================
# 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()
|