import asyncio

from dotenv import load_dotenv
load_dotenv()

from app.core.database import AsyncSessionLocal
from app.routes.customers import auto_sn_discovery


async def main():
    async with AsyncSessionLocal() as db:
        result = await auto_sn_discovery(1, "0/0/1", db)
    body = result if isinstance(result, dict) else None
    if body is None:
        raise RuntimeError("Auto SN API did not return live results")
    rows = body["results"]
    print(f"api_available={str(body['available']).lower()}")
    print(f"api_auto_sn_count={len(rows)}")
    for row in rows:
        print("api_auto_sn=" + row["serial_number"])


asyncio.run(main())