import asyncio
from sqlalchemy import select
from app.core.database import AsyncSessionLocal
from app.models.models import Customer

async def main():
    async with AsyncSessionLocal() as db:
        customer = (await db.execute(select(Customer).order_by(Customer.id.desc()).limit(1))).scalar_one_or_none()
        if not customer:
            print("latest_psb=missing"); return
        checks = {
            "package": bool(customer.service_package_id), "odp": bool(customer.odp_id),
            "mikrotik": bool(customer.mikrotik_device_id), "olt": bool(customer.olt_device_id),
            "sn": bool(customer.ont_sn), "port": bool(customer.olt_port),
            "onu": customer.onu_id is not None, "technician": bool(customer.assigned_teknisi_id),
            "olt_provisioning": customer.olt_provisioning_status, "mikrotik_provisioning": customer.mikrotik_provisioning_status,
        }
        print("latest_psb_code=" + (customer.customer_code or "pending"))
        print("checks=" + ",".join(f"{key}:{'ok' if value is True else value}" for key,value in checks.items()))
        print("status=" + str(customer.status))

asyncio.run(main())