diff options
Diffstat (limited to 'vnfmarket-be/vnf-sdk-marketplace/src/main/resources')
-rw-r--r-- | vnfmarket-be/vnf-sdk-marketplace/src/main/resources/mybatis/sql/MarketplaceMapper.xml | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/main/resources/mybatis/sql/MarketplaceMapper.xml b/vnfmarket-be/vnf-sdk-marketplace/src/main/resources/mybatis/sql/MarketplaceMapper.xml index aeaa4a47..7d76b998 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/main/resources/mybatis/sql/MarketplaceMapper.xml +++ b/vnfmarket-be/vnf-sdk-marketplace/src/main/resources/mybatis/sql/MarketplaceMapper.xml @@ -32,7 +32,28 @@ WHERE CSARID=#{csarId} </select> - + + <select id="getPackageDataSubset" resultType="org.onap.vnfsdk.marketplace.db.entity.PackageData" parameterType="java.util.Map"> + SELECT * FROM CSAR_PACKAGE_TABLE + <where> + <if test="name != null"> + NAME like #{name} + </if> + <if test="version != null"> + AND VERSION like #{version} + </if> + <if test="deletionPending != null"> + AND DELETIONPENDING like #{deletionPending} + </if> + <if test="type != null"> + AND TYPE like #{type} + </if> + <if test="provider != null"> + AND PROVIDER like #{provider} + </if> + </where> + </select> + <insert id="savePackageData" parameterType="org.onap.vnfsdk.marketplace.db.entity.PackageData"> INSERT INTO CSAR_PACKAGE_TABLE |