'''
Created on 6 juin 2018

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

from core.pde import CSigDb, WincanDb


if __name__ == "__main__":

    ITV_DIR = Path(__file__).parent / "test_qgis_sync_wincan"

    CSigDb.server = "TR-POSTGIS-02"
    CSigDb.pwd = "Am5VOMkdFHU7WwrfVOs9"
    csig_db = CSigDb(autocommit=False)

    WincanDb._path = Path(r"\\h2o\local\4-transversal\BDD\mdb_test\Wincan\parc_2007\DB\PARC_2007.mdb")
    wincan_db = WincanDb(autocommit=False)

    for d in ITV_DIR.dirs():
        if d.name[:2] == "I_":
            d.rename(ITV_DIR / d.name[2:])

#         chantier = csig_db.first("SELECT id FROM t_chantiers WHERE id_type_chantier=1 AND nom ~* '{}\s.*'".format(d.name))
#         if chantier:
        q = wincan_db.execute("""UPDATE S_T INNER JOIN SI_T ON S_T.S_ID = SI_T.SI_Section_ID
                                SET S_T.S_StartNodeCoord_X = Null, S_T.S_StartNodeCoord_Y = Null, S_T.S_EndNodeCoord_X = Null, S_T.S_EndNodeCoord_Y = Null, SI_T.SI_Spare3 = Null
                                WHERE SI_T.SI_InspName Like '{}%';
                                """.format(d.name))

    wincan_db.commit()