'''

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

from core.pde import AnalytiqueDb, FacturesDb

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")
    FacturesDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Facture_data.mdb")

    analytique_db = AnalytiqueDb(autocommit=False)
    facture_db = FacturesDb(autocommit=False)

    for num_aff in ("175256/1", "175195/1"):

        num_piece = facture_db.first("SELECT * FROM tblPieceEntete WHERE memObsInterne like '*N° Affaire analytique : {}*'".format(num_aff)).lngPieceId

        facture_db.execute("DELETE * FROM tblPieceEntete WHERE lngPieceId={}".format(num_piece))
        facture_db.execute("DELETE * FROM tblPieceLigne WHERE lngPieceId={}".format(num_piece))
        analytique_db.execute("UPDATE tbl_Tarification SET strStatut = 'A facturer', strNumFacture = Null WHERE strNumFacture='{}'".format(num_piece))

        facture_db.commit()
        analytique_db.commit()