Code Review
/
cps.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Delete schema set - persistence layer
[cps.git]
/
cps-ri
/
src
/
main
/
java
/
org
/
onap
/
cps
/
spi
/
repository
/
YangResourceRepository.java
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
47d3ea3
..
25d7689
100644
(file)
--- 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
@@
-22,13
+22,19
@@
package org.onap.cps.spi.repository;
import java.util.List;
import java.util.Set;
import javax.validation.constraints.NotNull;
import java.util.List;
import java.util.Set;
import javax.validation.constraints.NotNull;
-import org.onap.cps.spi.entities.YangResource;
+import org.onap.cps.spi.entities.YangResource
Entity
;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
@Repository
import org.springframework.stereotype.Repository;
@Repository
-public interface YangResourceRepository extends JpaRepository<YangResource, Long> {
+public interface YangResourceRepository extends JpaRepository<YangResource
Entity
, Long> {
- List<YangResource> findAllByChecksumIn(@NotNull Set<String> checksum);
+ List<YangResource
Entity
> findAllByChecksumIn(@NotNull Set<String> checksum);
+ @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)
+ void deleteOrphans();
}
}