from telegram import Update
from telegram.ext import ContextTypes
from database.db import DB
from utils.decorators import anti_flood

@anti_flood
async def announcements(update: Update, context: ContextTypes.DEFAULT_TYPE):
    rows = await DB.fetchall(
        "SELECT title, body, created_at FROM announcements ORDER BY id DESC LIMIT 10")
    if not rows:
        await update.message.reply_text("📢 No announcements yet."); return
    parts = ["📢 <b>Latest Announcements</b>\n"]
    for r in rows:
        parts.append(f"<b>{r['title']}</b>  <i>{r['created_at'][:10]}</i>\n{r['body']}\n")
    await update.message.reply_html("\n".join(parts))