'''

@author: olivier.massot
'''
from path import Path

from core.pde import AnalytiqueDb

if __name__ == "__main__":

    # reinitialise les données pour les tests de ctrl2analytique.py

    AnalytiqueDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Db_analytique.mdb")
    analytique_db = AnalytiqueDb(autocommit=False)

    for num_env in ("19264", "20297", "22339"):
        for row in analytique_db.read("SELECT * FROM tbl_Factures WHERE [strEnveloppe]='{}' and intExercice=2018".format(num_env)):
            factid = row.dblFactureId
            print(factid)
            analytique_db.execute("DELETE * FROM tbl_Facture_Affaire WHERE [dblFactureId]={}".format(factid))
            analytique_db.execute("DELETE * FROM tbl_Facture_Engin WHERE [dblFactureId]={}".format(factid))
            analytique_db.execute("DELETE * FROM tbl_Factures WHERE [dblFactureId]={}".format(factid))
            analytique_db.execute("DELETE * FROM tbl_Mandatement WHERE [dblFacture]={}".format(factid))

        analytique_db.commit()