'''
Created on 6 juin 2018

@author: olivier.massot
'''
from core.pde import CSigDb


if __name__ == "__main__":

    CSigDb.server = "TR-POSTGIS-02"
    CSigDb.pwd = "Am5VOMkdFHU7WwrfVOs9"

    csig_db = CSigDb(autocommit=False)

    chantier = csig_db.first("SELECT * FROM t_chantiers WHERE numero=175279 AND id_type_chantier=1;")

    csig_db.execute("UPDATE t_regards SET res_ce = '?' WHERE id_chantier = {}".format(chantier.id))
    csig_db.execute("UPDATE t_troncons SET res_ce = '?', res_itv = '?' WHERE id_chantier = {}".format(chantier.id))

    csig_db.commit()