scripts-pde/resources/test_ctrl2analytique.py

'''

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

from core.pde import ControlesDb, AnalytiqueDb, CommunDb

if __name__ == "__main__":

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

    ControlesDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\cg67Parc_data.mdb")
    AnalytiqueDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Db_analytique.mdb")
    CommunDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Commun_Data.mdb")

    analytique_db = AnalytiqueDb(autocommit=False)
    controles_db = ControlesDb(autocommit=False)
    commun_db = CommunDb(autocommit=False)

    for num_aff in ("175256", "175195"):
        controles_db.execute("UPDATE tblCommandes SET sngAffaireIdMos = 0 WHERE [lngChantierId] = {} AND [bytCommandeId] = 1".format(num_aff))
        controles_db.execute("UPDATE tblEtancheiteIntervs SET sngIntervIdMos = 0 WHERE [lngChantierId] = {} AND [bytCommandeId] = 1".format(num_aff))
        controles_db.execute("UPDATE tblCompactageIntervs SET sngIntervIdMos = 0 WHERE [lngChantierId] = {} AND [bytCommandeId] = 1".format(num_aff))
        controles_db.execute("UPDATE tblVideoIntervs SET sngIntervIdMos = 0 WHERE [lngChantierId] = {} AND [bytCommandeId] = 1".format(num_aff))
        controles_db.commit()

        affaire = analytique_db.first("SELECT DblAffaireId FROM tbl_Affaires WHERE strLiaisonControle='{}/1'".format(num_aff))
        if affaire:
            aff_id = affaire.DblAffaireId
            analytique_db.execute("DELETE * FROM tbl_Intervention WHERE [DblAffaireId]={}".format(aff_id))
            analytique_db.execute("DELETE * FROM tbl_Tarification WHERE [DblAffaireId]={}".format(aff_id))
            analytique_db.execute("DELETE * FROM tbl_Affaires WHERE [DblAffaireId]={}".format(aff_id))
            analytique_db.commit()