개정판 0fc0c3e6
issue #000: fix template db attr data
Change-Id: I08ac53d2ce717a997b49470dd92085e49ba54e35
| DTI_PID/DTI_PID/Shapes/EngineeringInstrumentItem.py | ||
|---|---|---|
| 280 | 280 |
""" |
| 281 | 281 |
convert instrument data to sql query |
| 282 | 282 |
""" |
| 283 |
import uuid |
|
| 283 | 284 |
from AppDocData import AppDocData |
| 284 | 285 |
|
| 286 |
res = [] |
|
| 285 | 287 |
appDocData = AppDocData.instance() |
| 286 | 288 |
|
| 287 | 289 |
cols = ['UID', 'PNID_NO'] |
| 288 | 290 |
values = ['?','?'] |
| 289 | 291 |
param = [str(self.uid), appDocData.activeDrawing.name] |
| 292 |
sql = 'insert or replace into INSTRUMENT_DATA_LIST({}) values({})'.format(','.join(cols), ','.join(values))
|
|
| 293 |
res.append((sql, tuple(param))) |
|
| 294 |
|
|
| 290 | 295 |
_attrs = self.getAttributes() |
| 291 | 296 |
for key in _attrs.keys(): |
| 292 |
cols.append(key.Attribute)
|
|
| 293 |
values.append('?')
|
|
| 294 |
param.append(_attrs[key])
|
|
| 297 |
cols = ['UID', 'Components_UID', 'SymbolAttribute_UID', 'Value']
|
|
| 298 |
values = ['?', '?', '?', '?']
|
|
| 299 |
param = [str(uuid.uuid4()), str(self.uid), str(key.UID), str(_attrs[key])]
|
|
| 295 | 300 |
|
| 296 |
sql = 'insert or replace into INSTRUMENT_DATA_LIST({}) values({})'.format(','.join(cols), ','.join(values))
|
|
| 301 |
sql = 'insert or replace into Attributes({}) values({})'.format(','.join(cols), ','.join(values))
|
|
| 302 |
res.append((sql, tuple(param))) |
|
| 297 | 303 |
|
| 298 | 304 |
#return (sql, tuple(param)) |
| 299 | 305 |
return None |
내보내기 Unified diff
