import sys
sys.path.insert(0, '.')

from app.database import SessionLocal
from app.models.transport import ParametreCout

BETONS = [
    ("prix_beton_XF1",    89.0,  "€/m³", "Béton XF1"),
    ("prix_beton_XA2",    95.0,  "€/m³", "Béton XA2"),
    ("prix_beton_XA3",   105.0,  "€/m³", "Béton XA3"),
    ("prix_beton_BLANC", 130.0,  "€/m³", "Béton BLANC"),
    ("prix_beton_XF1_C35_45", 98.0, "€/m³", "Béton XF1 C35/45 52.5"),
]

db = SessionLocal()
try:
    for cle, valeur, unite, label in BETONS:
        existing = db.query(ParametreCout).filter(ParametreCout.cle == cle).first()
        if not existing:
            db.add(ParametreCout(cle=cle, valeur=valeur, unite=unite, label=label))
            print(f"  + {cle}")
        else:
            print(f"  ~ {cle} (déjà présent)")
    db.commit()
    print("OK")
finally:
    db.close()