summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/test/resources/data/fragment.sql
diff options
context:
space:
mode:
authorRishi Chail <rishi.chail@est.tech>2021-04-30 13:23:33 +0000
committerGerrit Code Review <gerrit@onap.org>2021-04-30 13:23:33 +0000
commit78d64c160e02268afe9bb4770708778b9078c37e (patch)
treea4896924806417580a8302c982126de5b2271b6d /cps-ri/src/test/resources/data/fragment.sql
parent01c3a056d76c8ad87bbfe8d15a4eb5570f9c0d4e (diff)
parent6c9c100daba10717641a08b6c6dc3ec3b51c56a8 (diff)
Merge "Implement cps path query to get ancestor by schema node identifier Cleaned up some legcy issues in related testware"
Diffstat (limited to 'cps-ri/src/test/resources/data/fragment.sql')
-rwxr-xr-xcps-ri/src/test/resources/data/fragment.sql11
1 files changed, 10 insertions, 1 deletions
diff --git a/cps-ri/src/test/resources/data/fragment.sql b/cps-ri/src/test/resources/data/fragment.sql
index 3e2ae8157..95cb3c79a 100755
--- a/cps-ri/src/test/resources/data/fragment.sql
+++ b/cps-ri/src/test/resources/data/fragment.sql
@@ -31,4 +31,13 @@ INSERT INTO FRAGMENT (ID, DATASPACE_ID, ANCHOR_ID, PARENT_ID, XPATH, ATTRIBUTES)
(4206, 1001, 3003, null, '/parent-201', '{"leaf-value": "original"}'),
(4207, 1001, 3003, 4206, '/parent-201/child-202', '{"common-leaf-name": "common-leaf other value", "common-leaf-name-int" : 5}'),
(4208, 1001, 3003, 4206, '/parent-201/child-203[@key1="A" and @key2=1]', '{"key1": "A", "key2" : 1, "other-leaf" : "leaf value"}'),
- (4209, 1001, 3003, 4206, '/parent-201/child-203[@key1="A" and @key2=2]', '{"key1": "A", "key2" : 2, "other-leaf" : "other value"}'); \ No newline at end of file
+ (4209, 1001, 3003, 4206, '/parent-201/child-203[@key1="A" and @key2=2]', '{"key1": "A", "key2" : 2, "other-leaf" : "other value"}');
+
+INSERT INTO FRAGMENT (ID, DATASPACE_ID, ANCHOR_ID, PARENT_ID, XPATH) VALUES
+ (1, 1001, 3001, null, '/bookstore'),
+ (2, 1001, 3001, 1, '/bookstore/books'),
+ (3, 1001, 3001, 1, '/bookstore/magazines'),
+ (4, 1001, 3001, 2, '/bookstore/books/categories[@name="SciFi"]'),
+ (5, 1001, 3001, 3, '/bookstore/magazines/categories[@name="kids"]'),
+ (6, 1001, 3001, 4, '/bookstore/books/categories[@name="SciFi"]/books'),
+ (7, 1001, 3001, 6, '/bookstore/magazines/categories[@name="kids"]/books');