| 123456789101112131415161718192021 |
- '''
- 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()
|
