Implement ancestor axis in SQL 11/139011/6
authordanielhanrahan <daniel.hanrahan@est.tech>
Sun, 1 Sep 2024 23:16:18 +0000 (00:16 +0100)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Tue, 26 Nov 2024 13:55:10 +0000 (13:55 +0000)
commita655c67aa1def9fa5a8924eb6299fb272d6b8f87
treef973a662b1cc4e462e4cf9621cfa49808b7c2222
parent05e97441ad192b69051fbb67263284eb99ee1c41
Implement ancestor axis in SQL

Currenty ancestor axis is implemented in Java using regex,
which then sends a second SQL query to fetch ancestors.
Implementing ancestor axis in SQL is more efficient, and is
needed for limiting/paginating Cps Path Query results.

Issue-ID: CPS-2416
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: I0d8933f86c5a422f366ad7c417a17e263a13960f
cps-ri/src/main/java/org/onap/cps/ri/CpsDataPersistenceServiceImpl.java
cps-ri/src/main/java/org/onap/cps/ri/repository/FragmentQueryBuilder.java
cps-ri/src/main/java/org/onap/cps/ri/repository/FragmentRepository.java
integration-test/src/test/groovy/org/onap/cps/integration/functional/cps/QueryServiceIntegrationSpec.groovy