From 2266ce0436b3d0f50dcdb39f16b71102dd6defd6 Mon Sep 17 00:00:00 2001 From: Luji7 Date: Tue, 26 Sep 2017 15:44:06 +0800 Subject: ns and vf package distribution Change-Id: I0caba0dbd2719c008e5d9ffa0b89a5552ed15c4d Issue-Id: USECASEUI-39 Signed-off-by: Luji7 --- .../src/main/assembly/resources/bin/initDB.sh | 50 ++++++++++ .../dbscripts/mysql/usecase-ui-createdb.sql | 31 ++++++ .../dbscripts/mysql/usecase-ui-createobj.sql | 111 +++++++++++++++++++++ 3 files changed, 192 insertions(+) create mode 100644 standalone/src/main/assembly/resources/bin/initDB.sh create mode 100644 standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql create mode 100644 standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql (limited to 'standalone') diff --git a/standalone/src/main/assembly/resources/bin/initDB.sh b/standalone/src/main/assembly/resources/bin/initDB.sh new file mode 100644 index 00000000..06d2bfc8 --- /dev/null +++ b/standalone/src/main/assembly/resources/bin/initDB.sh @@ -0,0 +1,50 @@ +#!/bin/bash +# +# Copyright (C) 2017 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. +# + +DIRNAME=`dirname $0` +HOME=`cd $DIRNAME/; pwd` +user=$1 +password=$2 +port=$3 +host=$4 +echo "start create usecase-ui db" +sql_path=$HOME/../ +mysql -u$user -p$password -P$port -h$host <$sql_path/dbscripts/mysql/usecase-ui-createdb.sql +sql_result=$? +if [ $sql_result != 0 ] ; then + echo "failed to create usecase-ui database" + exit 1 +fi +fileFlag=*createobj.sql +location=$sql_path/dbscripts/mysql +fileName="" +for i in `ls $location` +do + if [[ $i == ${fileFlag} ]];then + fileName=${i}; + echo "start create table:${fileName}" + mysql -u$user -p$password -P$port -h$host <$sql_path/dbscripts/mysql/$fileName + sql_result=$? + if [ $sql_result != 0 ] ; then + echo "failed to init usecase-ui table:${fileName}" + exit 1 + fi + fi +done +echo "init usecase-ui database success!" +exit 0 + diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql new file mode 100644 index 00000000..31ab5b5e --- /dev/null +++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createdb.sql @@ -0,0 +1,31 @@ +-- +-- Copyright (C) 2017 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. +-- + +/******************drop old database and user***************************/ +use mysql; +drop database IF EXISTS usercaseui; +delete from user where User='usecaseui'; +FLUSH PRIVILEGES; + +/******************create new database and user***************************/ +create database usercaseui CHARACTER SET utf8; + +GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'%' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; + +GRANT ALL PRIVILEGES ON usercaseui.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON mysql.* TO 'usercaseui'@'localhost' IDENTIFIED BY 'usercaseui' WITH GRANT OPTION; +FLUSH PRIVILEGES; \ No newline at end of file diff --git a/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql new file mode 100644 index 00000000..7a55c72b --- /dev/null +++ b/standalone/src/main/assembly/resources/dbscripts/mysql/usecase-ui-createobj.sql @@ -0,0 +1,111 @@ +-- +-- Copyright (C) 2017 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. +-- + +use usercaseui; + +SET FOREIGN_KEY_CHECKS=0; +-- ---------------------------- +-- Table structure for alarms_additionalinformation +-- ---------------------------- +DROP TABLE IF EXISTS `alarms_additionalinformation`; +CREATE TABLE `alarms_additionalinformation` ( + `name` varchar(50) NOT NULL, + `value` varchar(500) NOT NULL, + `eventId` varchar(30) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`name`,`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for alarms_commoneventheader +-- ---------------------------- +DROP TABLE IF EXISTS `alarms_commoneventheader`; +CREATE TABLE `alarms_commoneventheader` ( + `version` varchar(10) NOT NULL, + `eventName` varchar(50) NOT NULL, + `domain` varchar(30) NOT NULL, + `eventId` varchar(30) NOT NULL, + `eventType` varchar(30) NOT NULL, + `nfcNamingCode` varchar(30) DEFAULT NULL, + `nfNamingCode` varchar(30) DEFAULT NULL, + `sourceId` varchar(50) NOT NULL, + `sourceName` varchar(50) NOT NULL, + `reportingEntityId` varchar(30) NOT NULL, + `reportingEntityName` varchar(30) NOT NULL, + `priority` varchar(20) NOT NULL, + `startEpochMicrosec` varchar(20) NOT NULL, + `lastEpochMicroSec` varchar(20) NOT NULL, + `sequence` varchar(10) NOT NULL, + `faultFieldsVersion` varchar(10) NOT NULL, + `eventServrity` varchar(30) NOT NULL, + `eventSourceType` varchar(30) NOT NULL, + `eventCategory` varchar(30) NOT NULL, + `alarmCondition` varchar(400) NOT NULL, + `specificProblem` varchar(400) NOT NULL, + `vfStatus` varchar(10) NOT NULL, + `alarmInterfaceA` varchar(40) NOT NULL, + `status` varchar(11) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for performance_additionalinformation +-- ---------------------------- +DROP TABLE IF EXISTS `performance_additionalinformation`; +CREATE TABLE `performance_additionalinformation` ( + `name` varchar(50) NOT NULL, + `value` varchar(500) NOT NULL, + `eventId` varchar(30) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`name`,`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Table structure for performance_commoneventheader +-- ---------------------------- +DROP TABLE IF EXISTS `performance_commoneventheader`; +CREATE TABLE `performance_commoneventheader` ( + `version` varchar(10) NOT NULL, + `eventName` varchar(50) NOT NULL, + `domain` varchar(30) NOT NULL, + `eventId` varchar(30) NOT NULL, + `eventType` varchar(30) NOT NULL, + `nfcNamingCode` varchar(30) DEFAULT NULL, + `nfNamingCode` varchar(30) DEFAULT NULL, + `sourceId` varchar(50) NOT NULL, + `sourceName` varchar(50) NOT NULL, + `reportingEntityId` varchar(30) NOT NULL, + `reportingEntityName` varchar(30) NOT NULL, + `priority` varchar(20) NOT NULL, + `startEpochMicrosec` varchar(20) NOT NULL, + `lastEpochMicroSec` varchar(20) NOT NULL, + `sequence` varchar(10) NOT NULL, + `measurementsForVfScalingVersion` varchar(10) NOT NULL, + `measurementInterval` varchar(10) NOT NULL, + `createTime` datetime NOT NULL, + `updateTime` datetime NOT NULL, + PRIMARY KEY (`eventId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- ---------------------------- +-- Init Records +-- ---------------------------- +INSERT INTO `alarms_additionalinformation` VALUES ('name', 'value', 'eventId', '2017-09-19 11:12:34', '2017-09-19 11:12:34'); +INSERT INTO `alarms_commoneventheader` VALUES ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '2017-09-04 15:25:11', '2017-09-11 15:25:19'); -- cgit 1.2.3-korg