diff options
| author |   Toine Siebelink <toine.siebelink@est.tech> | 2021-11-09 10:57:21 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2021-11-09 10:57:21 +0000 |
| commit | 7a9e0f81770f2aa2793e241cee3a3c6c9bb40d9d (patch) | |
| tree | d657b7f8d6c9b2f842d0ce5fece438cecea777de /cps-ri/src/test/resources/data/anchors-schemaset-modules.sql | |
| parent | 8109cfb8e6134ce9de12a3e3b3101aa5dd65fe00 (diff) | |
| parent | 6804157f3ee5b1268e53ae86e4767ee267d48eec (diff) | |
Merge "Fix for get anchor identifiers by module names"
Diffstat (limited to 'cps-ri/src/test/resources/data/anchors-schemaset-modules.sql')
| -rw-r--r-- | cps-ri/src/test/resources/data/anchors-schemaset-modules.sql | 36 |
1 files changed, 20 insertions, 16 deletions
diff --git a/cps-ri/src/test/resources/data/anchors-schemaset-modules.sql b/cps-ri/src/test/resources/data/anchors-schemaset-modules.sql index d2b67f5aea..45119dec0f 100644 --- a/cps-ri/src/test/resources/data/anchors-schemaset-modules.sql +++ b/cps-ri/src/test/resources/data/anchors-schemaset-modules.sql @@ -19,27 +19,31 @@ */ INSERT INTO DATASPACE (ID, NAME) VALUES - (1001, 'DATASPACE-001'), (1002, 'DATASPACE-002'); + (1001, 'dataspace-1'), (1002, 'dataspace-2'); INSERT INTO SCHEMA_SET (ID, NAME, DATASPACE_ID) VALUES - (2001, 'SCHEMA-SET-001', 1001), - (2002, 'SCHEMA-SET-002', 1002), - (2003, 'SCHEMA-SET-003', 1001), - (2004, 'SCHEMA-SET-004', 1001); + (2001, 'schema-set-1', 1001), + (2002, 'schema-set-2', 1001), + (2003, 'schema-set-3', 1001), + (2004, 'schema-set-4', 1002); INSERT INTO YANG_RESOURCE (ID, NAME, CONTENT, CHECKSUM, MODULE_NAME, REVISION) VALUES - (3001, 'module1@2020-02-02.yang', 'CONTENT-001', 'checksum1','MODULE-NAME-001',null), - (3002, 'module2@2020-02-02.yang', 'CONTENT-002', 'checksum2','MODULE-NAME-002','REVISION-002'), - (3003, 'module3@2020-02-02.yang', 'CONTENT-003', 'checksum3','MODULE-NAME-003','REVISION-003'), - (3004, 'module4@2020-02-02.yang', 'CONTENT-004', 'checksum4','MODULE-NAME-004','REVISION-004'), - (3005, 'module5@2020-03-02.yang', 'CONTENT-005', 'checksum5','MODULE-NAME-002','REVISION-003'); + (3001, 'module1@revA.yang', 'some-content', 'checksum1','module-name-1','revA'), + (3002, 'module2@revA.yang', 'some-content', 'checksum2','module-name-2','revA'), + (3003, 'module2@revB.yang', 'some-content', 'checksum3','module-name-2','revB'), + (3004, 'module3@revA.yang', 'some-content', 'checksum4','module-name-3','revA'); INSERT INTO SCHEMA_SET_YANG_RESOURCES (SCHEMA_SET_ID, YANG_RESOURCE_ID) VALUES - (2001, 3001), (2002, 3002), - (2001, 3003), (2002, 3003), - (2003, 3004), (2004, 3005); + (2001, 3001), --schema-set-1(anchor-1) has modules module1@revA, module2@revA + (2001, 3002), + (2002, 3001), --schema-set-2(anchor-2) has modules module1@revA, module2@revB + (2002, 3003), + (2003, 3002), --schema-set-3(anchor-3) has modules module2@revA, module2@revB + (2003, 3003), + (2004, 3001); --schema-set-4(anchor-4) has module module1@revA but in other dataspace INSERT INTO ANCHOR (ID, NAME, DATASPACE_ID, SCHEMA_SET_ID) VALUES - (6001, 'ANCHOR1', 1001, 2001), - (6002, 'ANCHOR2', 1001, 2002), - (6003, 'ANCHOR3', 1001, 2004); + (6001, 'anchor-1', 1001, 2001), + (6002, 'anchor-2', 1001, 2002), + (6003, 'anchor-3', 1001, 2003), + (6005, 'anchor-4', 1002, 2004); |