scripts-pde/resources/test_analytique2facture.py

'''

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

from core.pde import AnalytiqueDb, FacturesDb


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