Benjamin, Max (mb388a) | 5a6a6de | 2018-07-30 15:56:09 -0400 | [diff] [blame] | 1 | use catalogdb; |
| 2 | |
| 3 | 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'); |
| 4 | |
| 5 | insert into temp_network_heat_template_lookup(network_resource_model_name, heat_template_artifact_uuid, aic_version_min, aic_version_max) values |
| 6 | ('CONTRAIL30_GNDIRECT', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3'), |
| 7 | ('MSO_Example', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3'), |
| 8 | ('ExtVL', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3'), |
| 9 | ('AIC30_CONTRAIL_BASIC', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3'), |
| 10 | ('CONTRAIL30_BASIC', 'ff874603-4222-11e7-9252-005056850d2e', '3', '3'); |
| 11 | |
| 12 | insert into network_resource(model_uuid, model_name, model_invariant_uuid, description, heat_template_artifact_uuid, neutron_network_type, model_version, tosca_node_type, aic_version_min, aic_version_max, orchestration_mode, creation_timestamp) values |
| 13 | ('10b36f65-f4e6-4be6-ae49-9596dc1c47fc', 'CONTRAIL30_GNDIRECT', 'ce4ff476-9641-4e60-b4d5-b4abbec1271d', 'Contrail 30 GNDIRECT NW', 'ff874603-4222-11e7-9252-005056850d2e', 'BASIC', '1.0', '', '3.0', '', 'HEAT', '2017-01-17 20:35:05'); |
| 14 | |
| 15 | insert into network_resource_customization(model_customization_uuid, model_instance_name, network_technology, network_type, network_role, network_scope, creation_timestamp, network_resource_model_uuid) values |
| 16 | ('3bdbb104-476c-483e-9f8b-c095b3d308ac', 'CONTRAIL30_GNDIRECT 9', '', '', '', '', '2017-04-19 14:28:32', '10b36f65-f4e6-4be6-ae49-9596dc1c47fc'); |
| 17 | |
| 18 | |
| 19 | |
| 20 | INSERT INTO temp_network_heat_template_lookup(NETWORK_RESOURCE_MODEL_NAME, HEAT_TEMPLATE_ARTIFACT_UUID, AIC_VERSION_MIN, AIC_VERSION_MAX) VALUES |
| 21 | ('TENANT_OAM_NETWORK', 'ff874603-4222-11e7-9252-005056850d2e', '3.0', NULL); |
| 22 | INSERT INTO temp_network_heat_template_lookup(NETWORK_RESOURCE_MODEL_NAME, HEAT_TEMPLATE_ARTIFACT_UUID, AIC_VERSION_MIN, AIC_VERSION_MAX) VALUES |
| 23 | ('SRIOV_PROVIDER_NETWORK', 'ff874603-4222-11e7-9252-005056850d2e', '3.0', NULL); |
| 24 | |
| 25 | |
| 26 | --------START Request DB INSERTS -------- |
| 27 | insert into requestdb.watchdog_distributionid_status(DISTRIBUTION_ID, DISTRIBUTION_ID_STATUS) values |
| 28 | ('watchdogTestStatusSuccess', 'SUCCESS'), |
| 29 | ('watchdogTestStatusFailure', 'FAILURE'), |
| 30 | ('watchdogTestStatusTimeout', 'TIMEOUT'), |
| 31 | ('watchdogTestStatusIncomplete', 'INCOMPLETE'), |
| 32 | ('watchdogTestStatusException', 'EXCEPTION'), |
| 33 | ('watchdogTestStatusNull', 'NULL'), |
| 34 | ('testStatusSuccessTosca', 'SUCCESS'), |
| 35 | ('testStatusFailureTosca', 'FAILURE'), |
| 36 | ('testStatusTimeoutTosca', 'TIMEOUT'), |
| 37 | ('testStatusIncompleteTosca', 'INCOMPLETE'), |
| 38 | ('testStatusExceptionTosca', 'EXCEPTION'), |
| 39 | ('testStatusNullTosca', 'NULL'); |
| 40 | |
| 41 | --WatchdogDistrubutionTest |
| 42 | insert into requestdb.watchdog_per_component_distribution_status(DISTRIBUTION_ID, COMPONENT_NAME, COMPONENT_DISTRIBUTION_STATUS) values |
| 43 | ('watchdogTestStatusSuccess', 'SO', 'COMPONENT_DONE_OK'), |
| 44 | ('watchdogTestStatusSuccess', 'AAI', 'COMPONENT_DONE_OK'), |
| 45 | ('watchdogTestStatusSuccess', 'SDNC', 'COMPONENT_DONE_OK'), |
| 46 | ('watchdogTestStatusFailure', 'SO', 'COMPONENT_DONE_ERROR'), |
| 47 | ('watchdogTestStatusFailure', 'AAI', 'COMPONENT_DONE_ERROR'), |
| 48 | ('watchdogTestStatusFailure', 'SDNC', 'COMPONENT_DONE_ERROR'), |
| 49 | ('watchdogTestStatusException', 'SO', 'COMPONENT_MALFORMED'), |
| 50 | ('watchdogTestStatusException', 'AAI', 'COMPONENT_MALFORMED'), |
| 51 | ('watchdogTestStatusException', 'SDNC', 'COMPONENT_MALFORMED'), |
| 52 | ('testStatusSuccessTosca', 'SO', 'COMPONENT_DONE_OK'), |
| 53 | ('testStatusSuccessTosca', 'AAI', 'COMPONENT_DONE_OK'), |
| 54 | ('testStatusSuccessTosca', 'SDNC', 'COMPONENT_DONE_OK'), |
| 55 | ('testStatusFailureTosca', 'SO', 'COMPONENT_DONE_ERROR'), |
| 56 | ('testStatusFailureTosca', 'AAI', 'COMPONENT_DONE_ERROR'), |
| 57 | ('testStatusFailureTosca', 'SDNC', 'COMPONENT_DONE_ERROR'), |
| 58 | ('testStatusExceptionTosca', 'SO', 'COMPONENT_MALFORMED'), |
| 59 | ('testStatusExceptionTosca', 'AAI', 'COMPONENT_MALFORMED'), |
| 60 | ('testStatusExceptionTosca', 'SDNC', 'COMPONENT_MALFORMED'); |
| 61 | |
Benjamin, Max (mb388a) | 9e795be | 2019-02-06 21:17:24 -0500 | [diff] [blame] | 62 | insert into requestdb.watchdog_service_mod_ver_id_lookup(DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID, DISTRIBUTION_NOTIFICATION, CONSUMER_ID) values |
| 63 | ('watchdogTestStatusSuccess', '5df8b6de-2083-11e7-93ae-92361f002671', NULL, NULL), |
| 64 | ('watchdogTestStatusNull', '00000000-0000-0000-0000-000000000000', NULL, NULL); |