from sqlmodel import Session

from app.db import create_db_and_tables, engine
from app.models import PostalCodeCommune, ReferentialItem, ReferentialType


def seed() -> None:
    create_db_and_tables()
    with Session(engine) as session:
        session.add(ReferentialItem(type=ReferentialType.TARIFF, code="ISOL_COMBLES_M2", label="Isolation des combles - prix indicatif au m²", value_numeric=45.0, unit="EUR_HT_M2", version="mvp"))
        session.add(ReferentialItem(type=ReferentialType.SCALE, code="AIDE_BASE_PERCENT", label="Taux d’aide de base", value_numeric=30.0, unit="PERCENT", version="mvp"))
        session.add(PostalCodeCommune(postal_code="75001", commune="Paris 1er Arrondissement", insee_code="75101", department_code="75", region="Île-de-France"))
        session.commit()


if __name__ == "__main__":
    seed()