import asyncio
from sqlalchemy.ext.asyncio import create_async_engine, async_sessionmaker, AsyncSession
from app.core.database import DATABASE_URL
from app.routes.vouchers import _get_hotspot_device, _hotspot_adapter

async def run():
    engine = create_async_engine(DATABASE_URL)
    async_session = async_sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
    async with async_session() as db:
        mk, _ = await _get_hotspot_device(db)
        adapter = await _hotspot_adapter(db, mk.id)
        pool = adapter._get_api()
        try:
            api = pool.get_api()
            profiles = api.get_resource('/ip/hotspot/user/profile').get()
            print("Profiles on router:", [p.get('name') for p in profiles])
        finally:
            pool.disconnect()

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