from sqlalchemy import text
from backend.models.database import SessionLocal
db = SessionLocal()
pid = db.execute(text("SELECT id FROM dim_products WHERE sku='POL12929'")).scalar()
r = db.execute(text("""
    SELECT SUM(quantity)::float u, SUM(purchase_value)::float pv,
           SUM(ruc_eur)::float r
    FROM erp_transactions WHERE product_id=:p
"""), {"p": pid}).mappings().first()
print(f"POL12929 (id={pid}): units={r['u']}  purchase_value={r['pv']}  ruc={r['r']}")
db.close()