1495 |
1495 |
VALUES('16b674b2-9c10-4309-9d98-c36035ab0922', '19', 'SeqNumber', 'Tag Seq Number', 'Text Item', 'item.text()[:5]', 3, 1, NULL, 'ALL', 0);
|
1496 |
1496 |
INSERT INTO SymbolAttribute
|
1497 |
1497 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
1498 |
|
VALUES('a5b5ff96-c33c-43e2-91ed-b0e2ad583a53', '19', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else (item.text()[-1:] if len(item.text()) is 6 else item.text()[-2:])', 4, 1, NULL, 'ALL', 0);
|
|
1498 |
VALUES('a5b5ff96-c33c-43e2-91ed-b0e2ad583a53', '19', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else item.text()[5:]', 4, 1, NULL, 'ALL', 0);
|
1499 |
1499 |
INSERT INTO SymbolAttribute
|
1500 |
1500 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
1501 |
|
VALUES('7b22bbba-9323-43af-9ca3-973c0a2a2b37', '21', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else (item.text()[-1:] if len(item.text()) is 6 else item.text()[-2:])', 3, 1, NULL, 'ALL', 0);
|
|
1501 |
VALUES('7b22bbba-9323-43af-9ca3-973c0a2a2b37', '21', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else item.text()[5:]', 3, 1, NULL, 'ALL', 0);
|
1502 |
1502 |
INSERT INTO SymbolAttribute
|
1503 |
1503 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
1504 |
|
VALUES('28a2680b-3125-4cb7-a637-26ec54d594b1', '25', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else (item.text()[-1:] if len(item.text()) is 6 else item.text()[-2:])', 3, 1, NULL, 'ALL', 0);
|
|
1504 |
VALUES('28a2680b-3125-4cb7-a637-26ec54d594b1', '25', 'Suffix', 'Tag Suffix', 'Text Item', ''''' if len(item.text()) is 5 else item.text()[5:]', 3, 1, NULL, 'ALL', 0);
|
1505 |
1505 |
INSERT INTO SymbolAttribute
|
1506 |
1506 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
1507 |
1507 |
VALUES('66cef7da-9f34-4dd8-8f23-b804b2cc6e16', '19', 'SP', 'SP', 'Text Item', 'item.text()', 5, 0, NULL, 'ALL', 0);
|
1508 |
1508 |
INSERT INTO SymbolAttribute
|
1509 |
1509 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
1510 |
1510 |
VALUES('2dda2e01-ad37-4ff3-a4d1-0fbf54944d7b', '19', 'SP Tag', 'SP Tag', 'Text Item', 'item.text()', 6, 1, NULL, 'ALL', 0);
|
|
1511 |
INSERT INTO SymbolAttribute
|
|
1512 |
(UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property)
|
|
1513 |
VALUES('a0b800a7-bb02-458c-8a06-061c86c24b5c', '39', 'Name', 'Name', 'Tag No', 'self.EvaluatedName', 0, 0, NULL, 'ALL', 1);
|
1511 |
1514 |
|
1512 |
1515 |
CREATE TABLE Attributes (
|
1513 |
1516 |
UID VARCHAR (37) PRIMARY KEY,
|