scripts-pde/resources/test_ctrl2analytique.py

'''

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

from core.pde import ControlesDb, AnalytiqueDb, CommunDb

# 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()