diff options
| author |   ToineSiebelink <toine.siebelink@est.tech> | 2022-08-18 15:03:16 +0100 |
|---|---|---|
| committer | ToineSiebelink <toine.siebelink@est.tech> | 2022-08-22 13:12:49 +0100 |
| commit | ad3b6214229bd71d3ec7a79f06078d7e190cc7e9 (patch) | |
| tree | d3f63657015e752e5dd32f548246795c3fecc88c /cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java | |
| parent | c68b5f0b8ddfe0ecc7f6015de7fcd11fdf693903 (diff) | |
Performance Improvement: Retreive Yang Resources
Native query to more efficiently get all yangResourceIds
Combined Hibernate Fragment Repository with Native impl.
Issue-ID: CPS-1206
Issue-ID: CPS-1126
Signed-off-by: ToineSiebelink <toine.siebelink@est.tech>
Change-Id: I93fbd5347dd8f9fc48d44e69e47e8aed2d7ac030
Diffstat (limited to 'cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java')
| -rw-r--r-- | cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java b/cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java index 98306d868..6ca4fff4f 100644 --- a/cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java +++ b/cps-ri/src/main/java/org/onap/cps/spi/repository/YangResourceRepository.java @@ -34,7 +34,7 @@ import org.springframework.stereotype.Repository; @Repository public interface YangResourceRepository extends JpaRepository<YangResourceEntity, Long>, - SchemaSetYangResourceRepository { + YangResourceNativeRepository, SchemaSetYangResourceRepository { List<YangResourceEntity> findAllByChecksumIn(@NotNull Set<String> checksum); @@ -91,10 +91,6 @@ public interface YangResourceRepository extends JpaRepository<YangResourceEntity Set<YangResourceModuleReference> findAllModuleReferencesByDataspaceAndModuleNames( @Param("dataspaceName") String dataspaceName, @Param("moduleNames") Collection<String> moduleNames); - - @Query(value = "SELECT id FROM yang_resource WHERE module_name=:name and revision=:revision", nativeQuery = true) - Long getIdByModuleNameAndRevision(@Param("name") String moduleName, @Param("revision") String revision); - @Modifying @Query(value = "DELETE FROM yang_resource yr WHERE NOT EXISTS " + "(SELECT 1 FROM schema_set_yang_resources ssyr WHERE ssyr.yang_resource_id = yr.id)", nativeQuery = true) |