change application.properties $ standalone for separate postgres

Issue-ID: USECASEUI-405
Signed-off-by: Junyi Du <hunterdevil@foxmail.com>
Change-Id: Icad7ec5441f71819ee27a23c2cb1b79ef8d45517

4 files changed, 0 insertions, 344 deletions

diff --git a/standalone/src/main/assembly/resources/bin/initDB.sh b/standalone/src/main/assembly/resources/bin/initDB.sh
deleted file mode 100644
index ff5d4152..00000000
--- a/standalone/src/main/assembly/resources/bin/initDB.sh
+++ /dev/null
@@ -1,59 +0,0 @@
-#!/bin/sh
-#
-# Copyright (C) 2019 CMCC, Inc. and others. 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.
-#
-
-echo "setting database init parameters"
-main_path="/home/uui"
-host=$1
-port=$2
-user_pg=$3
-user_uui=$4
-
-echo "setting postgres database password"
-#su - $user_pg <<EOF
-psql --command "alter user $user_pg with password '$user_pg';"
-#EOF
-
-echo "start create usecase-ui database..."
-dbscripts_path="$main_path/resources/dbscripts/postgres"
-psql "host=$host port=$port user=$user_pg password=$user_pg dbname=$user_pg" -f $dbscripts_path/uui_create_db.sql
-sql_result=$?
-if [ $sql_result -ne 0 ]; then
-    echo "failed to create usecase-ui database!"
-    exit 1
-else
-    echo "usecase-ui database created successfully!"
-fi
-
-echo "start create usecase-ui tables..."
-psql "host=$host port=$port user=$user_uui password=$user_uui dbname=$user_uui" -f $dbscripts_path/uui_create_table.sql
-sql_result=$?
-if [ $sql_result -ne 0 ]; then
-    echo "failed to create usecase-ui table!"
-    exit 1
-else
-    echo "usecase-ui tables created successfully!"
-fi
-
-echo "start insert initial data into uui-server database..."
-psql "host=$host port=$port user=$user_uui password=$user_uui dbname=$user_uui" -f $dbscripts_path/uui_init_data.sql
-sql_result=$?
-if [ $sql_result -ne 0 ]; then
-    echo "failed to insert initial data!"
-    exit 1
-else
-    echo "usecase-ui database initial data import succeed!"
-fi
diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql
deleted file mode 100644
index 49e9e593..00000000
--- a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql
+++ /dev/null
@@ -1,26 +0,0 @@
---
--- Copyright (C) 2019 CMCC, Inc. and others. 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.
---
-
--- create uui user
-create user "uui" with password 'uui' nocreatedb;
-
--- create uui database
-drop database if exists uui;
-create database uui with owner uui template template0 encoding 'UTF8';
-
--- grant uui create uui user
-grant all privileges on database uui to uui;
-grant all privileges on database uui to postgres;
diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
deleted file mode 100644
index 4e43e20d..00000000
--- a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
+++ /dev/null
@@ -1,224 +0,0 @@
---
--- Copyright (C) 2019 CMCC, Inc. and others. 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.
---
-
--- ----------------------------
--- Table structure for "alarms_additionalinformation"
--- ----------------------------
-DROP TABLE IF EXISTS alarms_additionalinformation;
-CREATE TABLE alarms_additionalinformation(
-  id serial,
-  "header_id" varchar(50) NOT NULL,
-  "name" varchar(100) DEFAULT NULL,
-  "value" varchar(100) DEFAULT NULL,
-  "source_id" varchar(100) DEFAULT NULL,
-  "start_epoch_microsec" varchar(100) DEFAULT NULL,
-  "last_epoch_microsec" varchar(100) DEFAULT NULL,
-  CONSTRAINT alarms_additionalinformation_pk PRIMARY KEY (id)
-) WITH ( OIDS = FALSE);
-
--- ----------------------------
--- Table structure for "alarms_commoneventheader"
--- ----------------------------
-DROP TABLE IF EXISTS alarms_commoneventheader;
-CREATE TABLE alarms_commoneventheader (
-  "id" varchar(50) NOT NULL,
-  "version" varchar(100) DEFAULT NULL,
-  "event_name" varchar(100) DEFAULT NULL,
-  "domain" varchar(100) DEFAULT NULL,
-  "event_id" varchar(100) DEFAULT NULL,
-  "event_type" varchar(100) DEFAULT NULL,
-  "nfc_naming_code" varchar(100) DEFAULT NULL,
-  "nf_naming_code" varchar(100) DEFAULT NULL,
-  "source_id" varchar(100) DEFAULT NULL,
-  "source_name" varchar(100) DEFAULT NULL,
-  "reporting_entity_id" varchar(100) DEFAULT NULL,
-  "reporting_entity_name" varchar(100) DEFAULT NULL,
-  "priority" varchar(50) DEFAULT NULL,
-  "start_epoch_microsec" varchar(100) DEFAULT NULL,
-  "last_epoch_microsec" varchar(100) DEFAULT NULL,
-  "start_epoch_microsec_cleared" varchar(100) DEFAULT NULL,
-  "last_epoch_microsec_cleared" varchar(100) DEFAULT NULL,
-  "sequence" varchar(100) DEFAULT NULL,
-  "fault_fields_version" varchar(100) DEFAULT NULL,
-  "event_servrity" varchar(100) DEFAULT NULL,
-  "event_source_type" varchar(100) DEFAULT NULL,
-  "event_category" varchar(100) DEFAULT NULL,
-  "alarm_condition" varchar(100) DEFAULT NULL,
-  "specific_problem" varchar(100) DEFAULT NULL,
-  "vf_status" varchar(100) DEFAULT NULL,
-  "alarm_interfacea" varchar(100) DEFAULT NULL,
-  "status" varchar(50) DEFAULT NULL,
-  CONSTRAINT alarms_commoneventheader_pk PRIMARY KEY (id)
-) WITH ( OIDS = FALSE );
-
--- ----------------------------
--- Table structure for "performance_additionalinformation"
--- ----------------------------
-DROP TABLE IF EXISTS performance_additionalinformation;
-CREATE TABLE performance_additionalinformation (
-  id serial,
-  "header_id" varchar(50) NOT NULL,
-  "name" varchar(100) DEFAULT NULL,
-  "value" varchar(100) DEFAULT NULL,
-  "source_id" varchar(100) DEFAULT NULL,
-  "start_epoch_microsec" varchar(100) DEFAULT NULL,
-  "last_epoch_microsec" varchar(100) DEFAULT NULL,
-  CONSTRAINT performance_additionalinformation_pk PRIMARY KEY (id)
-) WITH ( OIDS = FALSE );
-
--- ----------------------------
--- Table structure for "performance_commoneventheader"
--- ----------------------------
-DROP TABLE IF EXISTS performance_commoneventheader;
-CREATE TABLE performance_commoneventheader (
-  "id" varchar(50) NOT NULL,
-  "version" varchar(100) DEFAULT NULL,
-  "event_name" varchar(100) DEFAULT NULL,
-  "domain" varchar(100) DEFAULT NULL,
-  "event_id" varchar(100) DEFAULT NULL,
-  "event_type" varchar(100) DEFAULT NULL,
-  "nfc_naming_code" varchar(100) DEFAULT NULL,
-  "nf_namingcode" varchar(100) DEFAULT NULL,
-  "source_id" varchar(100) DEFAULT NULL,
-  "source_name" varchar(100) DEFAULT NULL,
-  "reporting_entity_id" varchar(100) DEFAULT NULL,
-  "reporting_entity_name" varchar(100) DEFAULT NULL,
-  "priority" varchar(50) DEFAULT NULL,
-  "start_epoch_microsec" varchar(100) DEFAULT NULL,
-  "last_epoch_microsec" varchar(100) DEFAULT NULL,
-  "sequence" varchar(100) DEFAULT NULL,
-  "measurements_for_vf_scaling_version" varchar(100) DEFAULT NULL,
-  "measurement_interval" varchar(100) DEFAULT NULL,
-  CONSTRAINT performance_commoneventheader_pk PRIMARY KEY (id)
-) WITH (OIDS = FALSE);
-
--- ----------------------------
--- Table structure for service_instances
--- ----------------------------
-DROP TABLE IF EXISTS service_instances;
-CREATE TABLE service_instances  (
-  "id" varchar(50) NOT NULL,
-  "service_instance_id" varchar(100) NOT NULL,
-  "customer_id" varchar(50) NOT NULL,
-  "service_type" varchar(50) NOT NULL,
-  "usecase_type" varchar(50) NOT NULL,
-  "uuid" varchar(100),
-  "invariant_uuid" varchar(100),
-  CONSTRAINT service_instances_pk PRIMARY KEY (service_instance_id)
-);
-
--- ----------------------------
--- Table structure for service_instance_operations
--- ----------------------------
-DROP TABLE IF EXISTS service_instance_operations;
-CREATE TABLE service_instance_operations  (
-  "service_instance_id" varchar(100) NOT NULL,
-  "operation_id" varchar(100) NOT NULL,
-  "operation_type" varchar(50) NOT NULL,
-  "operation_progress" varchar(50) NOT NULL,
-  "operation_result" varchar(100) DEFAULT NULL,
-  "start_time" varchar(100) NOT NULL,
-  "end_time" varchar(100),
-  CONSTRAINT service_instance_operations_pk PRIMARY KEY (service_instance_id, operation_id)
-);
-
--- ----------------------------
--- Table structure for sort_master
--- ----------------------------
-DROP TABLE IF EXISTS sort_master;
-CREATE TABLE sort_master  (
-  "sort_type" varchar(50) NOT NULL,
-  "sort_code" varchar(10) NOT NULL,
-  "sort_value" varchar(100) NOT NULL,
-  "language" varchar(50) NOT NULL,
-  CONSTRAINT sort_master_pk PRIMARY KEY (sort_type, sort_code, language)
-);
-
--- ----------------------------
--- Table structure for sort_master
--- ----------------------------
-DROP TABLE IF EXISTS instance_performance;
-CREATE TABLE instance_performance
-(
-    id                   serial not null
-        constraint instance_performance_pk
-            primary key,
-    job_id               varchar(36),
-    resource_instance_id varchar(36),
-    bandwidth            numeric,
-    date                 timestamp,
-    max_bandwidth        numeric
-);
-
--- ----------------------------
--- Table structure for ccvpn_instance
--- ----------------------------
-DROP TABLE IF EXISTS ccvpn_instance;
-CREATE TABLE ccvpn_instance
-(
-    id                          serial not null
-        constraint ccvpn_instance_pk
-            primary key,
-    instance_id                 varchar(16),
-    job_id                      varchar(36),
-    progress                    integer,
-    status                      char default 0,
-    resource_instance_id        varchar(36),
-    name                        varchar(255),
-    cloud_point_name            varchar(255),
-    access_point_one_name       varchar(255),
-    access_point_one_band_width integer,
-    line_num                    varchar(64),
-    delete_state                integer default 0,
-    protect_status              integer default 0,
-    protection_cloud_point_name       varchar(255),
-    protection_type       varchar(255)
-);
-
--- ----------------------------
--- Table structure for intent_model
--- ----------------------------
-DROP TABLE IF EXISTS intent_model;
-create table intent_model
-(
-    id          serial not null
-        constraint intent_model_pk
-            primary key,
-    model_name  varchar(100) default NULL::character varying,
-    file_path   varchar(500) default NULL::character varying,
-    create_time varchar(100) default NULL::character varying,
-    size        numeric(10, 3),
-    active      integer,
-    model_type integer      default 0
-);
-
--- ----------------------------
--- Table structure for intent_instance
--- ----------------------------
-DROP TABLE IF EXISTS intent_instance;
-create table intent_instance
-(
-    id                   serial not null
-        constraint intent_instance_pk
-            primary key,
-    intent_name          varchar(50),
-    intent_source        integer,
-    customer             varchar(50),
-    intent_content       text,
-    intent_config        text,
-    business_instance_id varchar(50),
-    business_instance    varchar(255)
-);
diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_init_data.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_init_data.sql
deleted file mode 100644
index b2e68eb3..00000000
--- a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_init_data.sql
+++ /dev/null
@@ -1,35 +0,0 @@
---
--- Copyright (C) 2019 CMCC, Inc. and others. 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.
---
-
--- ----------------------------
--- import initial data for sort_master
--- ----------------------------
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1001', 'Creating', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1002', 'Deleting', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1003', 'Scaling', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1004', 'Healing', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1005', 'Updating', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1001', '创建', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1002', '删除', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1003', '缩扩容', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1004', '自愈', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationType', '1005', '更新', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2001', 'Successful', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2002', 'Failed', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2003', 'In Progress', 'en');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2001', '成功', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2002', '失败', 'cn');
-INSERT INTO sort_master (sort_type, sort_code, sort_value, language) VALUES ('operationResult', '2003', '执行中', 'cn');