cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentRepository.java

   1 /*\r
   2  * ============LICENSE_START=======================================================\r
   3  * Copyright (C) 2021-2023 Nordix Foundation.\r
   4  * Modifications Copyright (C) 2020-2021 Bell Canada.\r
   5  * Modifications Copyright (C) 2020-2021 Pantheon.tech.\r
   6  * Modifications Copyright (C) 2023 TechMahindra Ltd.\r
   7  * ================================================================================\r
   8  * Licensed under the Apache License, Version 2.0 (the "License");\r
   9  * you may not use this file except in compliance with the License.\r
  10  * You may obtain a copy of the License at\r
  11  *\r
  12  *      http://www.apache.org/licenses/LICENSE-2.0\r
  13  *\r
  14  * Unless required by applicable law or agreed to in writing, software\r
  15  * distributed under the License is distributed on an "AS IS" BASIS,\r
  16  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\r
  17  * See the License for the specific language governing permissions and\r
  18  * limitations under the License.\r
  19  *\r
  20  * SPDX-License-Identifier: Apache-2.0\r
  21  * ============LICENSE_END=========================================================\r
  22  */\r
  23 \r
  24 package org.onap.cps.spi.repository;\r
  25 \r
  26 import java.util.Collection;\r
  27 import java.util.List;\r
  28 import java.util.Optional;\r
  29 import org.onap.cps.spi.entities.AnchorEntity;\r
  30 import org.onap.cps.spi.entities.DataspaceEntity;\r
  31 import org.onap.cps.spi.entities.FragmentEntity;\r
  32 import org.onap.cps.spi.exceptions.DataNodeNotFoundException;\r
  33 import org.springframework.data.jpa.repository.JpaRepository;\r
  34 import org.springframework.data.jpa.repository.Modifying;\r
  35 import org.springframework.data.jpa.repository.Query;\r
  36 import org.springframework.data.repository.query.Param;\r
  37 import org.springframework.stereotype.Repository;\r
  38 \r
  39 @Repository\r
  40 public interface FragmentRepository extends JpaRepository<FragmentEntity, Long>, FragmentRepositoryCpsPathQuery,\r
  41         FragmentPrefetchRepository {\r
  42 \r
  43     Optional<FragmentEntity> findByAnchorAndXpath(AnchorEntity anchorEntity, String xpath);\r
  44 \r
  45     default FragmentEntity getByAnchorAndXpath(final AnchorEntity anchorEntity, final String xpath) {\r
  46         return findByAnchorAndXpath(anchorEntity, xpath).orElseThrow(() ->\r
  47             new DataNodeNotFoundException(anchorEntity.getDataspace().getName(), anchorEntity.getName(), xpath));\r
  48     }\r
  49 \r
  50     @Query(value = "SELECT * FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)",\r
  51             nativeQuery = true)\r
  52     List<FragmentEntity> findByAnchorIdAndXpathIn(@Param("anchorId") long anchorId,\r
  53                                                   @Param("xpaths") String[] xpaths);\r
  54 \r
  55     default List<FragmentEntity> findByAnchorAndXpathIn(final AnchorEntity anchorEntity,\r
  56                                                         final Collection<String> xpaths) {\r
  57         return findByAnchorIdAndXpathIn(anchorEntity.getId(), xpaths.toArray(new String[0]));\r
  58     }\r
  59 \r
  60     @Query(value = "SELECT fragment.* FROM fragment JOIN anchor ON anchor.id = fragment.anchor_id "\r
  61         + "WHERE dataspace_id = :dataspaceId AND xpath = ANY (:xpaths)", nativeQuery = true)\r
  62     List<FragmentEntity> findByDataspaceIdAndXpathIn(@Param("dataspaceId") int dataspaceId,\r
  63                                                      @Param("xpaths") String[] xpaths);\r
  64 \r
  65     default List<FragmentEntity> findByDataspaceAndXpathIn(final DataspaceEntity dataspaceEntity,\r
  66                                                            final Collection<String> xpaths) {\r
  67         return findByDataspaceIdAndXpathIn(dataspaceEntity.getId(), xpaths.toArray(new String[0]));\r
  68     }\r
  69 \r
  70     boolean existsByAnchorId(long anchorId);\r
  71 \r
  72     @Query(value = "SELECT * FROM fragment WHERE anchor_id = :anchorId LIMIT 1", nativeQuery = true)\r
  73     Optional<FragmentEntity> findOneByAnchorId(@Param("anchorId") long anchorId);\r
  74 \r
  75     @Modifying\r
  76     @Query(value = "DELETE FROM fragment WHERE anchor_id = ANY (:anchorIds)", nativeQuery = true)\r
  77     void deleteByAnchorIdIn(@Param("anchorIds") long[] anchorIds);\r
  78 \r
  79     default void deleteByAnchorIn(final Collection<AnchorEntity> anchorEntities) {\r
  80         deleteByAnchorIdIn(anchorEntities.stream().map(AnchorEntity::getId).mapToLong(id -> id).toArray());\r
  81     }\r
  82 \r
  83     @Modifying\r
  84     @Query(value = "DELETE FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)", nativeQuery = true)\r
  85     void deleteByAnchorIdAndXpaths(@Param("anchorId") long anchorId, @Param("xpaths") String[] xpaths);\r
  86 \r
  87     default void deleteByAnchorIdAndXpaths(final long anchorId, final Collection<String> xpaths) {\r
  88         deleteByAnchorIdAndXpaths(anchorId, xpaths.toArray(new String[0]));\r
  89     }\r
  90 \r
  91     @Modifying\r
  92     @Query(value = "DELETE FROM fragment f WHERE anchor_id = :anchorId AND xpath LIKE ANY (:xpathPatterns)",\r
  93         nativeQuery = true)\r
  94     void deleteByAnchorIdAndXpathLikeAny(@Param("anchorId") long anchorId,\r
  95                                          @Param("xpathPatterns") String[] xpathPatterns);\r
  96 \r
  97     default void deleteListsByAnchorIdAndXpaths(long anchorId, Collection<String> xpaths) {\r
  98         final String[] listXpathPatterns = xpaths.stream().map(xpath -> xpath + "[%").toArray(String[]::new);\r
  99         deleteByAnchorIdAndXpathLikeAny(anchorId, listXpathPatterns);\r
 100     }\r
 101 \r
 102     @Query(value = "SELECT xpath FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)",\r
 103         nativeQuery = true)\r
 104     List<String> findAllXpathByAnchorIdAndXpathIn(@Param("anchorId") long anchorId,\r
 105                                                   @Param("xpaths") String[] xpaths);\r
 106 \r
 107     default List<String> findAllXpathByAnchorAndXpathIn(final AnchorEntity anchorEntity,\r
 108                                                         final Collection<String> xpaths) {\r
 109         return findAllXpathByAnchorIdAndXpathIn(anchorEntity.getId(), xpaths.toArray(new String[0]));\r
 110     }\r
 111 \r
 112     boolean existsByAnchorAndXpathStartsWith(AnchorEntity anchorEntity, String xpath);\r
 113 \r
 114     @Query("SELECT xpath FROM FragmentEntity WHERE anchor = :anchor AND parentId IS NULL")\r
 115     List<String> findAllXpathByAnchorAndParentIdIsNull(@Param("anchor") AnchorEntity anchorEntity);\r
 116 \r
 117 }\r