'''
Created on 6 juin 2018

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

from core.pde import CSigDb, WincanDb


if __name__ == "__main__":

    CSigDb.server = "TR-POSTGIS-02"
    CSigDb.pwd = "Am5VOMkdFHU7WwrfVOs9"
    WincanDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Wincan\parc_2007\DB\PARC_2007.mdb")

    csig_db = CSigDb(autocommit=False)
    wincan_db = WincanDb(autocommit=False)

    inspname = "175279 MIETESHEIM"

    chantier = csig_db.first("SELECT * FROM t_chantiers WHERE nom='{}' AND id_type_chantier=1;".format(inspname))

    if chantier:
        csig_db.execute("DELETE FROM t_troncons WHERE id_chantier={}".format(chantier.id))
        csig_db.execute("DELETE FROM t_regards WHERE id_chantier={}".format(chantier.id))
        csig_db.execute("DELETE FROM t_chantiers WHERE id={}".format(chantier.id))

    wincan_db.execute("UPDATE SI_T SET SI_Spare3=Null WHERE SI_InspName='{}'".format(inspname))

    csig_db.commit()
    wincan_db.commit()