Add test case for getHeatTemplate

Add test case for getHeatTemplage.
Fix file ending character by removing ctrl+M character.

Change-Id: Ia25b54b80bdd7e1edb8a96b58b8f3fe9ce020dc7
Issue-ID: SO-360
Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>

1 files changed, 955 insertions, 902 deletions

diff --git a/mso-catalog-db/src/test/java/org/openecomp/mso/db/catalog/test/CatalogDatabaseTest.java b/mso-catalog-db/src/test/java/org/openecomp/mso/db/catalog/test/CatalogDatabaseTest.java
index 9b0f120222..5e6ccc4a86 100644
--- a/mso-catalog-db/src/test/java/org/openecomp/mso/db/catalog/test/CatalogDatabaseTest.java
+++ b/mso-catalog-db/src/test/java/org/openecomp/mso/db/catalog/test/CatalogDatabaseTest.java
@@ -1,902 +1,955 @@
-/*-

- * ============LICENSE_START=======================================================

- * ONAP - SO

- * ================================================================================

- * Copyright (C) 2017 Huawei Technologies Co., Ltd. All rights reserved.

- * ================================================================================

- * Licensed under the Apache License, Version 2.0 (the "License");

- * you may not use this file except in compliance with the License.

- * You may obtain a copy of the License at

- * 

- *      http://www.apache.org/licenses/LICENSE-2.0

- * 

- * Unless required by applicable law or agreed to in writing, software

- * distributed under the License is distributed on an "AS IS" BASIS,

- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- * See the License for the specific language governing permissions and

- * limitations under the License.

- * ============LICENSE_END=========================================================

- */

-

-package org.openecomp.mso.db.catalog.test;

-

-import static org.junit.Assert.assertEquals;

-import static org.junit.Assert.assertFalse;

-import static org.junit.Assert.assertTrue;

-

-import java.io.Serializable;

-import java.math.BigDecimal;

-import java.math.BigInteger;

-import java.sql.Connection;

-import java.util.ArrayList;

-import java.util.Arrays;

-import java.util.Calendar;

-import java.util.Collection;

-import java.util.Date;

-import java.util.HashMap;

-import java.util.HashSet;

-import java.util.Iterator;

-import java.util.List;

-import java.util.Locale;

-import java.util.Map;

-import java.util.Set;

-

-import mockit.Mock;

-import mockit.MockUp;

-import org.hibernate.CacheMode;

-import org.hibernate.Criteria;

-import org.hibernate.Filter;

-import org.hibernate.FlushMode;

-import org.hibernate.HibernateException;

-import org.hibernate.IdentifierLoadAccess;

-import org.hibernate.LobHelper;

-import org.hibernate.LockMode;

-import org.hibernate.LockOptions;

-import org.hibernate.NaturalIdLoadAccess;

-import org.hibernate.Query;

-import org.hibernate.ReplicationMode;

-import org.hibernate.SQLQuery;

-import org.hibernate.ScrollMode;

-import org.hibernate.ScrollableResults;

-import org.hibernate.Session;

-import org.hibernate.SessionEventListener;

-import org.hibernate.SessionFactory;

-import org.hibernate.SharedSessionBuilder;

-import org.hibernate.SimpleNaturalIdLoadAccess;

-import org.hibernate.Transaction;

-import org.hibernate.TypeHelper;

-import org.hibernate.UnknownProfileException;

-import org.hibernate.jdbc.ReturningWork;

-import org.hibernate.jdbc.Work;

-import org.hibernate.metamodel.source.annotations.xml.mocker.MockHelper;

-import org.hibernate.procedure.ProcedureCall;

-import org.hibernate.stat.SessionStatistics;

-import org.hibernate.transform.ResultTransformer;

-import org.hibernate.type.Type;

-import org.junit.Before;

-import org.junit.Test;

-import org.openecomp.mso.db.catalog.CatalogDatabase;

-import org.openecomp.mso.db.catalog.beans.AllottedResource;

-import org.openecomp.mso.db.catalog.beans.AllottedResourceCustomization;

-import org.openecomp.mso.db.catalog.beans.HeatEnvironment;

-import org.openecomp.mso.db.catalog.beans.HeatFiles;

-import org.openecomp.mso.db.catalog.beans.HeatTemplate;

-import org.openecomp.mso.db.catalog.beans.HeatTemplateParam;

-import org.openecomp.mso.db.catalog.beans.NetworkResource;

-import org.openecomp.mso.db.catalog.beans.NetworkResourceCustomization;

-import org.openecomp.mso.db.catalog.beans.Service;

-import org.openecomp.mso.db.catalog.beans.ServiceRecipe;

-import org.openecomp.mso.db.catalog.beans.ServiceToResourceCustomization;

-import org.openecomp.mso.db.catalog.beans.TempNetworkHeatTemplateLookup;

-import org.openecomp.mso.db.catalog.beans.ToscaCsar;

-import org.openecomp.mso.db.catalog.beans.VfModule;

-import org.openecomp.mso.db.catalog.beans.VfModuleCustomization;

-import org.openecomp.mso.db.catalog.beans.VfModuleToHeatFiles;

-import org.openecomp.mso.db.catalog.beans.VnfComponent;

-import org.openecomp.mso.db.catalog.beans.VnfComponentsRecipe;

-import org.openecomp.mso.db.catalog.beans.VnfRecipe;

-import org.openecomp.mso.db.catalog.beans.VnfResource;

-import org.openecomp.mso.db.catalog.beans.VnfResourceCustomization;

-import org.openecomp.mso.db.catalog.utils.RecordNotFoundException;

-

-public class CatalogDatabaseTest {

-

-    CatalogDatabase cd = null;

-

-    @Before

-    public void setup(){

-        cd = CatalogDatabase.getInstance();

-    }

-

-

-    @Test

-    public void getAllHeatTemplatesTest(){

-

-        MockUp<Query> mockUpQuery = new MockUp<Query>() {

-            @Mock

-            public List<HeatTemplate> list() {

-                HeatTemplate heatTemplate = new HeatTemplate();

-                return Arrays.asList(heatTemplate);

-            }

-        };

-

-        MockUp<Session> mockedSession = new MockUp<Session>() {

-            @Mock

-            public Query createQuery(String hql) {

-                return mockUpQuery.getMockInstance();

-            }

-        };

-

-        new MockUp<CatalogDatabase>() {

-            @Mock

-            private Session getSession() {

-                return mockedSession.getMockInstance();

-            }

-        };

-

-        List <HeatTemplate> list = cd.getAllHeatTemplates();

-        assertEquals(list.size(), 1);

-    }

-

-    @Test

-    public void getHeatTemplateByIdTest(){

-

-        MockUp<Session> mockedSession = new MockUp<Session>() {

-            @Mock

-            public Object get(Class cls, Serializable id) {

-                HeatTemplate heatTemplate = new HeatTemplate();

-                heatTemplate.setAsdcUuid("123-uuid");

-                return heatTemplate;

-            }

-        };

-

-        new MockUp<CatalogDatabase>() {

-            @Mock

-            private Session getSession() {

-                return mockedSession.getMockInstance();

-            }

-        };

-

-        HeatTemplate ht = cd.getHeatTemplate(10);

-        assertEquals("123-uuid", ht.getAsdcUuid());

-    }

-

-    @Test

-    public void getHeatTemplateByNameEmptyListTest(){

-

-        MockUp<Query> mockUpQuery = new MockUp<Query>() {

-            @Mock

-            public List<HeatTemplate> list() {

-                HeatTemplate heatTemplate = new HeatTemplate();

-                return Arrays.asList();

-            }

-        };

-

-        MockUp<Session> mockedSession = new MockUp<Session>() {

-            @Mock

-            public Query createQuery(String hql) {

-                return mockUpQuery.getMockInstance();

-            }

-        };

-

-        new MockUp<CatalogDatabase>() {

-            @Mock

-            private Session getSession() {

-                return mockedSession.getMockInstance();

-            }

-        };

-

-        HeatTemplate ht = cd.getHeatTemplate("heat123");

-        assertEquals(null, ht);

-    }

-

-    @Test

-    public void getHeatTemplateByNameTest(){

-

-        MockUp<Query> mockUpQuery = new MockUp<Query>() {

-            @Mock

-            public List<HeatTemplate> list() {

-                HeatTemplate heatTemplate1 = new HeatTemplate();

-                heatTemplate1.setAsdcUuid("123-uuid");

-                heatTemplate1.setVersion("1.2");

-                HeatTemplate heatTemplate2 = new HeatTemplate();

-                heatTemplate2.setAsdcUuid("456-uuid");

-                heatTemplate2.setVersion("1.3");

-                return Arrays.asList(heatTemplate1, heatTemplate2);

-            }

-        };

-

-        MockUp<Session> mockedSession = new MockUp<Session>() {

-            @Mock

-            public Query createQuery(String hql) {

-                return mockUpQuery.getMockInstance();

-            }

-        };

-

-        new MockUp<CatalogDatabase>() {

-            @Mock

-            private Session getSession() {

-                return mockedSession.getMockInstance();

-            }

-        };

-

-        HeatTemplate ht = cd.getHeatTemplate("heat123");

-        assertEquals("456-uuid", ht.getAsdcUuid());

-    }

-

-    @Test(expected = Exception.class)

-    public void getHeatTemplateTest3Exception(){

-        HeatTemplate ht = cd.getHeatTemplate("heat123","v2");

-    }

-

-    @Test(expected = Exception.class)

-    public void getHeatTemplateByArtifactUuidException(){

-        HeatTemplate ht = cd.getHeatTemplateByArtifactUuid("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getHeatTemplateByArtifactUuidRegularQueryException(){

-        HeatTemplate ht = cd.getHeatTemplateByArtifactUuidRegularQuery("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getParametersForHeatTemplateTestException(){

-        List<HeatTemplateParam> ht = cd.getParametersForHeatTemplate("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getHeatEnvironmentByArtifactUuidTestException(){

-        HeatEnvironment ht = cd.getHeatEnvironmentByArtifactUuid("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceByInvariantUUIDTestException(){

-        Service ht = cd.getServiceByInvariantUUID("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceTestException(){

-        Service ht = cd.getService("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceByModelUUIDTestException(){

-        Service ht = cd.getServiceByModelUUID("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getService2TestException(){

-        HashMap<String, String> map = new HashMap<>();

-        map.put("serviceNameVersionId", "v2");

-        Service ht = cd.getService(map, "123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceByModelNameTestException(){

-        Service ht = cd.getServiceByModelName("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceByVersionAndInvariantIdTestException() throws Exception{

-        Service ht = cd.getServiceByVersionAndInvariantId("123","tetwe");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceRecipeTestException() throws Exception{

-        ServiceRecipe ht = cd.getServiceRecipe("123","tetwe");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceRecipeByServiceModelUuidTestException() throws Exception{

-        ServiceRecipe ht = cd.getServiceRecipeByServiceModelUuid("123","tetwe");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceRecipesTestException() throws Exception{

-        List<ServiceRecipe> ht = cd.getServiceRecipes("123");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfComponentTestException() throws Exception{

-        VnfComponent ht = cd.getVnfComponent(123,"vnf");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResourceTestException() throws Exception{

-        VnfResource ht = cd.getVnfResource("vnf");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResource2TestException() throws Exception{

-        VnfResource ht = cd.getVnfResource("vnf","3992");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResourceByModelCustomizationIdTestException() throws Exception{

-        VnfResource ht = cd.getVnfResourceByModelCustomizationId("3992");

-    }

-

-    @Test(expected = Exception.class)

-    public void getServiceRecipeTest2Exception() throws Exception{

-        ServiceRecipe ht = cd.getServiceRecipe(1001,"3992");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationByModelCustomizationNameTestException(){

-        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelCustomizationName("test", "test234");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResourceByModelInvariantIdTestException(){

-        VnfResource vnf = cd.getVnfResourceByModelInvariantId("test", "test234");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfResourceByIdTestException(){

-        VnfResource vnf = cd.getVnfResourceById(19299);

-    }

-

-    @Test(expected = Exception.class)

-    public void getVfModuleModelNameTestException(){

-        VfModule vnf = cd.getVfModuleModelName("tetes");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVfModuleModelName2TestException(){

-        VfModule vnf = cd.getVfModuleModelName("tetes","4kidsl");

-    }

-

-    @Test(expected = Exception.class)

-    public void ggetVfModuleCustomizationByModelNameTestException(){

-        VfModuleCustomization vnf = cd.getVfModuleCustomizationByModelName("tetes");

-    }

-

-    @Test(expected = Exception.class)

-    public void getNetworkResourceTestException(){

-        NetworkResource vnf = cd.getNetworkResource("tetes");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfRecipeTestException(){

-        VnfRecipe vnf = cd.getVnfRecipe("tetes","ergfedrf","4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfRecipe2TestException(){

-        VnfRecipe vnf = cd.getVnfRecipe("tetes","4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVnfRecipeByVfModuleIdTestException(){

-        VnfRecipe vnf = cd.getVnfRecipeByVfModuleId("tetes","4993493","vnf");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVfModuleTypeTestException(){

-        VfModule vnf = cd.getVfModuleType("4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getVfModuleType2TestException(){

-        VfModule vnf = cd.getVfModuleType("4993493","vnf");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceByServiceUuidTestException(){

-        VnfResource vnf = cd.getVnfResourceByServiceUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceByVnfUuidTestException(){

-        VnfResource vnf = cd.getVnfResourceByVnfUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelInvariantUuidTestException(){

-        VfModule vnf = cd.getVfModuleByModelInvariantUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelCustomizationUuidTestException(){

-        VfModuleCustomization vnf = cd.getVfModuleByModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelInvariantUuidAndModelVersionTestException(){

-        VfModule vnf = cd.getVfModuleByModelInvariantUuidAndModelVersion("4993493","vnf");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleCustomizationByModelCustomizationIdTestException(){

-        VfModuleCustomization vnf = cd.getVfModuleCustomizationByModelCustomizationId("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelUuidTestException(){

-        VfModule vnf = cd.getVfModuleByModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationByModelCustomizationUuidTestException(){

-        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationByModelVersionIdTestException(){

-        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelVersionId("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelCustomizationIdAndVersionTestException(){

-        cd.getVfModuleByModelCustomizationIdAndVersion("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelCustomizationIdModelVersionAndModelInvariantIdTestException(){

-        cd.getVfModuleByModelCustomizationIdModelVersionAndModelInvariantId("4993493","vnf","test");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationByModelInvariantIdTest(){

-        cd.getVnfResourceCustomizationByModelInvariantId("4993493","vnf","test");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleCustomizationByVnfModuleCustomizationUuidTest(){

-        cd.getVfModuleCustomizationByVnfModuleCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationByVnfModelCustomizationNameAndModelVersionIdTest(){

-        cd.getVnfResourceCustomizationByVnfModelCustomizationNameAndModelVersionId("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVfModuleCustomizationstest(){

-        cd.getAllVfModuleCustomizations("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceByModelUuidTest(){

-        cd.getVnfResourceByModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResCustomToVfModuleTest(){

-        cd.getVnfResCustomToVfModule("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModulesForVnfResourceTest(){

-        VnfResource vnfResource = new VnfResource();

-        vnfResource.setModelUuid("48839");

-        cd.getVfModulesForVnfResource(vnfResource);

-    }

-    @Test(expected = Exception.class)

-    public void getVfModulesForVnfResource2Test(){

-        cd.getVfModulesForVnfResource("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getServiceByUuidTest(){

-        cd.getServiceByUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getNetworkResourceById2Test(){

-        cd.getNetworkResourceById(4993493);

-    }

-    @Test(expected = Exception.class)

-    public void getNetworkResourceByIdTest(){

-        cd.getVfModuleTypeByUuid("4993493");

-    }

-    @Test

-    public void isEmptyOrNullTest(){

-        boolean is = cd.isEmptyOrNull("4993493");

-        assertFalse(is);

-    }

-    @Test(expected = Exception.class)

-    public void getSTRTest(){

-        cd.getSTR("4993493","test","vnf");

-    }

-    @Test(expected = Exception.class)

-    public void getVRCtoVFMCTest(){

-        cd.getVRCtoVFMC("4993493","388492");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleTypeByUuidTestException(){

-        cd.getVfModuleTypeByUuid("4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getTempNetworkHeatTemplateLookupTest(){

-        cd.getTempNetworkHeatTemplateLookup("4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getAllNetworksByServiceModelUuidTest(){

-        cd.getAllNetworksByServiceModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworksByServiceModelInvariantUuidTest(){

-        cd.getAllNetworksByServiceModelInvariantUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworksByServiceModelInvariantUuid2Test(){

-        cd.getAllNetworksByServiceModelInvariantUuid("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworksByNetworkModelCustomizationUuidTest(){

-        cd.getAllNetworksByNetworkModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworksByNetworkTypeTest(){

-        cd.getAllNetworksByNetworkType("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVfmcForVrcTest(){

-        VnfResourceCustomization re = new VnfResourceCustomization();

-        re.setModelCustomizationUuid("377483");

-        cd.getAllVfmcForVrc(re);

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByServiceModelUuidTest(){

-        cd.getAllVnfsByServiceModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByServiceModelInvariantUuidTest(){

-        cd.getAllVnfsByServiceModelInvariantUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByServiceModelInvariantUuid2Test(){

-        cd.getAllVnfsByServiceModelInvariantUuid("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByServiceNameTest(){

-        cd.getAllVnfsByServiceName("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByServiceName2Test(){

-        cd.getAllVnfsByServiceName("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfsByVnfModelCustomizationUuidTest(){

-        cd.getAllVnfsByVnfModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllAllottedResourcesByServiceModelUuidTest(){

-        cd.getAllAllottedResourcesByServiceModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllAllottedResourcesByServiceModelInvariantUuidTest(){

-        cd.getAllAllottedResourcesByServiceModelInvariantUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllAllottedResourcesByServiceModelInvariantUuid2Test(){

-        cd.getAllAllottedResourcesByServiceModelInvariantUuid("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getAllAllottedResourcesByArModelCustomizationUuidTest(){

-        cd.getAllAllottedResourcesByArModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllottedResourceByModelUuidTest(){

-        cd.getAllottedResourceByModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllResourcesByServiceModelUuidTest(){

-        cd.getAllResourcesByServiceModelUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllResourcesByServiceModelInvariantUuidTest(){

-        cd.getAllResourcesByServiceModelInvariantUuid("4993493");

-    }

-

-    @Test(expected = Exception.class)

-    public void getAllResourcesByServiceModelInvariantUuid2Test(){

-        cd.getAllResourcesByServiceModelInvariantUuid("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void getSingleNetworkByModelCustomizationUuidTest(){

-        cd.getSingleNetworkByModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getSingleAllottedResourceByModelCustomizationUuidTest(){

-        cd.getSingleAllottedResourceByModelCustomizationUuid("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleRecipeTest(){

-        cd.getVfModuleRecipe("4993493","test","get");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleTest(){

-        cd.getVfModule("4993493","test","get","v2","vnf");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfComponentsRecipeTest(){

-        cd.getVnfComponentsRecipe("4993493","test","v2","vnf","get","3992");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfComponentsRecipeByVfModuleTest(){

-        List <VfModule> resultList = new ArrayList<>();

-        VfModule m = new VfModule();

-        resultList.add(m);

-        cd.getVnfComponentsRecipeByVfModule(resultList,"4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllVnfResourcesTest(){

-        cd.getAllVnfResources();

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourcesByRoleTest(){

-        cd.getVnfResourcesByRole("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfResourceCustomizationsByRoleTest(){

-        cd.getVnfResourceCustomizationsByRole("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworkResourcesTest(){

-        cd.getAllNetworkResources();

-    }

-    @Test(expected = Exception.class)

-    public void getAllNetworkResourceCustomizationsTest(){

-        cd.getAllNetworkResourceCustomizations();

-    }

-    @Test(expected = Exception.class)

-    public void getAllVfModulesTest(){

-        cd.getAllVfModules();

-    }

-    @Test(expected = Exception.class)

-    public void getAllVfModuleCustomizationsTest(){

-        cd.getAllVfModuleCustomizations();

-    }

-    @Test(expected = Exception.class)

-    public void getAllHeatEnvironmentTest(){

-        cd.getAllHeatEnvironment();

-    }

-    @Test(expected = Exception.class)

-    public void getHeatEnvironment2Test(){

-        cd.getHeatEnvironment(4993493);

-    }

-    @Test(expected = Exception.class)

-    public void getNestedTemplatesTest(){

-        cd.getNestedTemplates(4993493);

-    }

-    @Test(expected = Exception.class)

-    public void getNestedTemplates2Test(){

-        cd.getNestedTemplates("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatFilesTest(){

-        cd.getHeatFiles(4993493);

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleToHeatFilesEntryTest(){

-        cd.getVfModuleToHeatFilesEntry("4993493","49959499");

-    }

-    @Test(expected = Exception.class)

-    public void getServiceToResourceCustomization(){

-        cd.getServiceToResourceCustomization("4993493","599349","49900");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatFilesForVfModuleTest(){

-        cd.getHeatFilesForVfModule("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatTemplateTest(){

-        cd.getHeatTemplate("4993493","test","heat");

-    }

-

-    @Test(expected = Exception.class)

-    public void saveHeatTemplateTest(){

-        HeatTemplate heat = new HeatTemplate();

-        Set <HeatTemplateParam> paramSet = new HashSet<HeatTemplateParam>();

-        cd.saveHeatTemplate(heat,paramSet);

-    }

-    @Test(expected = Exception.class)

-    public void getHeatEnvironmentTest(){

-        cd.getHeatEnvironment("4993493","test","heat");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatEnvironment3Test(){

-        cd.getHeatEnvironment("4993493","test");

-    }

-    @Test(expected = Exception.class)

-    public void saveHeatEnvironmentTest(){

-        HeatEnvironment en = new HeatEnvironment();

-        cd.saveHeatEnvironment(en);

-    }

-    @Test(expected = Exception.class)

-    public void saveHeatTemplate2Test(){

-        HeatTemplate heat = new HeatTemplate();

-        cd.saveHeatTemplate(heat);

-    }

-    @Test(expected = Exception.class)

-    public void saveHeatFileTest(){

-        HeatFiles hf = new HeatFiles();

-        cd.saveHeatFile(hf);

-    }

-    @Test(expected = Exception.class)

-    public void saveVnfRecipeTest(){

-        VnfRecipe vr = new VnfRecipe();

-        cd.saveVnfRecipe(vr);

-    }

-    @Test(expected = Exception.class)

-    public void saveVnfComponentsRecipe(){

-        VnfComponentsRecipe vr = new VnfComponentsRecipe();

-        cd.saveVnfComponentsRecipe(vr);

-    }

-    @Test(expected = Exception.class)

-    public void saveOrUpdateVnfResourceTest(){

-        VnfResource vr = new VnfResource();

-        cd.saveOrUpdateVnfResource(vr);

-    }

-    @Test(expected = Exception.class)

-    public void saveVnfResourceCustomizationTest(){

-        VnfResourceCustomization vr = new VnfResourceCustomization();

-        cd.saveVnfResourceCustomization(vr);

-    }

-    @Test(expected = Exception.class)

-    public void saveAllottedResourceCustomizationTest(){

-        AllottedResourceCustomization arc = new AllottedResourceCustomization();

-        cd.saveAllottedResourceCustomization(arc);

-    }

-    @Test(expected = Exception.class)

-    public void saveAllottedResourceTest(){

-        AllottedResource ar = new AllottedResource();

-        cd.saveAllottedResource(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveNetworkResourceTest() throws RecordNotFoundException {

-        NetworkResource nr = new NetworkResource();

-        cd.saveNetworkResource(nr);

-    }

-    @Test(expected = Exception.class)

-    public void saveToscaCsarTest()throws RecordNotFoundException {

-        ToscaCsar ts = new ToscaCsar();

-        cd.saveToscaCsar(ts);

-    }

-    @Test(expected = Exception.class)

-    public void getToscaCsar(){

-        cd.getToscaCsar("4993493");

-    }

-    @Test(expected = Exception.class)

-    public void saveTempNetworkHeatTemplateLookupTest(){

-        TempNetworkHeatTemplateLookup t = new TempNetworkHeatTemplateLookup();

-        cd.saveTempNetworkHeatTemplateLookup(t);

-    }

-    @Test(expected = Exception.class)

-    public void saveVfModuleToHeatFiles(){

-        VfModuleToHeatFiles v = new VfModuleToHeatFiles();

-        cd.saveVfModuleToHeatFiles(v);

-    }

-    @Test(expected = Exception.class)

-    public void saveVnfResourceToVfModuleCustomizationTest() throws RecordNotFoundException {

-        VnfResourceCustomization v =new VnfResourceCustomization();

-        VfModuleCustomization vm = new VfModuleCustomization();

-        cd.saveVnfResourceToVfModuleCustomization(v, vm);

-    }

-    @Test(expected = Exception.class)

-    public void saveNetworkResourceCustomizationTest() throws RecordNotFoundException {

-        NetworkResourceCustomization nrc = new NetworkResourceCustomization();

-        cd.saveNetworkResourceCustomization(nrc);

-    }

-

-    @Test(expected = Exception.class)

-    public void saveServiceToNetworksTest(){

-        AllottedResource ar = new AllottedResource();

-        cd.saveAllottedResource(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveServiceToResourceCustomizationTest(){

-        ServiceToResourceCustomization ar = new ServiceToResourceCustomization();

-        cd.saveServiceToResourceCustomization(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveServiceTest(){

-        Service ar = new Service();

-        cd.saveService(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveOrUpdateVfModuleTest(){

-        VfModule ar = new VfModule();

-        cd.saveOrUpdateVfModule(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveOrUpdateVfModuleCustomizationTest(){

-        VfModuleCustomization ar = new VfModuleCustomization();

-        cd.saveOrUpdateVfModuleCustomization(ar);

-    }

-

-    @Test(expected = Exception.class)

-    public void getNestedHeatTemplateTest(){

-        cd.getNestedHeatTemplate(101,201);

-    }

-    @Test(expected = Exception.class)

-    public void getNestedHeatTemplate2Test(){

-        cd.getNestedHeatTemplate("1002","1002");

-    }

-    @Test(expected = Exception.class)

-    public void saveNestedHeatTemplateTest(){

-        HeatTemplate ar = new HeatTemplate();

-        cd.saveNestedHeatTemplate("1001",ar,"test");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatFiles2Test(){

-        VfModuleCustomization ar = new VfModuleCustomization();

-        cd.getHeatFiles(101,"test","1001","v2");

-    }

-    @Test(expected = Exception.class)

-    public void getHeatFiles3Test(){

-        VfModuleCustomization ar = new VfModuleCustomization();

-        cd.getHeatFiles("200192");

-    }

-    @Test(expected = Exception.class)

-    public void saveHeatFilesTest(){

-        HeatFiles ar = new HeatFiles();

-        cd.saveHeatFiles(ar);

-    }

-    @Test(expected = Exception.class)

-    public void saveVfModuleToHeatFilesTest(){

-        HeatFiles ar = new HeatFiles();

-        cd.saveVfModuleToHeatFiles("3772893",ar);

-    }

-    @Test

-    public void getNetworkResourceByModelUuidTest(){

-

-        cd.getNetworkResourceByModelUuid("3899291");

-    }

-    @Test(expected = Exception.class)

-    public void getNetworkRecipeTest(){

-

-        cd.getNetworkRecipe("test","test1","test2");

-    }

-    @Test(expected = Exception.class)

-    public void getNetworkRecipe2Test(){

-

-        cd.getNetworkRecipe("test","test1");

-    }

-    @Test

-    public void getNetworkResourceByModelCustUuidTest(){

-

-        cd.getNetworkResourceByModelCustUuid("test");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfComponentsRecipe2Test(){

-

-        cd.getVnfComponentsRecipe("test1","test2","test3","test4");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfComponentsRecipeByVfModuleModelUUIdTest(){

-

-        cd.getVnfComponentsRecipeByVfModuleModelUUId("test1","test2","test3");

-    }

-    @Test(expected = Exception.class)

-    public void getVnfComponentRecipesTest(){

-

-        cd.getVnfComponentRecipes("test");

-    }

-    @Test(expected = Exception.class)

-    public void saveOrUpdateVnfComponentTest(){

-        VnfComponent ar = new VnfComponent();

-        cd.saveOrUpdateVnfComponent(ar);

-    }

-

-    @Test(expected = Exception.class)

-    public void getVfModule2Test(){

-

-        cd.getVfModule("test");

-    }

-    @Test(expected = Exception.class)

-    public void getVfModuleByModelUUIDTest(){

-

-        cd.getVfModuleByModelUUID("test");

-    }

-    @Test(expected = Exception.class)

-    public void getServiceRecipeByModelUUIDTest(){

-

-        cd.getServiceRecipeByModelUUID("test1","test2");

-    }

-    @Test(expected = Exception.class)

-    public void getModelRecipeTest(){

-

-        cd.getModelRecipe("test1","test2","test3");

-    }

-    @Test(expected = Exception.class)

-    public void healthCheck(){

-

-        cd.healthCheck();

-    }

-    @Test(expected = Exception.class)

-    public void executeQuerySingleRow(){

-        VnfComponent ar = new VnfComponent();

-        HashMap<String, String> variables = new HashMap<String, String>();

-        cd.executeQuerySingleRow("tets",variables,false);

-    }

-    @Test(expected = Exception.class)

-    public void executeQueryMultipleRows(){

-        HashMap<String, String> variables = new HashMap<String, String>();

-        cd.executeQueryMultipleRows("select",variables,false);

-    }

-}

+/*-
+ * ============LICENSE_START=======================================================
+ * ONAP - SO
+ * ================================================================================
+ * Copyright (C) 2017 Huawei Technologies Co., Ltd. All rights reserved.
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * ============LICENSE_END=========================================================
+ */
+
+package org.openecomp.mso.db.catalog.test;
+
+import static org.junit.Assert.assertEquals;
+import static org.junit.Assert.assertFalse;
+import static org.junit.Assert.assertTrue;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+import java.math.BigInteger;
+import java.sql.Connection;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.Calendar;
+import java.util.Collection;
+import java.util.Date;
+import java.util.HashMap;
+import java.util.HashSet;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Locale;
+import java.util.Map;
+import java.util.Set;
+
+import mockit.Mock;
+import mockit.MockUp;
+import org.hibernate.CacheMode;
+import org.hibernate.Criteria;
+import org.hibernate.Filter;
+import org.hibernate.FlushMode;
+import org.hibernate.HibernateException;
+import org.hibernate.IdentifierLoadAccess;
+import org.hibernate.LobHelper;
+import org.hibernate.LockMode;
+import org.hibernate.LockOptions;
+import org.hibernate.NaturalIdLoadAccess;
+import org.hibernate.Query;
+import org.hibernate.ReplicationMode;
+import org.hibernate.SQLQuery;
+import org.hibernate.ScrollMode;
+import org.hibernate.ScrollableResults;
+import org.hibernate.Session;
+import org.hibernate.SessionEventListener;
+import org.hibernate.SessionFactory;
+import org.hibernate.SharedSessionBuilder;
+import org.hibernate.SimpleNaturalIdLoadAccess;
+import org.hibernate.Transaction;
+import org.hibernate.TypeHelper;
+import org.hibernate.UnknownProfileException;
+import org.hibernate.jdbc.ReturningWork;
+import org.hibernate.jdbc.Work;
+import org.hibernate.metamodel.source.annotations.xml.mocker.MockHelper;
+import org.hibernate.procedure.ProcedureCall;
+import org.hibernate.stat.SessionStatistics;
+import org.hibernate.transform.ResultTransformer;
+import org.hibernate.type.Type;
+import org.junit.Before;
+import org.junit.Test;
+import org.openecomp.mso.db.catalog.CatalogDatabase;
+import org.openecomp.mso.db.catalog.beans.AllottedResource;
+import org.openecomp.mso.db.catalog.beans.AllottedResourceCustomization;
+import org.openecomp.mso.db.catalog.beans.HeatEnvironment;
+import org.openecomp.mso.db.catalog.beans.HeatFiles;
+import org.openecomp.mso.db.catalog.beans.HeatTemplate;
+import org.openecomp.mso.db.catalog.beans.HeatTemplateParam;
+import org.openecomp.mso.db.catalog.beans.NetworkResource;
+import org.openecomp.mso.db.catalog.beans.NetworkResourceCustomization;
+import org.openecomp.mso.db.catalog.beans.Service;
+import org.openecomp.mso.db.catalog.beans.ServiceRecipe;
+import org.openecomp.mso.db.catalog.beans.ServiceToResourceCustomization;
+import org.openecomp.mso.db.catalog.beans.TempNetworkHeatTemplateLookup;
+import org.openecomp.mso.db.catalog.beans.ToscaCsar;
+import org.openecomp.mso.db.catalog.beans.VfModule;
+import org.openecomp.mso.db.catalog.beans.VfModuleCustomization;
+import org.openecomp.mso.db.catalog.beans.VfModuleToHeatFiles;
+import org.openecomp.mso.db.catalog.beans.VnfComponent;
+import org.openecomp.mso.db.catalog.beans.VnfComponentsRecipe;
+import org.openecomp.mso.db.catalog.beans.VnfRecipe;
+import org.openecomp.mso.db.catalog.beans.VnfResource;
+import org.openecomp.mso.db.catalog.beans.VnfResourceCustomization;
+import org.openecomp.mso.db.catalog.utils.RecordNotFoundException;
+
+public class CatalogDatabaseTest {
+
+    CatalogDatabase cd = null;
+
+    @Before
+    public void setup(){
+        cd = CatalogDatabase.getInstance();
+    }
+
+
+    @Test
+    public void getAllHeatTemplatesTest(){
+
+        MockUp<Query> mockUpQuery = new MockUp<Query>() {
+            @Mock
+            public List<HeatTemplate> list() {
+                HeatTemplate heatTemplate = new HeatTemplate();
+                return Arrays.asList(heatTemplate);
+            }
+        };
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Query createQuery(String hql) {
+                return mockUpQuery.getMockInstance();
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        List <HeatTemplate> list = cd.getAllHeatTemplates();
+        assertEquals(list.size(), 1);
+    }
+
+    @Test
+    public void getHeatTemplateByIdTest(){
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Object get(Class cls, Serializable id) {
+                HeatTemplate heatTemplate = new HeatTemplate();
+                heatTemplate.setAsdcUuid("123-uuid");
+                return heatTemplate;
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        HeatTemplate ht = cd.getHeatTemplate(10);
+        assertEquals("123-uuid", ht.getAsdcUuid());
+    }
+
+    @Test
+    public void getHeatTemplateByNameEmptyListTest(){
+
+        MockUp<Query> mockUpQuery = new MockUp<Query>() {
+            @Mock
+            public List<HeatTemplate> list() {
+                HeatTemplate heatTemplate = new HeatTemplate();
+                return Arrays.asList();
+            }
+        };
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Query createQuery(String hql) {
+                return mockUpQuery.getMockInstance();
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        HeatTemplate ht = cd.getHeatTemplate("heat123");
+        assertEquals(null, ht);
+    }
+
+    @Test
+    public void getHeatTemplateByNameTest(){
+
+        MockUp<Query> mockUpQuery = new MockUp<Query>() {
+            @Mock
+            public List<HeatTemplate> list() {
+                HeatTemplate heatTemplate1 = new HeatTemplate();
+                heatTemplate1.setAsdcUuid("123-uuid");
+                heatTemplate1.setVersion("1.2");
+                HeatTemplate heatTemplate2 = new HeatTemplate();
+                heatTemplate2.setAsdcUuid("456-uuid");
+                heatTemplate2.setVersion("1.3");
+                return Arrays.asList(heatTemplate1, heatTemplate2);
+            }
+        };
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Query createQuery(String hql) {
+                return mockUpQuery.getMockInstance();
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        HeatTemplate ht = cd.getHeatTemplate("heat123");
+        assertEquals("456-uuid", ht.getAsdcUuid());
+    }
+
+    @Test
+    public void getHeatTemplateByTemplateNameTest() {
+
+        MockUp<Query> mockUpQuery = new MockUp<Query>() {
+            @Mock
+            public List<HeatTemplate> list() {
+                HeatTemplate heatTemplate = new HeatTemplate();
+                heatTemplate.setAsdcUuid("1234-uuid");
+                return Arrays.asList(heatTemplate);
+            }
+        };
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Query createQuery(String hql) {
+                return mockUpQuery.getMockInstance();
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        HeatTemplate ht = cd.getHeatTemplate("heat123","v2");
+        assertEquals("1234-uuid", ht.getAsdcUuid());
+    }
+
+    @Test
+    public void getHeatTemplateByTemplateNameEmptyResultTest() {
+
+        MockUp<Query> mockUpQuery = new MockUp<Query>() {
+            @Mock
+            public List<HeatTemplate> list() {
+                return Arrays.asList();
+            }
+        };
+
+        MockUp<Session> mockedSession = new MockUp<Session>() {
+            @Mock
+            public Query createQuery(String hql) {
+                return mockUpQuery.getMockInstance();
+            }
+        };
+
+        new MockUp<CatalogDatabase>() {
+            @Mock
+            private Session getSession() {
+                return mockedSession.getMockInstance();
+            }
+        };
+
+        HeatTemplate ht = cd.getHeatTemplate("heat123","v2");
+        assertEquals(null, ht);
+    }
+
+    @Test(expected = Exception.class)
+    public void getHeatTemplateByArtifactUuidException(){
+        HeatTemplate ht = cd.getHeatTemplateByArtifactUuid("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getHeatTemplateByArtifactUuidRegularQueryException(){
+        HeatTemplate ht = cd.getHeatTemplateByArtifactUuidRegularQuery("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getParametersForHeatTemplateTestException(){
+        List<HeatTemplateParam> ht = cd.getParametersForHeatTemplate("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getHeatEnvironmentByArtifactUuidTestException(){
+        HeatEnvironment ht = cd.getHeatEnvironmentByArtifactUuid("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceByInvariantUUIDTestException(){
+        Service ht = cd.getServiceByInvariantUUID("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceTestException(){
+        Service ht = cd.getService("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceByModelUUIDTestException(){
+        Service ht = cd.getServiceByModelUUID("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getService2TestException(){
+        HashMap<String, String> map = new HashMap<>();
+        map.put("serviceNameVersionId", "v2");
+        Service ht = cd.getService(map, "123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceByModelNameTestException(){
+        Service ht = cd.getServiceByModelName("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceByVersionAndInvariantIdTestException() throws Exception{
+        Service ht = cd.getServiceByVersionAndInvariantId("123","tetwe");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceRecipeTestException() throws Exception{
+        ServiceRecipe ht = cd.getServiceRecipe("123","tetwe");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceRecipeByServiceModelUuidTestException() throws Exception{
+        ServiceRecipe ht = cd.getServiceRecipeByServiceModelUuid("123","tetwe");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceRecipesTestException() throws Exception{
+        List<ServiceRecipe> ht = cd.getServiceRecipes("123");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfComponentTestException() throws Exception{
+        VnfComponent ht = cd.getVnfComponent(123,"vnf");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResourceTestException() throws Exception{
+        VnfResource ht = cd.getVnfResource("vnf");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResource2TestException() throws Exception{
+        VnfResource ht = cd.getVnfResource("vnf","3992");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResourceByModelCustomizationIdTestException() throws Exception{
+        VnfResource ht = cd.getVnfResourceByModelCustomizationId("3992");
+    }
+
+    @Test(expected = Exception.class)
+    public void getServiceRecipeTest2Exception() throws Exception{
+        ServiceRecipe ht = cd.getServiceRecipe(1001,"3992");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationByModelCustomizationNameTestException(){
+        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelCustomizationName("test", "test234");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResourceByModelInvariantIdTestException(){
+        VnfResource vnf = cd.getVnfResourceByModelInvariantId("test", "test234");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfResourceByIdTestException(){
+        VnfResource vnf = cd.getVnfResourceById(19299);
+    }
+
+    @Test(expected = Exception.class)
+    public void getVfModuleModelNameTestException(){
+        VfModule vnf = cd.getVfModuleModelName("tetes");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVfModuleModelName2TestException(){
+        VfModule vnf = cd.getVfModuleModelName("tetes","4kidsl");
+    }
+
+    @Test(expected = Exception.class)
+    public void ggetVfModuleCustomizationByModelNameTestException(){
+        VfModuleCustomization vnf = cd.getVfModuleCustomizationByModelName("tetes");
+    }
+
+    @Test(expected = Exception.class)
+    public void getNetworkResourceTestException(){
+        NetworkResource vnf = cd.getNetworkResource("tetes");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfRecipeTestException(){
+        VnfRecipe vnf = cd.getVnfRecipe("tetes","ergfedrf","4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfRecipe2TestException(){
+        VnfRecipe vnf = cd.getVnfRecipe("tetes","4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVnfRecipeByVfModuleIdTestException(){
+        VnfRecipe vnf = cd.getVnfRecipeByVfModuleId("tetes","4993493","vnf");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVfModuleTypeTestException(){
+        VfModule vnf = cd.getVfModuleType("4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getVfModuleType2TestException(){
+        VfModule vnf = cd.getVfModuleType("4993493","vnf");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceByServiceUuidTestException(){
+        VnfResource vnf = cd.getVnfResourceByServiceUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceByVnfUuidTestException(){
+        VnfResource vnf = cd.getVnfResourceByVnfUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelInvariantUuidTestException(){
+        VfModule vnf = cd.getVfModuleByModelInvariantUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelCustomizationUuidTestException(){
+        VfModuleCustomization vnf = cd.getVfModuleByModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelInvariantUuidAndModelVersionTestException(){
+        VfModule vnf = cd.getVfModuleByModelInvariantUuidAndModelVersion("4993493","vnf");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleCustomizationByModelCustomizationIdTestException(){
+        VfModuleCustomization vnf = cd.getVfModuleCustomizationByModelCustomizationId("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelUuidTestException(){
+        VfModule vnf = cd.getVfModuleByModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationByModelCustomizationUuidTestException(){
+        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationByModelVersionIdTestException(){
+        VnfResourceCustomization vnf = cd.getVnfResourceCustomizationByModelVersionId("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelCustomizationIdAndVersionTestException(){
+        cd.getVfModuleByModelCustomizationIdAndVersion("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelCustomizationIdModelVersionAndModelInvariantIdTestException(){
+        cd.getVfModuleByModelCustomizationIdModelVersionAndModelInvariantId("4993493","vnf","test");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationByModelInvariantIdTest(){
+        cd.getVnfResourceCustomizationByModelInvariantId("4993493","vnf","test");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleCustomizationByVnfModuleCustomizationUuidTest(){
+        cd.getVfModuleCustomizationByVnfModuleCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationByVnfModelCustomizationNameAndModelVersionIdTest(){
+        cd.getVnfResourceCustomizationByVnfModelCustomizationNameAndModelVersionId("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVfModuleCustomizationstest(){
+        cd.getAllVfModuleCustomizations("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceByModelUuidTest(){
+        cd.getVnfResourceByModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResCustomToVfModuleTest(){
+        cd.getVnfResCustomToVfModule("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModulesForVnfResourceTest(){
+        VnfResource vnfResource = new VnfResource();
+        vnfResource.setModelUuid("48839");
+        cd.getVfModulesForVnfResource(vnfResource);
+    }
+    @Test(expected = Exception.class)
+    public void getVfModulesForVnfResource2Test(){
+        cd.getVfModulesForVnfResource("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getServiceByUuidTest(){
+        cd.getServiceByUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getNetworkResourceById2Test(){
+        cd.getNetworkResourceById(4993493);
+    }
+    @Test(expected = Exception.class)
+    public void getNetworkResourceByIdTest(){
+        cd.getVfModuleTypeByUuid("4993493");
+    }
+    @Test
+    public void isEmptyOrNullTest(){
+        boolean is = cd.isEmptyOrNull("4993493");
+        assertFalse(is);
+    }
+    @Test(expected = Exception.class)
+    public void getSTRTest(){
+        cd.getSTR("4993493","test","vnf");
+    }
+    @Test(expected = Exception.class)
+    public void getVRCtoVFMCTest(){
+        cd.getVRCtoVFMC("4993493","388492");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleTypeByUuidTestException(){
+        cd.getVfModuleTypeByUuid("4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getTempNetworkHeatTemplateLookupTest(){
+        cd.getTempNetworkHeatTemplateLookup("4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getAllNetworksByServiceModelUuidTest(){
+        cd.getAllNetworksByServiceModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworksByServiceModelInvariantUuidTest(){
+        cd.getAllNetworksByServiceModelInvariantUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworksByServiceModelInvariantUuid2Test(){
+        cd.getAllNetworksByServiceModelInvariantUuid("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworksByNetworkModelCustomizationUuidTest(){
+        cd.getAllNetworksByNetworkModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworksByNetworkTypeTest(){
+        cd.getAllNetworksByNetworkType("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVfmcForVrcTest(){
+        VnfResourceCustomization re = new VnfResourceCustomization();
+        re.setModelCustomizationUuid("377483");
+        cd.getAllVfmcForVrc(re);
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByServiceModelUuidTest(){
+        cd.getAllVnfsByServiceModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByServiceModelInvariantUuidTest(){
+        cd.getAllVnfsByServiceModelInvariantUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByServiceModelInvariantUuid2Test(){
+        cd.getAllVnfsByServiceModelInvariantUuid("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByServiceNameTest(){
+        cd.getAllVnfsByServiceName("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByServiceName2Test(){
+        cd.getAllVnfsByServiceName("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfsByVnfModelCustomizationUuidTest(){
+        cd.getAllVnfsByVnfModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllAllottedResourcesByServiceModelUuidTest(){
+        cd.getAllAllottedResourcesByServiceModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllAllottedResourcesByServiceModelInvariantUuidTest(){
+        cd.getAllAllottedResourcesByServiceModelInvariantUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllAllottedResourcesByServiceModelInvariantUuid2Test(){
+        cd.getAllAllottedResourcesByServiceModelInvariantUuid("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getAllAllottedResourcesByArModelCustomizationUuidTest(){
+        cd.getAllAllottedResourcesByArModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllottedResourceByModelUuidTest(){
+        cd.getAllottedResourceByModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllResourcesByServiceModelUuidTest(){
+        cd.getAllResourcesByServiceModelUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllResourcesByServiceModelInvariantUuidTest(){
+        cd.getAllResourcesByServiceModelInvariantUuid("4993493");
+    }
+
+    @Test(expected = Exception.class)
+    public void getAllResourcesByServiceModelInvariantUuid2Test(){
+        cd.getAllResourcesByServiceModelInvariantUuid("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void getSingleNetworkByModelCustomizationUuidTest(){
+        cd.getSingleNetworkByModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getSingleAllottedResourceByModelCustomizationUuidTest(){
+        cd.getSingleAllottedResourceByModelCustomizationUuid("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleRecipeTest(){
+        cd.getVfModuleRecipe("4993493","test","get");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleTest(){
+        cd.getVfModule("4993493","test","get","v2","vnf");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfComponentsRecipeTest(){
+        cd.getVnfComponentsRecipe("4993493","test","v2","vnf","get","3992");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfComponentsRecipeByVfModuleTest(){
+        List <VfModule> resultList = new ArrayList<>();
+        VfModule m = new VfModule();
+        resultList.add(m);
+        cd.getVnfComponentsRecipeByVfModule(resultList,"4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllVnfResourcesTest(){
+        cd.getAllVnfResources();
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourcesByRoleTest(){
+        cd.getVnfResourcesByRole("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfResourceCustomizationsByRoleTest(){
+        cd.getVnfResourceCustomizationsByRole("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworkResourcesTest(){
+        cd.getAllNetworkResources();
+    }
+    @Test(expected = Exception.class)
+    public void getAllNetworkResourceCustomizationsTest(){
+        cd.getAllNetworkResourceCustomizations();
+    }
+    @Test(expected = Exception.class)
+    public void getAllVfModulesTest(){
+        cd.getAllVfModules();
+    }
+    @Test(expected = Exception.class)
+    public void getAllVfModuleCustomizationsTest(){
+        cd.getAllVfModuleCustomizations();
+    }
+    @Test(expected = Exception.class)
+    public void getAllHeatEnvironmentTest(){
+        cd.getAllHeatEnvironment();
+    }
+    @Test(expected = Exception.class)
+    public void getHeatEnvironment2Test(){
+        cd.getHeatEnvironment(4993493);
+    }
+    @Test(expected = Exception.class)
+    public void getNestedTemplatesTest(){
+        cd.getNestedTemplates(4993493);
+    }
+    @Test(expected = Exception.class)
+    public void getNestedTemplates2Test(){
+        cd.getNestedTemplates("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatFilesTest(){
+        cd.getHeatFiles(4993493);
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleToHeatFilesEntryTest(){
+        cd.getVfModuleToHeatFilesEntry("4993493","49959499");
+    }
+    @Test(expected = Exception.class)
+    public void getServiceToResourceCustomization(){
+        cd.getServiceToResourceCustomization("4993493","599349","49900");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatFilesForVfModuleTest(){
+        cd.getHeatFilesForVfModule("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatTemplateTest(){
+        cd.getHeatTemplate("4993493","test","heat");
+    }
+
+    @Test(expected = Exception.class)
+    public void saveHeatTemplateTest(){
+        HeatTemplate heat = new HeatTemplate();
+        Set <HeatTemplateParam> paramSet = new HashSet<HeatTemplateParam>();
+        cd.saveHeatTemplate(heat,paramSet);
+    }
+    @Test(expected = Exception.class)
+    public void getHeatEnvironmentTest(){
+        cd.getHeatEnvironment("4993493","test","heat");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatEnvironment3Test(){
+        cd.getHeatEnvironment("4993493","test");
+    }
+    @Test(expected = Exception.class)
+    public void saveHeatEnvironmentTest(){
+        HeatEnvironment en = new HeatEnvironment();
+        cd.saveHeatEnvironment(en);
+    }
+    @Test(expected = Exception.class)
+    public void saveHeatTemplate2Test(){
+        HeatTemplate heat = new HeatTemplate();
+        cd.saveHeatTemplate(heat);
+    }
+    @Test(expected = Exception.class)
+    public void saveHeatFileTest(){
+        HeatFiles hf = new HeatFiles();
+        cd.saveHeatFile(hf);
+    }
+    @Test(expected = Exception.class)
+    public void saveVnfRecipeTest(){
+        VnfRecipe vr = new VnfRecipe();
+        cd.saveVnfRecipe(vr);
+    }
+    @Test(expected = Exception.class)
+    public void saveVnfComponentsRecipe(){
+        VnfComponentsRecipe vr = new VnfComponentsRecipe();
+        cd.saveVnfComponentsRecipe(vr);
+    }
+    @Test(expected = Exception.class)
+    public void saveOrUpdateVnfResourceTest(){
+        VnfResource vr = new VnfResource();
+        cd.saveOrUpdateVnfResource(vr);
+    }
+    @Test(expected = Exception.class)
+    public void saveVnfResourceCustomizationTest(){
+        VnfResourceCustomization vr = new VnfResourceCustomization();
+        cd.saveVnfResourceCustomization(vr);
+    }
+    @Test(expected = Exception.class)
+    public void saveAllottedResourceCustomizationTest(){
+        AllottedResourceCustomization arc = new AllottedResourceCustomization();
+        cd.saveAllottedResourceCustomization(arc);
+    }
+    @Test(expected = Exception.class)
+    public void saveAllottedResourceTest(){
+        AllottedResource ar = new AllottedResource();
+        cd.saveAllottedResource(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveNetworkResourceTest() throws RecordNotFoundException {
+        NetworkResource nr = new NetworkResource();
+        cd.saveNetworkResource(nr);
+    }
+    @Test(expected = Exception.class)
+    public void saveToscaCsarTest()throws RecordNotFoundException {
+        ToscaCsar ts = new ToscaCsar();
+        cd.saveToscaCsar(ts);
+    }
+    @Test(expected = Exception.class)
+    public void getToscaCsar(){
+        cd.getToscaCsar("4993493");
+    }
+    @Test(expected = Exception.class)
+    public void saveTempNetworkHeatTemplateLookupTest(){
+        TempNetworkHeatTemplateLookup t = new TempNetworkHeatTemplateLookup();
+        cd.saveTempNetworkHeatTemplateLookup(t);
+    }
+    @Test(expected = Exception.class)
+    public void saveVfModuleToHeatFiles(){
+        VfModuleToHeatFiles v = new VfModuleToHeatFiles();
+        cd.saveVfModuleToHeatFiles(v);
+    }
+    @Test(expected = Exception.class)
+    public void saveVnfResourceToVfModuleCustomizationTest() throws RecordNotFoundException {
+        VnfResourceCustomization v =new VnfResourceCustomization();
+        VfModuleCustomization vm = new VfModuleCustomization();
+        cd.saveVnfResourceToVfModuleCustomization(v, vm);
+    }
+    @Test(expected = Exception.class)
+    public void saveNetworkResourceCustomizationTest() throws RecordNotFoundException {
+        NetworkResourceCustomization nrc = new NetworkResourceCustomization();
+        cd.saveNetworkResourceCustomization(nrc);
+    }
+
+    @Test(expected = Exception.class)
+    public void saveServiceToNetworksTest(){
+        AllottedResource ar = new AllottedResource();
+        cd.saveAllottedResource(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveServiceToResourceCustomizationTest(){
+        ServiceToResourceCustomization ar = new ServiceToResourceCustomization();
+        cd.saveServiceToResourceCustomization(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveServiceTest(){
+        Service ar = new Service();
+        cd.saveService(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveOrUpdateVfModuleTest(){
+        VfModule ar = new VfModule();
+        cd.saveOrUpdateVfModule(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveOrUpdateVfModuleCustomizationTest(){
+        VfModuleCustomization ar = new VfModuleCustomization();
+        cd.saveOrUpdateVfModuleCustomization(ar);
+    }
+
+    @Test(expected = Exception.class)
+    public void getNestedHeatTemplateTest(){
+        cd.getNestedHeatTemplate(101,201);
+    }
+    @Test(expected = Exception.class)
+    public void getNestedHeatTemplate2Test(){
+        cd.getNestedHeatTemplate("1002","1002");
+    }
+    @Test(expected = Exception.class)
+    public void saveNestedHeatTemplateTest(){
+        HeatTemplate ar = new HeatTemplate();
+        cd.saveNestedHeatTemplate("1001",ar,"test");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatFiles2Test(){
+        VfModuleCustomization ar = new VfModuleCustomization();
+        cd.getHeatFiles(101,"test","1001","v2");
+    }
+    @Test(expected = Exception.class)
+    public void getHeatFiles3Test(){
+        VfModuleCustomization ar = new VfModuleCustomization();
+        cd.getHeatFiles("200192");
+    }
+    @Test(expected = Exception.class)
+    public void saveHeatFilesTest(){
+        HeatFiles ar = new HeatFiles();
+        cd.saveHeatFiles(ar);
+    }
+    @Test(expected = Exception.class)
+    public void saveVfModuleToHeatFilesTest(){
+        HeatFiles ar = new HeatFiles();
+        cd.saveVfModuleToHeatFiles("3772893",ar);
+    }
+    @Test
+    public void getNetworkResourceByModelUuidTest(){
+
+        cd.getNetworkResourceByModelUuid("3899291");
+    }
+    @Test(expected = Exception.class)
+    public void getNetworkRecipeTest(){
+
+        cd.getNetworkRecipe("test","test1","test2");
+    }
+    @Test(expected = Exception.class)
+    public void getNetworkRecipe2Test(){
+
+        cd.getNetworkRecipe("test","test1");
+    }
+    @Test
+    public void getNetworkResourceByModelCustUuidTest(){
+
+        cd.getNetworkResourceByModelCustUuid("test");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfComponentsRecipe2Test(){
+
+        cd.getVnfComponentsRecipe("test1","test2","test3","test4");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfComponentsRecipeByVfModuleModelUUIdTest(){
+
+        cd.getVnfComponentsRecipeByVfModuleModelUUId("test1","test2","test3");
+    }
+    @Test(expected = Exception.class)
+    public void getVnfComponentRecipesTest(){
+
+        cd.getVnfComponentRecipes("test");
+    }
+    @Test(expected = Exception.class)
+    public void saveOrUpdateVnfComponentTest(){
+        VnfComponent ar = new VnfComponent();
+        cd.saveOrUpdateVnfComponent(ar);
+    }
+
+    @Test(expected = Exception.class)
+    public void getVfModule2Test(){
+
+        cd.getVfModule("test");
+    }
+    @Test(expected = Exception.class)
+    public void getVfModuleByModelUUIDTest(){
+
+        cd.getVfModuleByModelUUID("test");
+    }
+    @Test(expected = Exception.class)
+    public void getServiceRecipeByModelUUIDTest(){
+
+        cd.getServiceRecipeByModelUUID("test1","test2");
+    }
+    @Test(expected = Exception.class)
+    public void getModelRecipeTest(){
+
+        cd.getModelRecipe("test1","test2","test3");
+    }
+    @Test(expected = Exception.class)
+    public void healthCheck(){
+
+        cd.healthCheck();
+    }
+    @Test(expected = Exception.class)
+    public void executeQuerySingleRow(){
+        VnfComponent ar = new VnfComponent();
+        HashMap<String, String> variables = new HashMap<String, String>();
+        cd.executeQuerySingleRow("tets",variables,false);
+    }
+    @Test(expected = Exception.class)
+    public void executeQueryMultipleRows(){
+        HashMap<String, String> variables = new HashMap<String, String>();
+        cd.executeQueryMultipleRows("select",variables,false);
+    }
+}