database/__init__.py

# database/__init__.py
# يُصدّر الواجهة العامة لطبقة قاعدة البيانات
# الاستخدام: from database import init_database, get_setting, ...

from database.migrations import init_database, rebuild_fts_index
from database.settings   import get_setting, set_setting
from database.messages   import (
    message_exists, insert_message, delete_message, get_message,
    clear_all_messages, get_total_count, get_count_by_platform,
    get_stats_by_channel, get_stats_by_platform,
    get_recent_indexed, get_all_stats,
)
from database.users import (
    upsert_user, get_user, is_user_banned, ban_user, unban_user,
    get_total_users, subscribe_user, unsubscribe_user, is_subscribed,
    get_all_subscriber_ids, get_subscriber_count, remove_subscriber,
    log_broadcast, get_broadcast_history,
)

__all__ = [
    # migrations
    "init_database", "rebuild_fts_index",
    # settings
    "get_setting", "set_setting",
    # messages
    "message_exists", "insert_message", "delete_message", "get_message",
    "clear_all_messages", "get_total_count", "get_count_by_platform",
    "get_stats_by_channel", "get_stats_by_platform",
    "get_recent_indexed", "get_all_stats",
    # users
    "upsert_user", "get_user", "is_user_banned", "ban_user", "unban_user",
    "get_total_users", "subscribe_user", "unsubscribe_user", "is_subscribed",
    "get_all_subscriber_ids", "get_subscriber_count", "remove_subscriber",
    "log_broadcast", "get_broadcast_history",
]