diff options
Diffstat (limited to 'mso-catalog-db/src/test')
8 files changed, 320 insertions, 313 deletions
diff --git a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/EmbeddedMariaDbConfig.java b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/EmbeddedMariaDbConfig.java index 147de51c67..06a7b1ed29 100644 --- a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/EmbeddedMariaDbConfig.java +++ b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/EmbeddedMariaDbConfig.java @@ -23,7 +23,7 @@ import ch.vorburger.exec.ManagedProcessException; import ch.vorburger.mariadb4j.DBConfigurationBuilder; import ch.vorburger.mariadb4j.springframework.MariaDB4jSpringService; import org.springframework.beans.factory.annotation.Value; -import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder; +import org.springframework.boot.jdbc.DataSourceBuilder; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Profile; diff --git a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudSiteRepositoryTest.java b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudSiteRepositoryTest.java index c5ae3cc83c..8978f38298 100644 --- a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudSiteRepositoryTest.java +++ b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudSiteRepositoryTest.java @@ -24,6 +24,7 @@ import org.junit.Assert; import org.junit.Test; import org.onap.so.db.catalog.BaseTest; import org.onap.so.db.catalog.beans.CloudSite; +import org.onap.so.db.catalog.exceptions.NoEntityFoundException; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.util.CollectionUtils; @@ -43,7 +44,9 @@ public class CloudSiteRepositoryTest extends BaseTest { @Test public void findOneTest() throws Exception { - CloudSite cloudSite = cloudSiteRepository.findOne("mtn13"); + CloudSite cloudSite = cloudSiteRepository.findById("mtn13"). + orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); + Assert.assertNotNull(cloudSite); Assert.assertEquals("mtn13",cloudSite.getId()); } diff --git a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudifyManagerRepositoryTest.java b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudifyManagerRepositoryTest.java index 34c22b07b2..1ed8c84435 100644 --- a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudifyManagerRepositoryTest.java +++ b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/CloudifyManagerRepositoryTest.java @@ -24,6 +24,7 @@ import org.junit.Assert; import org.junit.Test; import org.onap.so.db.catalog.BaseTest; import org.onap.so.db.catalog.beans.CloudifyManager; +import org.onap.so.db.catalog.exceptions.NoEntityFoundException; import org.springframework.beans.factory.annotation.Autowired; public class CloudifyManagerRepositoryTest extends BaseTest { @@ -33,7 +34,8 @@ public class CloudifyManagerRepositoryTest extends BaseTest { @Test public void findOneTest() throws Exception { - CloudifyManager cloudifyManager = cloudifyManagerRepository.findOne("mtn13"); + CloudifyManager cloudifyManager = cloudifyManagerRepository.findById("mtn13") + .orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); Assert.assertNotNull(cloudifyManager); Assert.assertEquals("mtn13", cloudifyManager.getId()); } diff --git a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest.java b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest.java index 52cb46f391..6f0e3020b1 100644 --- a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest.java +++ b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest.java @@ -36,6 +36,7 @@ import org.onap.so.db.catalog.beans.VnfResource; import org.onap.so.db.catalog.beans.VnfResourceCustomization; import org.onap.so.db.catalog.beans.VnfVfmoduleCvnfcConfigurationCustomization; import org.onap.so.db.catalog.beans.VnfcCustomization; +import org.onap.so.db.catalog.exceptions.NoEntityFoundException; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; @@ -51,7 +52,10 @@ public class VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest extends Ba List<VnfVfmoduleCvnfcConfigurationCustomization> vnfVfmoduleCvnfcConfigurationCustomizationList = vnfVfmoduleCvnfcConfigurationCustomizationRepository.findAll(); Assert.assertFalse(CollectionUtils.isEmpty(vnfVfmoduleCvnfcConfigurationCustomizationList)); - VnfVfmoduleCvnfcConfigurationCustomization vnfVfmoduleCvnfcConfigurationCustomization = vnfVfmoduleCvnfcConfigurationCustomizationRepository.findOne(1); + VnfVfmoduleCvnfcConfigurationCustomization vnfVfmoduleCvnfcConfigurationCustomization = + vnfVfmoduleCvnfcConfigurationCustomizationRepository.findById(1).orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); + + Assert.assertTrue(vnfVfmoduleCvnfcConfigurationCustomization.getConfigurationFunction().equalsIgnoreCase("testConfigurationFunction")); } @@ -112,7 +116,8 @@ public class VnfVfmoduleCvnfcConfigurationCustomizationRepositoryTest extends Ba vnfVfmoduleCvnfcConfigurationCustomizationRepository.save(vnfVfmoduleCvnfcConfigurationCustomization); - VnfVfmoduleCvnfcConfigurationCustomization foundVnfVfmoduleCvnfcConfigurationCustomization = vnfVfmoduleCvnfcConfigurationCustomizationRepository.findOne(1); + VnfVfmoduleCvnfcConfigurationCustomization foundVnfVfmoduleCvnfcConfigurationCustomization = + vnfVfmoduleCvnfcConfigurationCustomizationRepository.findById(1).orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); if(foundVnfVfmoduleCvnfcConfigurationCustomization == null) diff --git a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfcCustomizationRepositoryTest.java b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfcCustomizationRepositoryTest.java index 0f82c8abf0..1fc6617c2c 100644 --- a/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfcCustomizationRepositoryTest.java +++ b/mso-catalog-db/src/test/java/org/onap/so/db/catalog/data/repository/VnfcCustomizationRepositoryTest.java @@ -29,6 +29,7 @@ import org.junit.Assert; import org.junit.Test; import org.onap.so.db.catalog.BaseTest; import org.onap.so.db.catalog.beans.VnfcCustomization; +import org.onap.so.db.catalog.exceptions.NoEntityFoundException; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; @@ -42,7 +43,8 @@ public class VnfcCustomizationRepositoryTest extends BaseTest { List<VnfcCustomization> vnfcCustomizationList = vnfcCustomizationRepository.findAll(); Assert.assertFalse(CollectionUtils.isEmpty(vnfcCustomizationList)); - VnfcCustomization vnfcCustomization = vnfcCustomizationRepository.findOne("9bcce658-9b37-11e8-98d0-529269fb1459"); + VnfcCustomization vnfcCustomization = vnfcCustomizationRepository.findById("9bcce658-9b37-11e8-98d0-529269fb1459"). + orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); Assert.assertTrue(vnfcCustomization.getDescription().equalsIgnoreCase("testVnfcCustomizationDescription")); } @@ -54,7 +56,8 @@ public class VnfcCustomizationRepositoryTest extends BaseTest { vnfcCustomization.setModelCustomizationUUID("cf9f6efc-9f14-11e8-98d0-529269fb1459"); vnfcCustomizationRepository.save(vnfcCustomization); - VnfcCustomization foundVnfcCustomization = vnfcCustomizationRepository.findOne("cf9f6efc-9f14-11e8-98d0-529269fb1459"); + VnfcCustomization foundVnfcCustomization = vnfcCustomizationRepository.findById("cf9f6efc-9f14-11e8-98d0-529269fb1459"). + orElseThrow(() -> new NoEntityFoundException("Cannot Find Operation")); assertThat(vnfcCustomization, sameBeanAs(foundVnfcCustomization) .ignoring("created")); diff --git a/mso-catalog-db/src/test/resources/application-test.yaml b/mso-catalog-db/src/test/resources/application-test.yaml index dbff1c1d2f..5d04aa49be 100644 --- a/mso-catalog-db/src/test/resources/application-test.yaml +++ b/mso-catalog-db/src/test/resources/application-test.yaml @@ -14,12 +14,11 @@ mso: spring: datasource: - url: jdbc:mariadb://localhost:3307/ + jdbc-url: jdbc:mariadb://localhost:3307/ username: root password: password driver-class-name: org.mariadb.jdbc.Driver - initialize: true - initialization-mode: never + initialization-mode: always jpa: generate-ddl: false show-sql: true @@ -44,7 +43,7 @@ spring: role: ACTUATOR mariaDB4j: dataDir: - port: 3307 + port: 0 databaseName: catalog_db server: diff --git a/mso-catalog-db/src/test/resources/data.sql b/mso-catalog-db/src/test/resources/data.sql index 3451011ccb..14834ea963 100644 --- a/mso-catalog-db/src/test/resources/data.sql +++ b/mso-catalog-db/src/test/resources/data.sql @@ -27,9 +27,9 @@ insert into service_recipe(id, action, version_str, description, orchestration_u ('1', 'createInstance', '1', 'MSOTADevInfra aLaCarte', '/mso/async/services/CreateGenericALaCarteServiceInstance', null, '180', '0', '2017-04-14 19:18:20', '5df8b6de-2083-11e7-93ae-92361f002671'); insert into heat_template(artifact_uuid, name, version, description, body, timeout_minutes, artifact_checksum, creation_timestamp) values -('ff874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'), -('ff87482f-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'), -('aa874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'); +('ff874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'), +('ff87482f-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'), +('aa874603-4222-11e7-9252-005056850d2e', 'module_mns_zrdm3frwl01exn_01_rgvm_1.yml', '1', 'created from csar', 'heat_template_version: 2013-05-23 description: heat template that creates TEST VNF parameters: TEST_server_name: type: string label: TEST server name description: TEST server name TEST_image_name: type: string label: image name description: TEST image name TEST_flavor_name: type: string label: TEST flavor name description: flavor name of TEST instance TEST_Role_net_name: type: string label: TEST network name description: TEST network name TEST_vnf_id: type: string label: TEST VNF Id description: TEST VNF Id resources:TEST: type: OS::Nova::Server properties: name: { get_param: TEST_server_name } image: { get_param: TEST_image_name } flavor: { get_param: TEST_flavor_name } networks: - port: { get_resource: TEST_port_0} metadata: vnf_id: {get_param: TEST_vnf_id} TEST_port_0: type: OS::Neutron::Port properties: network: { get_param: TEST_Role_net_name }', '60', 'MANUAL RECORD', '2017-01-21 23:26:56'); insert into heat_template_params(heat_template_artifact_uuid, param_name, is_required, param_type, param_alias) values @@ -64,7 +64,7 @@ insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customiza ('68dc9a92-214c-11e7-93ae-92361f002671', 'b4ea86b4-253f-11e7-93ae-92361f002671', '2017-05-26 15:08:24'); insert into allotted_resource(model_uuid, model_invariant_uuid, model_version, model_name, tosca_node_type, subcategory, description, creation_timestamp) values -('f6b7d4c6-e8a4-46e2-81bc-31cad5072842', 'b7a1b78e-6b6b-4b36-9698-8c9530da14af', '1.0', 'Tunnel_Xconn', '', '', '', '2017-05-26 15:08:24'); +('f6b7d4c6-e8a4-46e2-81bc-31cad5072842', 'b7a1b78e-6b6b-4b36-9698-8c9530da14af', '1.0', 'Tunnel_Xconn', '', '', '', '2017-05-26 15:08:24'); insert into allotted_resource_customization(model_customization_uuid, model_instance_name, providing_service_model_invariant_uuid, target_network_role, nf_type, nf_role, nf_function, nf_naming_code, min_instances, max_instances, ar_model_uuid, creation_timestamp) values ('367a8ba9-057a-4506-b106-fbae818597c6', 'Sec_Tunnel_Xconn 11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f6b7d4c6-e8a4-46e2-81bc-31cad5072842', TIMESTAMP '2017-01-20 16:14:20.0'); @@ -130,9 +130,9 @@ insert into vf_module_customization(model_customization_uuid, label, initial_cou insert into vnf_res_custom_to_vf_module_custom(vnf_resource_cust_model_customization_uuid, vf_module_cust_model_customization_uuid, creation_timestamp) values ('68dc9a92-214c-11e7-93ae-92361f002672', 'cb82ffd8-252a-11e7-93ae-92361f002672', '2017-05-26 15:08:24'), ('68dc9a92-214c-11e7-93ae-92361f002672', 'b4ea86b4-253f-11e7-93ae-92361f002672', '2017-05-26 15:08:24'); - - + + insert into vf_module_to_heat_files(vf_module_model_uuid, heat_files_artifact_uuid) values ('20c4431c-246d-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0'), ('066de97e-253e-11e7-93ae-92361f002671', '00535bdd-0878-4478-b95a-c575c742bfb0'); @@ -169,7 +169,7 @@ insert into vnf_recipe(id, nf_role, action, service_type, version_str, descripti insert into vnf_components(vnf_id, component_type, heat_template_id, heat_environment_id, creation_timestamp) values -('13961', 'VOLUME', '13843', '13961', '2016-05-19 20:22:02'); +('13961', 'VOLUME', '13843', '13961', '2016-05-19 20:22:02'); insert into vnf_components_recipe(id, vnf_type, vnf_component_type, action, service_type, version, description, orchestration_uri, vnf_component_param_xsd, recipe_timeout, creation_timestamp, vf_module_model_uuid) values ('5', '*', 'VOLUME_GROUP', 'CREATE', '', '1', 'Recipe Match All for VF Modules if no custom flow exists', '/mso/async/services/createCinderVolumeV1', '', '180', '2016-06-03 10:15:11', ''), @@ -183,8 +183,8 @@ insert into vnf_components_recipe(id, vnf_type, vnf_component_type, action, serv ('19', '', 'vfModule', 'createInstance', '', '1', 'VID_DEFAULT recipe to create vf-module if no custom BPMN flow is found', '/mso/async/services/CreateVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'), ('20', '', 'vfModule', 'deleteInstance', '', '1', 'VID_DEFAULT recipe to delete vf-module if no custom BPMN flow is found', '/mso/async/services/DeleteVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'), ('21', '', 'vfModule', 'updateInstance', '', '1', 'VID_DEFAULT recipe to update vf-module if no custom BPMN flow is found', '/mso/async/services/UpdateVfModuleInfra', '', '180', '2016-09-14 19:18:20', 'VID_DEFAULT'), -('25', '', 'vfModule', 'replaceInstance', '', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', '', '180', '2017-07-28 18:25:06', 'VID_DEFAULT'); - +('25', '', 'vfModule', 'replaceInstance', '', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', '', '180', '2017-07-28 18:25:06', 'VID_DEFAULT'); + insert into network_recipe(id, model_name, action, description, orchestration_uri, network_param_xsd, recipe_timeout, service_type, creation_timestamp, version_str) values ('1', 'CONTRAIL_BASIC', 'CREATE', '', '/mso/async/services/CreateNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'), ('2', 'CONTRAIL_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2016-09-14 19:00:57', '1'), @@ -212,7 +212,7 @@ insert into network_recipe(id, model_name, action, description, orchestration_ur ('172', 'CONTRAIL30_GNDIRECT', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'), ('175', 'CONTRAIL30_GNDIRECT', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-01-17 20:25:34', '1'), ('176', 'NEUTRON_BASIC', 'DELETE', '', '/mso/async/services/DeleteNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'), -('177', 'NEUTRON_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'); +('177', 'NEUTRON_BASIC', 'UPDATE', '', '/mso/async/services/UpdateNetworkV2', '', '180', '', '2017-09-22 18:47:31', '1'); INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION) VALUES ('Service-Create', 'createInstance', 'Service', true, true, '7','7'), @@ -283,7 +283,7 @@ VALUES ('AAIUnsetVnfInMaintBB', 'CUSTOM', 'CUSTOM'), ('SDNOVnfHealthCheckBB', 'CUSTOM', 'CUSTOM'), ('VNF-Macro-Replace', 'CUSTOM', 'CUSTOM'), -('HomingV2', 'CUSTOM', 'CUSTOM'); +('HomingBB', 'CUSTOM', 'CUSTOM'); INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create')), @@ -384,266 +384,266 @@ INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FL INSERT INTO orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) VALUES -('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'), -('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'), -('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'), -('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'), -('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), -('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), -('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), -('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), -('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), -('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), -('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'), -('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), -('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), -('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), -('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'), -('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), -('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), -('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), -('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'), -('VNF', 'PENDING', 'ASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'), -('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'), -('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'), -('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), -('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), -('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), -('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), -('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), -('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), -('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), -('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), -('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), -('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), -('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), -('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'), -('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'), -('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'), -('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'), -('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'), -('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'), -('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'), -('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), -('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'), -('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'), -('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), -('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), -('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), -('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), -('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), -('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'), -('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), -('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'), -('VNF', 'PENDING', 'UNASSIGN', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'), -('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'), -('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'), -('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'), -('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'), -('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'), -('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'), -('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'), -('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'), -('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'), -('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'), -('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'), -('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'), -('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'), -('VNF', 'CREATED', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'), -('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'), -('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'), -('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), -('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), -('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), -('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), -('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'), -('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'), -('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), -('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), -('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), -('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), -('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'), -('VNF', 'PENDING', 'ACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'), -('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'), -('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'), -('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'), -('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'), -('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'), -('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'), -('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), -('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), -('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), -('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), -('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), -('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), -('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), -('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), -('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), -('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'), -('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'), -('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'), -('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), -('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), -('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), -('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'), -('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'), -('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'), -('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'), -('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), -('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), -('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), -('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), -('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'), -('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'), -('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'), -('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'), -('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'), -('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'), -('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'), -('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'), -('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'), -('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'), -('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'), -('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'), -('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'), -('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'), -('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'), -('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), -('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), -('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), -('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'), +('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'), +('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'), +('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'), +('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'), +('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), +('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), +('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'), +('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), +('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), +('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), +('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'), +('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), +('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), +('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), +('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'), +('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), +('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), +('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'), +('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'), +('VNF', 'PENDING', 'ASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'), +('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'), +('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'), +('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), +('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), +('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), +('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'), +('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), +('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), +('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'), +('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), +('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), +('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), +('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'), +('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'), +('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'), +('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'), +('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'), +('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'), +('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'), +('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'), +('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), +('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'), +('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'), +('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), +('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), +('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), +('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'), +('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), +('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'), +('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'), +('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'), +('VNF', 'PENDING', 'UNASSIGN', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'), +('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'), +('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'), +('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'), +('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'), +('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'), +('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'), +('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'), +('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'), +('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'), +('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'), +('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'), +('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'), +('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'), +('VNF', 'CREATED', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'), +('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'), +('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'), +('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), +('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), +('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), +('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'), +('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'), +('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'), +('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), +('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'), +('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), +('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'), +('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'), +('VNF', 'PENDING', 'ACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'), +('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'), +('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'), +('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'), +('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'), +('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'), +('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'), +('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), +('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), +('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), +('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), +('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'), +('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), +('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'), +('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), +('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'), +('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'), +('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'), +('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'), +('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), +('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'), +('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'), +('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'), +('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'), +('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'), +('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'), +('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), +('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), +('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'), +('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'), +('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'), +('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'), +('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'), +('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'), +('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'), +('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'), +('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'), +('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'), +('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'), +('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'), +('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'), +('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'), +('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'), +('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'), +('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'), +('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), +('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), +('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), +('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'), ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'), -('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'), -('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'), -('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'), -('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'), -('NETWORK', 'PENDING', 'CREATE', 'FAIL'), -('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'), -('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'), -('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'), -('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'), -('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'), -('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), -('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), -('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'), -('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'), -('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'), -('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'), -('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'), -('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'), -('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'), -('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'), -('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'), -('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'), -('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'), -('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'), -('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'), -('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'), +('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'), +('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'), +('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'), +('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'), +('NETWORK', 'PENDING', 'CREATE', 'FAIL'), +('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'), +('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'), +('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'), +('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'), +('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'), +('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), +('VF_MODULE', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), +('NETWORK', 'ASSIGNED', 'DELETE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'), +('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'), +('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'), +('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'), +('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'), +('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'), +('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'), +('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'), +('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'), +('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'), +('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'), +('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'), +('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'), +('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'), ('NETWORK', 'PENDING', 'DELETE', 'FAIL'), ('CUSTOM', 'ACTIVE', 'CUSTOM', 'CONTINUE'), ('CUSTOM', 'ASSIGNED', 'CUSTOM', 'CONTINUE'), @@ -657,7 +657,7 @@ VALUES INSERT INTO `cloudify_managers` (`ID`, `CLOUDIFY_URL`, `USERNAME`, `PASSWORD`, `VERSION`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, 'MSO_USER', '2018-07-17 14:05:08', '2018-07-17 14:05:08'); -INSERT INTO `identity_services` (`ID`, `IDENTITY_URL`, `MSO_ID`, `MSO_PASS`, `ADMIN_TENANT`, `MEMBER_ROLE`, `TENANT_METADATA`, `IDENTITY_SERVER_TYPE`, `IDENTITY_AUTHENTICATION_TYPE`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('MTN13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', 'admin', 'admin', 1, 'KEYSTONE', 'USERNAME_PASSWORD', 'MSO_USER', '2018-07-17 14:02:33', '2018-07-17 14:02:33'); +INSERT INTO `identity_services` (`ID`, `IDENTITY_URL`, `MSO_ID`, `MSO_PASS`, `PROJECT_DOMAIN_NAME`, `USER_DOMAIN_NAME`, `ADMIN_TENANT`, `MEMBER_ROLE`, `TENANT_METADATA`, `IDENTITY_SERVER_TYPE`, `IDENTITY_AUTHENTICATION_TYPE`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('MTN13', 'http://localhost:28090/v2.0', 'm93945', '93937EA01B94A10A49279D4572B48369', NULL, NULL, 'admin', 'admin', 1, 'KEYSTONE', 'USERNAME_PASSWORD', 'MSO_USER', '2018-07-17 14:02:33', '2018-07-17 14:02:33'); INSERT INTO `cloud_sites` (`ID`, `REGION_ID`, `IDENTITY_SERVICE_ID`, `CLOUD_VERSION`, `CLLI`, `CLOUDIFY_ID`, `PLATFORM`, `ORCHESTRATOR`, `LAST_UPDATED_BY`, `CREATION_TIMESTAMP`, `UPDATE_TIMESTAMP`) VALUES ('mtn13', 'mtn13', 'MTN13', '2.5', 'MDT13', 'mtn13', NULL, 'orchestrator', 'MSO_USER', '2018-07-17 14:06:28', '2018-07-17 14:06:28'); @@ -758,4 +758,4 @@ VALUES ( '1', 'testConfigurationFunction', 'testPolicyName', '2018-07-17 14:05:08', - 'c59a41ca-9b3b-11e8-98d0-529269fb1459'); + 'c59a41ca-9b3b-11e8-98d0-529269fb1459'); diff --git a/mso-catalog-db/src/test/resources/schema.sql b/mso-catalog-db/src/test/resources/schema.sql index 221f0d8df6..d20a9adb7e 100644 --- a/mso-catalog-db/src/test/resources/schema.sql +++ b/mso-catalog-db/src/test/resources/schema.sql @@ -558,36 +558,29 @@ default character set = latin1; engine = innodb auto_increment = 20654 default character set = latin1; - create table if not exists `service_proxy` ( - `model_uuid` varchar(200) not null, - `model_invariant_uuid` varchar(200) not null, - `model_version` varchar(20) not null, - `model_name` varchar(200) not null, - `description` varchar(1200) null, - `creation_timestamp` datetime not null default current_timestamp, - primary key (`model_uuid`)) - engine = innodb auto_increment = 20654 - default character set = latin1; - -create table if not exists `service_proxy_customization` ( -`model_customization_uuid` varchar(200) not null, -`model_instance_name` varchar(200) not null, -`tosca_node_type` varchar(200) not null, -`source_service_model_uuid` varchar(200) not null, -`creation_timestamp` datetime not null default current_timestamp, -`service_proxy_model_uuid` varchar(200) not null, -primary key (`model_customization_uuid`), -index `fk_service_proxy_customization__service_proxy1_idx` (`service_proxy_model_uuid` asc), -index `fk_service_proxy_customization__service1_idx` (`source_service_model_uuid` asc), -constraint`fk_spr_customization__service_proxy_resource1` -foreign key (`service_proxy_model_uuid`) references `service_proxy` (`model_uuid`) -on delete cascade on update cascade, -constraint `fk_service_proxy_resource_customization__service1` -foreign key (`source_service_model_uuid`) references `service` -(`model_uuid`) on delete cascade on update cascade) -engine = innodb -auto_increment = 20654 -default character set = latin1; + CREATE TABLE IF NOT EXISTS `service_proxy_customization` ( + `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL, + `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL, + `MODEL_UUID` VARCHAR(200) NOT NULL, + `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL, + `MODEL_VERSION` VARCHAR(20) NOT NULL, + `MODEL_NAME` VARCHAR(200) NOT NULL, + `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL, + `DESCRIPTION` VARCHAR(1200) NULL, + `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL, + `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`), + INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC), + UNIQUE INDEX `UK_service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID` ASC), + INDEX `fk_service_proxy_customization__serv_prox_to_serv` (`MODEL_CUSTOMIZATION_UUID` ASC), + CONSTRAINT `fk_service_proxy_resource_customization__service1` + FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) + REFERENCES `service` (`MODEL_UUID`) + ON DELETE CASCADE + ON UPDATE CASCADE) +ENGINE = InnoDB +AUTO_INCREMENT = 20654 +DEFAULT CHARACTER SET = latin1; create table if not exists `configuration_customization` ( `model_customization_uuid` varchar(200) not null, @@ -840,6 +833,8 @@ CREATE TABLE IF NOT EXISTS `identity_services` ( `IDENTITY_URL` varchar(200) DEFAULT NULL, `MSO_ID` varchar(255) DEFAULT NULL, `MSO_PASS` varchar(255) DEFAULT NULL, + `PROJECT_DOMAIN_NAME` varchar(255) DEFAULT NULL, + `USER_DOMAIN_NAME` varchar(255) DEFAULT NULL, `ADMIN_TENANT` varchar(50) DEFAULT NULL, `MEMBER_ROLE` varchar(50) DEFAULT NULL, `TENANT_METADATA` tinyint(1) DEFAULT 0, |