kubernetes/so/charts/mariadb/resources/config/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/bulkload-files/automated-tests/create_mso_db-tests.sql

   1 /* Copyright © 2017 AT&T, Amdocs, Bell Canada
   2 *
   3 * Licensed under the Apache License, Version 2.0 (the "License");
   4 * you may not use this file except in compliance with the License.
   5 * You may obtain a copy of the License at
   6 *
   7 *       http://www.apache.org/licenses/LICENSE-2.0
   8 *
   9 * Unless required by applicable law or agreed to in writing, software
  10 * distributed under the License is distributed on an "AS IS" BASIS,
  11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12 * See the License for the specific language governing permissions and
  13 * limitations under the License.
  14 */
  15
  16 SOURCE ../default/create_mso_db-default.sql
  17
  18 USE `mso_requests`;
  19 DROP USER 'mso';
  20 CREATE USER 'mso';
  21 GRANT ALL on mso_requests.* to 'mso' identified by 'mso123' with GRANT OPTION;
  22 FLUSH PRIVILEGES;
  23
  24 USE `mso_catalog`;
  25 DROP USER 'catalog';
  26 CREATE USER 'catalog';
  27 GRANT ALL on mso_catalog.* to 'catalog' identified by 'catalog123' with GRANT OPTION;
  28 FLUSH PRIVILEGES;
  29
  30 LOCK TABLES `NETWORK_RESOURCE` WRITE;
  31 /*!40000 ALTER TABLE `NETWORK_RESOURCE` DISABLE KEYS */;
  32 /*!40000 ALTER TABLE `NETWORK_RESOURCE` ENABLE KEYS */;
  33 insert into NETWORK_RESOURCE (id, NETWORK_TYPE, VERSION_STR, ORCHESTRATION_MODE ,DESCRIPTION, TEMPLATE_ID, NEUTRON_NETWORK_TYPE, AIC_VERSION_MIN) values
  34 (1, "vlan",'1',"NEUTRON","Cool network",1,"BASIC","0");
  35 UNLOCK TABLES;
  36
  37 LOCK TABLES `NETWORK_RECIPE` WRITE;
  38 /*!40000 ALTER TABLE `NETWORK_RECIPE` DISABLE KEYS */;
  39 INSERT INTO `NETWORK_RECIPE`(`NETWORK_TYPE`, `ACTION`, `VERSION_STR`, `DESCRIPTION`, `ORCHESTRATION_URI`, `NETWORK_PARAM_XSD`, `RECIPE_TIMEOUT`, `SERVICE_TYPE`) VALUES
  40 ('vlan','CREATE','1',NULL,'/active-bpel/services/REST/CreateNetwork',NULL,180,NULL),
  41 ('vlan','DELETE','1',NULL,'/active-bpel/services/REST/DeleteNetwork',NULL,180,NULL);
  42 /*!40000 ALTER TABLE `NETWORK_RECIPE` ENABLE KEYS */;
  43 UNLOCK TABLES;
  44
  45 LOCK TABLES `VNF_RECIPE` WRITE;
  46 INSERT INTO `VNF_RECIPE`(`ID`, `VNF_TYPE`, `ACTION`, `VERSION_STR`, `DESCRIPTION`, `ORCHESTRATION_URI`, `VNF_PARAM_XSD`, `RECIPE_TIMEOUT`, `SERVICE_TYPE`) VALUES
  47 (100,'VPE','CREATE','1','','/active-bpel/services/REST/CreateGenericVNF','',180,'SDN-ETHERNET-INTERNET'),
  48 (101,'VPE','DELETE','1','','/active-bpel/services/REST/DeleteGenericVNF','',180,'SDN-ETHERNET-INTERNET');
  49 UNLOCK TABLES;
  50
  51 LOCK TABLES `VF_MODULE` WRITE;
  52 INSERT INTO `VF_MODULE`(`ID`, `TYPE`, `ASDC_SERVICE_MODEL_VERSION`, `MODEL_NAME`, `MODEL_VERSION`, `IS_BASE`, `VNF_RESOURCE_ID`) VALUES
  53 (100,'dns-servicetest/DNSResource-1::VF_DNS::module-1','1.0','VF_DNS::module-1','1.0','1','7'),
  54 (101,'dns-servicetest/DNSResource-1::Mog111..mog_psm..module-1','1.0','Mog111..mog_psm..module-1','1.0','1','7');
  55 UNLOCK TABLES;
  56
  57 LOCK TABLES `VNF_RESOURCE` WRITE;
  58 INSERT INTO `VNF_RESOURCE`(`ID`, `VNF_TYPE`, `ASDC_SERVICE_MODEL_VERSION`, `ORCHESTRATION_MODE`, `MODEL_VERSION`) VALUES
  59 (100,'dns-servicetest/DNSResource-1','1.0','VF_DNS::module-1','1.0');
  60 UNLOCK TABLES;
  61
  62 DELETE FROM HEAT_TEMPLATE_PARAMS;
  63 DELETE FROM HEAT_TEMPLATE;
  64 DELETE FROM HEAT_ENVIRONMENT;