개정판 456acf69
issue #622: create dbupdate method
| DTI_PID/DTI_PID/AppDocData.py | ||
|---|---|---|
| 2842 | 2842 |
pidNo = self.activeDrawing.name |
| 2843 | 2843 |
sql = "delete from LINE_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
| 2844 | 2844 |
cursor.execute(sql) |
| 2845 |
#sql = "delete from EQUIPMENT_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
|
| 2846 |
#cursor.execute(sql)
|
|
| 2847 |
#sql = "delete from VALVE_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
|
| 2848 |
#cursor.execute(sql)
|
|
| 2845 |
sql = "delete from EQUIPMENT_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
|
| 2846 |
cursor.execute(sql) |
|
| 2847 |
sql = "delete from VALVE_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
|
| 2848 |
cursor.execute(sql) |
|
| 2849 | 2849 |
sql = "delete from INSTRUMENT_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
| 2850 | 2850 |
cursor.execute(sql) |
| 2851 | 2851 |
sql = "delete from NOTE_DATA_LIST where PNID_NO = '{}'".format(pidNo)
|
| 2852 | 2852 |
cursor.execute(sql) |
| 2853 |
sql = "delete from TitleBlockValues where Drawings_UID = '{}'".format(pidNo)
|
|
| 2854 |
cursor.execute(sql) |
|
| 2853 | 2855 |
|
| 2854 | 2856 |
conn.commit() |
| 2855 | 2857 |
|
내보내기 Unified diff
