Handle special characters in CpsPath queries (CPS-1760 #2) 32/135132/12
authordanielhanrahan <daniel.hanrahan@est.tech>
Fri, 23 Jun 2023 13:37:12 +0000 (14:37 +0100)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Mon, 10 Jul 2023 11:20:30 +0000 (12:20 +0100)
commite05a59a2361394d6fc4a93193b0ed35ba305fcf8
treecc5a48a39bdee3a66bb82161a9d4a6e8b5868a99
parent5769fae8b2cf4246bb2fd079dfd7b8db8130fcc0
Handle special characters in CpsPath queries (CPS-1760 #2)

This fixes issues with special characters for CPS-500, CPS-1756,
CPS-1758, and CPS-1760. It also improves query performance.

- use SQL LIKE instead of regex in Cps Path queries

Issue-ID: CPS-1763
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: I5c179882bfba71d3b009c60059e9073f46227e7d
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentQueryBuilder.java
cps-ri/src/test/groovy/org/onap/cps/spi/utils/EscapeUtilsSpec.groovy
docs/cps-path.rst
integration-test/src/test/groovy/org/onap/cps/integration/functional/CpsQueryServiceIntegrationSpec.groovy
integration-test/src/test/groovy/org/onap/cps/integration/performance/cps/QueryPerfTest.groovy