From f59211026374d757fa307614e2e10f62637cf9f1 Mon Sep 17 00:00:00 2001 From: Murali-P Date: Fri, 23 Mar 2018 10:41:55 +0530 Subject: Csar subset query Merging issue fixed by Moshe Issue-ID: VNFSDK-126 Change-Id: I441cd14e24867bf3d2a65bd3d1c1f35dbf9a5ffb Signed-off-by: Murali-P --- .../marketplace/db/impl/MarketplaceDaoImpl.java | 17 ++++++++++++++++ .../vnfsdk/marketplace/db/inf/IMarketplaceDao.java | 3 +++ .../marketplace/db/mapper/IMarketplaceMapper.java | 3 +++ .../vnfsdk/marketplace/db/wrapper/BaseHandler.java | 2 +- .../resources/mybatis/sql/MarketplaceMapper.xml | 23 +++++++++++++++++++++- .../marketplace/resource/PackageResourceTest.java | 3 ++- 6 files changed, 48 insertions(+), 3 deletions(-) (limited to 'vnfmarket-be') diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/impl/MarketplaceDaoImpl.java b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/impl/MarketplaceDaoImpl.java index 1e152991..79b08afd 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/impl/MarketplaceDaoImpl.java +++ b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/impl/MarketplaceDaoImpl.java @@ -17,6 +17,7 @@ package org.onap.vnfsdk.marketplace.db.impl; import java.util.List; +import java.util.Map; import javax.persistence.PersistenceException; @@ -77,6 +78,22 @@ public class MarketplaceDaoImpl implements IMarketplaceDao { return csars; } + @Override + public List getPackageDataSubset(Map paramsMap) { + SqlSession session = sqlSessionFactory.openSession(); + List csars = null; + try { + IMarketplaceMapper mapper = session.getMapper(IMarketplaceMapper.class); + csars = mapper.getPackageDataSubset(paramsMap); + session.commit(); + } catch(PersistenceException e) { + LOGGER.error("Exception caught {}", e); + } finally { + session.close(); + } + return csars; + } + /** * saving the package data object to the DB using the mybatis. *
diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/inf/IMarketplaceDao.java b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/inf/IMarketplaceDao.java index 1f1d69fc..cf6d7db8 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/inf/IMarketplaceDao.java +++ b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/inf/IMarketplaceDao.java @@ -17,6 +17,7 @@ package org.onap.vnfsdk.marketplace.db.inf; import java.util.List; +import java.util.Map; import org.onap.vnfsdk.marketplace.db.entity.PackageData; @@ -49,6 +50,8 @@ public interface IMarketplaceDao { List getPackageData(String csarID); + List getPackageDataSubset(Map paramsMap); + void deletePackageData(String csarId); void updatePackageData(PackageData oPackageData); diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/mapper/IMarketplaceMapper.java b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/mapper/IMarketplaceMapper.java index b94d442e..df7d5c05 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/mapper/IMarketplaceMapper.java +++ b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/mapper/IMarketplaceMapper.java @@ -17,6 +17,7 @@ package org.onap.vnfsdk.marketplace.db.mapper; import java.util.List; +import java.util.Map; import org.onap.vnfsdk.marketplace.db.entity.PackageData; @@ -49,6 +50,8 @@ public interface IMarketplaceMapper { List getPackageData(String csarId); + List getPackageDataSubset(Map paramsMap); + void deletePackageData(String csarId); void updatePackageData(PackageData oPackageData); diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/wrapper/BaseHandler.java b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/wrapper/BaseHandler.java index 0c5c542f..4e3e117c 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/wrapper/BaseHandler.java +++ b/vnfmarket-be/vnf-sdk-marketplace/src/main/java/org/onap/vnfsdk/marketplace/db/wrapper/BaseHandler.java @@ -86,7 +86,7 @@ public abstract class BaseHandler { throws MarketplaceResourceException { logger.info("BaseHandler:start query data .info:" + MarketplaceDbUtil.objectToString(queryParam)); IMarketplaceDao dao = new MarketplaceDaoImpl(); - List datas = dao.getAllPackageData(); + List datas = dao.getPackageDataSubset(queryParam); logger.info("BaseHandler: query data end .info:" + MarketplaceDbUtil.objectToString(datas)); return datas; } 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} - + + + INSERT INTO CSAR_PACKAGE_TABLE diff --git a/vnfmarket-be/vnf-sdk-marketplace/src/test/java/org/onap/vnfsdk/marketplace/resource/PackageResourceTest.java b/vnfmarket-be/vnf-sdk-marketplace/src/test/java/org/onap/vnfsdk/marketplace/resource/PackageResourceTest.java index d1562f8f..de3ba455 100644 --- a/vnfmarket-be/vnf-sdk-marketplace/src/test/java/org/onap/vnfsdk/marketplace/resource/PackageResourceTest.java +++ b/vnfmarket-be/vnf-sdk-marketplace/src/test/java/org/onap/vnfsdk/marketplace/resource/PackageResourceTest.java @@ -30,6 +30,7 @@ import java.io.InputStream; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.List; +import java.util.Map; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; @@ -153,7 +154,7 @@ public class PackageResourceTest { new MockUp() { @Mock - public List getAllPackageData() { + public List getPackageDataSubset(Map queryParam) { return new ArrayList(); } }; -- cgit 1.2.3-korg