from sqlalchemy import text
from backend.models.database import SessionLocal

db = SessionLocal()
print("SKU       cost     LT    supplier")
print("-" * 70)
for sku in ("POL12887", "POL12885", "POL12929", "SCI03718", "GAR03976"):
    r = db.execute(text("""
        SELECT p.sku, ec.cost_price::float AS cost,
               sm.lead_time_weeks::float AS lt,
               ds.name AS supplier
        FROM dim_products p
        LEFT JOIN erp_costs ec ON ec.product_id = p.id
        LEFT JOIN supply_master sm ON sm.product_id = p.id
        LEFT JOIN dim_suppliers ds ON ds.id = sm.supplier_id
        WHERE p.sku = :s
    """), {"s": sku}).mappings().first()
    if r:
        print(f"{r['sku']:<10}{r['cost']!s:<9}{r['lt']!s:<6}{r['supplier']}")
    else:
        print(f"{sku:<10}NOT FOUND")
db.close()