개정판 cd3f9b9e
issue #000: hmb save
Change-Id: I01cf30808e78a8b45447bef4b6bd9da6ddcb4412
DTI_PID/DTI_PID/AppDocData.py | ||
---|---|---|
2516 | 2516 |
cursor.execute(sql, params) |
2517 | 2517 |
|
2518 | 2518 |
"""save hmb data value""" |
2519 |
params = [] |
|
2520 |
sql = f"insert into HMB_Value(UID, HMB_LIST_UID, Stream_No_UID, Value, [Case]) values(?,?,?,?,?)" |
|
2521 |
sql = self.project.database.to_sql(sql) |
|
2519 | 2522 |
for data_case in hmb.datas: |
2520 | 2523 |
index = 0 |
2521 | 2524 |
for data in data_case: |
2522 |
sql = f"insert into HMB_Value(UID, HMB_LIST_UID, Stream_No_UID, Value, [Case]) values(?,?,?,?,?)" |
|
2523 |
params = (str(uuid.uuid4()), list_uids[index], hmb.uid, data.value, data.case) |
|
2524 |
cursor.execute(sql, params) |
|
2525 |
params.append((str(uuid.uuid4()), list_uids[index], hmb.uid, data.value, data.case)) |
|
2525 | 2526 |
index = index + 1 |
2527 |
cursor.executemany(sql, tuple(params)) |
|
2526 | 2528 |
|
2527 | 2529 |
self._hmbData = None |
2528 | 2530 |
|
내보내기 Unified diff