개정판 3f92fe43
issue #628: fix query
Change-Id: I7a38ebe56a92418edb8244e79a6610cbbdcb21f8
| DTI_PID/DTI_PID/LibraryItem.py | ||
|---|---|---|
| 44 | 44 |
with app_doc_data.project.database.connect() as conn: |
| 45 | 45 |
try: |
| 46 | 46 |
cursor = conn.cursor() |
| 47 |
sql = 'delete from Libraries where Symbol_UID=?'
|
|
| 47 |
sql = app_doc_data.project.database.to_sql('delete from Libraries where Symbol_UID=?')
|
|
| 48 | 48 |
param = (str(item.symbol.getUid()), ) |
| 49 | 49 |
cursor.execute(sql, param) |
| 50 | 50 |
conn.commit() |
| ... | ... | |
| 74 | 74 |
with app_doc_data.project.database.connect() as conn: |
| 75 | 75 |
try: |
| 76 | 76 |
cursor = conn.cursor() |
| 77 |
sql = 'insert into Libraries(UID,[User],Symbol_UID) values(?,?,?)'
|
|
| 77 |
sql = app_doc_data.project.database.to_sql('insert into Libraries(UID,[User],Symbol_UID) values(?,?,?)')
|
|
| 78 | 78 |
param = (str(uuid.uuid4()), os.environ['COMPUTERNAME'].upper(), item.symbol.getUid()) |
| 79 | 79 |
cursor.execute(sql, param) |
| 80 | 80 |
conn.commit() |
내보내기 Unified diff
