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.onap.cps.spi.utils.EscapeUtils;\r
  34 import org.springframework.data.jpa.repository.JpaRepository;\r
  35 import org.springframework.data.jpa.repository.Modifying;\r
  36 import org.springframework.data.jpa.repository.Query;\r
  37 import org.springframework.data.repository.query.Param;\r
  38 import org.springframework.stereotype.Repository;\r
  39 \r
  40 @Repository\r
  41 public interface FragmentRepository extends JpaRepository<FragmentEntity, Long>, FragmentRepositoryCpsPathQuery,\r
  42         FragmentPrefetchRepository {\r
  43 \r
  44     Optional<FragmentEntity> findByAnchorAndXpath(AnchorEntity anchorEntity, String xpath);\r
  45 \r
  46     default FragmentEntity getByAnchorAndXpath(final AnchorEntity anchorEntity, final String xpath) {\r
  47         return findByAnchorAndXpath(anchorEntity, xpath).orElseThrow(() ->\r
  48             new DataNodeNotFoundException(anchorEntity.getDataspace().getName(), anchorEntity.getName(), xpath));\r
  49     }\r
  50 \r
  51     @Query(value = "SELECT * FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)",\r
  52             nativeQuery = true)\r
  53     List<FragmentEntity> findByAnchorIdAndXpathIn(@Param("anchorId") long anchorId,\r
  54                                                   @Param("xpaths") String[] xpaths);\r
  55 \r
  56     default List<FragmentEntity> findByAnchorAndXpathIn(final AnchorEntity anchorEntity,\r
  57                                                         final Collection<String> xpaths) {\r
  58         return findByAnchorIdAndXpathIn(anchorEntity.getId(), xpaths.toArray(new String[0]));\r
  59     }\r
  60 \r
  61     @Query(value = "SELECT fragment.* FROM fragment JOIN anchor ON anchor.id = fragment.anchor_id "\r
  62         + "WHERE dataspace_id = :dataspaceId AND xpath = ANY (:xpaths)", nativeQuery = true)\r
  63     List<FragmentEntity> findByDataspaceIdAndXpathIn(@Param("dataspaceId") int dataspaceId,\r
  64                                                      @Param("xpaths") String[] xpaths);\r
  65 \r
  66     default List<FragmentEntity> findByDataspaceAndXpathIn(final DataspaceEntity dataspaceEntity,\r
  67                                                            final Collection<String> xpaths) {\r
  68         return findByDataspaceIdAndXpathIn(dataspaceEntity.getId(), xpaths.toArray(new String[0]));\r
  69     }\r
  70 \r
  71     @Query(value = "SELECT * FROM fragment WHERE anchor_id IN (:anchorIds)"\r
  72             + " AND xpath = ANY (:xpaths)", nativeQuery = true)\r
  73     List<FragmentEntity> findByAnchorIdsAndXpathIn(@Param("anchorIds") Long[] anchorIds,\r
  74                                                    @Param("xpaths") String[] xpaths);\r
  75 \r
  76     @Query(value = "SELECT * FROM fragment WHERE anchor_id = :anchorId LIMIT 1", nativeQuery = true)\r
  77     Optional<FragmentEntity> findOneByAnchorId(@Param("anchorId") long anchorId);\r
  78 \r
  79     @Modifying\r
  80     @Query(value = "DELETE FROM fragment WHERE anchor_id = ANY (:anchorIds)", nativeQuery = true)\r
  81     void deleteByAnchorIdIn(@Param("anchorIds") long[] anchorIds);\r
  82 \r
  83     default void deleteByAnchorIn(final Collection<AnchorEntity> anchorEntities) {\r
  84         deleteByAnchorIdIn(anchorEntities.stream().map(AnchorEntity::getId).mapToLong(id -> id).toArray());\r
  85     }\r
  86 \r
  87     @Modifying\r
  88     @Query(value = "DELETE FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)", nativeQuery = true)\r
  89     void deleteByAnchorIdAndXpaths(@Param("anchorId") long anchorId, @Param("xpaths") String[] xpaths);\r
  90 \r
  91     default void deleteByAnchorIdAndXpaths(final long anchorId, final Collection<String> xpaths) {\r
  92         deleteByAnchorIdAndXpaths(anchorId, xpaths.toArray(new String[0]));\r
  93     }\r
  94 \r
  95     @Modifying\r
  96     @Query(value = "DELETE FROM fragment f WHERE anchor_id = :anchorId AND xpath LIKE ANY (:xpathPatterns)",\r
  97         nativeQuery = true)\r
  98     void deleteByAnchorIdAndXpathLikeAny(@Param("anchorId") long anchorId,\r
  99                                          @Param("xpathPatterns") String[] xpathPatterns);\r
 100 \r
 101     default void deleteListsByAnchorIdAndXpaths(long anchorId, Collection<String> xpaths) {\r
 102         deleteByAnchorIdAndXpathLikeAny(anchorId,\r
 103                 xpaths.stream().map(xpath -> EscapeUtils.escapeForSqlLike(xpath) + "[@%").toArray(String[]::new));\r
 104     }\r
 105 \r
 106     @Query(value = "SELECT xpath FROM fragment WHERE anchor_id = :anchorId AND xpath = ANY (:xpaths)",\r
 107         nativeQuery = true)\r
 108     List<String> findAllXpathByAnchorIdAndXpathIn(@Param("anchorId") long anchorId,\r
 109                                                   @Param("xpaths") String[] xpaths);\r
 110 \r
 111     default List<String> findAllXpathByAnchorAndXpathIn(final AnchorEntity anchorEntity,\r
 112                                                         final Collection<String> xpaths) {\r
 113         return findAllXpathByAnchorIdAndXpathIn(anchorEntity.getId(), xpaths.toArray(new String[0]));\r
 114     }\r
 115 \r
 116     boolean existsByAnchorAndXpathStartsWith(AnchorEntity anchorEntity, String xpath);\r
 117 \r
 118     @Query("SELECT xpath FROM FragmentEntity WHERE anchor = :anchor AND parentId IS NULL")\r
 119     List<String> findAllXpathByAnchorAndParentIdIsNull(@Param("anchor") AnchorEntity anchorEntity);\r
 120 \r
 121 }\r