"""Быстрая статистика pending_sms."""
import asyncio
import sys
from pathlib import Path

ROOT = Path(__file__).resolve().parents[1]
if str(ROOT) not in sys.path:
    sys.path.insert(0, str(ROOT))

from sqlalchemy import text
from app.database.engine import async_session


async def main() -> None:
    async with async_session() as s:
        row = (
            await s.execute(
                text(
                    "SELECT MIN(created_at), MAX(created_at), COUNT(*) "
                    "FROM pending_sms WHERE status='pending'"
                )
            )
        ).fetchone()
        print("pending_min_max_count:", row)
        idxs = (
            await s.execute(
                text(
                    "SELECT name FROM sqlite_master "
                    "WHERE type='index' AND tbl_name='pending_sms'"
                )
            )
        ).fetchall()
        print("indexes:", [x[0] for x in idxs])


if __name__ == "__main__":
    asyncio.run(main())