Ruslan Kashapov | 7cca029 | 2020-11-24 11:13:43 +0200 | [diff] [blame] | 1 | INSERT INTO DATASPACE (ID, NAME) VALUES |
| 2 | (1001, 'DATASPACE-001'), (1002, 'DATASPACE-002'); |
| 3 | |
| 4 | INSERT INTO SCHEMA_SET (ID, NAME, DATASPACE_ID) VALUES |
Ruslan Kashapov | 6f25d3a | 2021-01-11 15:34:10 +0200 | [diff] [blame] | 5 | (2001, 'SCHEMA-SET-001', 1001), (2002, 'SCHEMA-SET-002', 1001), |
| 6 | (2100, 'SCHEMA-SET-100', 1001), -- for removal, not referenced by anchors |
| 7 | (2101, 'SCHEMA-SET-101', 1001); -- for removal, having anchor and data associated |
Ruslan Kashapov | 7cca029 | 2020-11-24 11:13:43 +0200 | [diff] [blame] | 8 | |
Ruslan Kashapov | 4ab9d0e | 2020-12-10 10:49:59 +0200 | [diff] [blame] | 9 | INSERT INTO YANG_RESOURCE (ID, NAME, CONTENT, CHECKSUM) VALUES |
| 10 | (3001, 'module1@2020-02-02.yang', 'CONTENT-001', '877e65a9f36d54e7702c3f073f6bc42b'), |
| 11 | (3002, 'module2@2020-02-02.yang', 'CONTENT-002', '88892586b1f23fe8c1595759784a18f8'), |
| 12 | (3003, 'module3@2020-02-02.yang', 'CONTENT-003', 'fc5740499a09a48e0c95d6fc45d4bde8'), |
Ruslan Kashapov | 6f25d3a | 2021-01-11 15:34:10 +0200 | [diff] [blame] | 13 | (3004, 'module4@2020-02-02.yang', 'CONTENT-004', '3801280fe532f5cbf535695cf6122026'), |
| 14 | (3100, 'orphan@2020-02-02.yang', 'ORPHAN', 'checksum'); -- for auto-removal as orphan |
Ruslan Kashapov | 7cca029 | 2020-11-24 11:13:43 +0200 | [diff] [blame] | 15 | |
| 16 | INSERT INTO SCHEMA_SET_YANG_RESOURCES (SCHEMA_SET_ID, YANG_RESOURCE_ID) VALUES |
Ruslan Kashapov | 6f25d3a | 2021-01-11 15:34:10 +0200 | [diff] [blame] | 17 | (2001, 3001), (2001, 3002), |
| 18 | (2002, 3003), (2002, 3004), |
| 19 | (2100, 3003), (2100, 3100), -- orphan removal case |
| 20 | (2101, 3003), (2101, 3004); |
| 21 | |
| 22 | INSERT INTO ANCHOR (ID, NAME, DATASPACE_ID, SCHEMA_SET_ID) VALUES -- anchors for removal |
| 23 | (6001, 'ANCHOR1', 1001, 2101), |
| 24 | (6002, 'ANCHOR2', 1001, 2101); |
| 25 | |
| 26 | INSERT INTO FRAGMENT (ID, XPATH, ANCHOR_ID, DATASPACE_ID) VALUES |
| 27 | (7001, '/XPATH', 6001, 1001); |