2 * Copyright © 2017-2018 AT&T Intellectual Property.
3 * Modifications Copyright © 2019 Bell Canada.
5 * Licensed under the Apache License, Version 2.0 (the "License");
6 * you may not use this file except in compliance with the License.
7 * You may obtain a copy of the License at
9 * http://www.apache.org/licenses/LICENSE-2.0
11 * Unless required by applicable law or agreed to in writing, software
12 * distributed under the License is distributed on an "AS IS" BASIS,
13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14 * See the License for the specific language governing permissions and
15 * limitations under the License.
18 package org.onap.ccsdk.cds.blueprintsprocessor.db.primary.repository
20 import org.jetbrains.annotations.NotNull
21 import org.onap.ccsdk.cds.blueprintsprocessor.db.primary.domain.BlueprintModel
22 import org.springframework.data.jpa.repository.JpaRepository
23 import org.springframework.data.jpa.repository.Query
24 import org.springframework.data.repository.query.Param
25 import org.springframework.stereotype.Repository
26 import java.util.Optional
27 import javax.transaction.Transactional
33 interface BlueprintModelRepository : JpaRepository<BlueprintModel, String> {
36 * This is a findById method
41 override fun findById(id: String): Optional<BlueprintModel>
44 * This is a findByArtifactNameAndArtifactVersion method
46 * @param artifactName artifactName
47 * @param artifactVersion artifactVersion
50 fun findByArtifactNameAndArtifactVersion(artifactName: String, artifactVersion: String): BlueprintModel?
53 * Find the Blueprint UUID (blueprint_model_id) for a given artifactName/Version
55 * @param artifactName artifactName
56 * @param artifactVersion artifactVersion
59 @Query("SELECT m.id FROM BlueprintModel m WHERE m.artifactName = :artifactName AND m.artifactVersion = :artifactVersion")
60 fun findIdByArtifactNameAndArtifactVersion(@Param("artifactName") artifactName: String, @Param("artifactVersion") artifactVersion: String): String?
63 * This is a findTopByArtifactNameOrderByArtifactIdDesc method
65 * @param artifactName artifactName
68 fun findTopByArtifactNameOrderByArtifactVersionDesc(artifactName: String): BlueprintModel?
71 * This is a findTopByArtifactName method
73 * @param artifactName artifactName
76 fun findTopByArtifactName(artifactName: String): List<BlueprintModel>
79 * This is a findByTagsContainingIgnoreCase method
84 fun findByTagsContainingIgnoreCase(tags: String): List<BlueprintModel>
87 * This is a deleteByArtifactNameAndArtifactVersion method
89 * @param artifactName artifactName
90 * @param artifactVersion artifactVersion
93 fun deleteByArtifactNameAndArtifactVersion(artifactName: String, artifactVersion: String)
96 * This is a deleteById method
100 override fun deleteById(@NotNull id: String)