개정판 c85f4698
sql test
Change-Id: I7b962dd24f8562467f1e34a819bcd453303be233
DTI_PID/DTI_PID/AppDocData.py | ||
---|---|---|
4393 | 4393 |
# Get a cursor object |
4394 | 4394 |
cursor = conn.cursor() |
4395 | 4395 |
if self.project.database.db_type == 'SQLite': |
4396 |
import timeit |
|
4397 |
_start = timeit.default_timer() |
|
4396 |
#import timeit
|
|
4397 |
#_start = timeit.default_timer()
|
|
4398 | 4398 |
cursor.execute('begin') |
4399 | 4399 |
|
4400 | 4400 |
sql = "delete from LINE_DATA_LIST where PNID_NO = '{}'".format(drawing_name) |
... | ... | |
4466 | 4466 |
#seconds = _stop - _start |
4467 | 4467 |
#print(seconds) |
4468 | 4468 |
else: |
4469 |
#print('cascade') |
|
4470 | 4469 |
sql = f"delete from LINE_DATA_LIST where PNID_NO = '{drawing_name}'" \ |
4471 | 4470 |
f"delete from TitleBlockValues where Drawings_UID = '{drawing_uid}'" \ |
4472 | 4471 |
f"delete from Components where Drawings_UID='{drawing_uid}'" \ |
내보내기 Unified diff