개정판 796ec2a7
db clear
Change-Id: I221c1628d72f0bf06eae18bdd33ffaba481f1f03
| DTI_PID/DTI_PID/AppDocData.py | ||
|---|---|---|
| 4177 | 4177 |
# Get a cursor object |
| 4178 | 4178 |
cursor = conn.cursor() |
| 4179 | 4179 |
|
| 4180 |
sql = "delete from LINE_DATA_LIST" |
|
| 4181 |
cursor.execute(sql) |
|
| 4182 |
sql = "delete from TitleBlockValues" |
|
| 4183 |
cursor.execute(sql) |
|
| 4184 |
sql = "delete from LineNoAttributes" |
|
| 4185 |
cursor.execute(sql) |
|
| 4186 |
sql = "delete from Attributes" |
|
| 4187 |
cursor.execute(sql) |
|
| 4188 |
sql = "delete from Associations" |
|
| 4189 |
cursor.execute(sql) |
|
| 4190 |
sql = "delete from Points" |
|
| 4191 |
cursor.execute(sql) |
|
| 4192 |
sql = "delete from PipeRunItems" |
|
| 4193 |
cursor.execute(sql) |
|
| 4194 |
sql = "delete from PipeRuns" |
|
| 4195 |
cursor.execute(sql) |
|
| 4196 |
sql = "delete from Components" |
|
| 4197 |
cursor.execute(sql) |
|
| 4198 |
sql = "delete from Stream_Line_List" |
|
| 4199 |
cursor.execute(sql) |
|
| 4200 |
sql = "delete from [Views]" |
|
| 4201 |
cursor.execute(sql) |
|
| 4202 |
sql = "delete from Drawings" |
|
| 4203 |
cursor.execute(sql) |
|
| 4204 |
|
|
| 4205 |
""" |
|
| 4180 | 4206 |
for drawing in drawings: |
| 4181 | 4207 |
sql = "delete from LINE_DATA_LIST where PNID_NO = '{}'".format(drawing.UID)
|
| 4182 | 4208 |
cursor.execute(sql) |
| ... | ... | |
| 4226 | 4252 |
f"where l.[uid] = '{drawing.UID}'"
|
| 4227 | 4253 |
cursor.execute(sql) |
| 4228 | 4254 |
''' |
| 4255 |
""" |
|
| 4229 | 4256 |
|
| 4230 | 4257 |
if self.project.database.db_type == 'SQLite': |
| 4231 | 4258 |
cursor.execute('commit')
|
내보내기 Unified diff
