Add the unit test for ExtsysAppTest.

Change-Id: I8ec279cfff9f1f11fac53cc82a555dc719be29a0
Issue-ID: AAI-340
Signed-off-by: lizi00164331 <li.zi30@zte.com.cn>

3 files changed, 68 insertions, 71 deletions

diff --git a/esr-mgr/src/test/resources/db/extsys.mv.db b/esr-mgr/src/test/resources/db/extsys.mv.db
deleted file mode 100644
index facfeac..0000000
--- a/esr-mgr/src/test/resources/db/extsys.mv.db
+++ /dev/null
diff --git a/esr-mgr/src/test/resources/extsys.yml b/esr-mgr/src/test/resources/extsys.yml
new file mode 100644
index 0000000..786be0a
--- /dev/null
+++ b/esr-mgr/src/test/resources/extsys.yml
@@ -0,0 +1,68 @@
+#
+# Copyright 2016-2017 ZTE Corporation.
+#
+# 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.
+#
+
+template: Hello, %s!
+
+#defaultName: ${DW_DEFAULT_NAME:-Stranger}
+# the micro service ip
+serviceIp: 
+msbDiscoveryIp: 10.74.148.80
+msbDiscoveryPort: 10081
+msbServerAddr: http://10.74.148.80:10081
+cloudInfrastructureAddr: http://10.74.148.80/api/aai-cloudInfrastructure/v11
+externalSystemAddr: http://10.74.148.80/api/aai-externalSystem/v11
+registByHand: true
+
+# use the simple server factory if you only want to run on a single port
+#server:
+#  type: simple
+#  connector:
+#    type: http
+#    port: 8080
+server:
+  type: simple
+  rootPath: '/api/aai-esr-server/v1/*'
+  applicationContextPath: /
+  adminContextPath: /admin
+  connector:
+    type: http
+    port: 9518
+
+# Logging settings.
+logging:
+
+  # The default level of all loggers. Can be OFF, ERROR, WARN, INFO, DEBUG, TRACE, or ALL.
+  level: ALL
+
+  # Logger-specific levels.
+  loggers:
+
+    # Sets the level for 'com.example.app' to DEBUG.
+    org.onap.aai.esr.ExtsysApp: INFO
+
+  appenders:
+    - type: console
+      threshold: INFO
+      timeZone: UTC
+      logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n"
+    - type: file
+      threshold: INFO
+      logFormat: "%d{yyyy-MM-dd HH:mm:ss SSS} %-5p [%c][%t] - %m%n"
+      currentLogFilename: ./works/logs/extsys.log
+      archivedLogFilenamePattern: ./works/logs/zip/extsys-%d{yyyy-MM-dd}.log.gz
+      archivedFileCount: 7
+      timeZone: UTC
+
diff --git a/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql b/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql
deleted file mode 100644
index 073c73f..0000000
--- a/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql
+++ /dev/null
@@ -1,71 +0,0 @@
---
--- Copyright 2016 ZTE Corporation.
---
--- 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 TABLE IF EXISTS extsys_base_table;
-CREATE TABLE extsys_base_table (
-	ID                   VARCHAR(200)       NOT NULL,	
-	NAME                    VARCHAR(200)       NULL,
-	TYPE                    VARCHAR(200)       NULL,
-	VENDOR                  VARCHAR(100)       NULL,
-	VERSION                 VARCHAR(100)       NULL,
-	DESCRIPTION             VARCHAR(100)       NULL,
-    CREATETIME              VARCHAR(200)       NULL,
-	CATAGORY                VARCHAR(200)       NULL,
-    CONSTRAINT extsys_base_table PRIMARY KEY(ID)
-);
-DROP TABLE IF EXISTS extsys_ems_table;
-CREATE TABLE extsys_ems_table (
-	EMSID                   VARCHAR(200)       NOT NULL,
-	URL                     VARCHAR(100)       NULL,
-	PRODUCTNAME             VARCHAR(100)       NULL,
-	USERNAME                VARCHAR(100)       NULL,
-	PASSWORD                VARCHAR(100)       NULL,
-    CONSTRAINT extsys_ems_table PRIMARY KEY(EMSID)
-);
-
-DROP TABLE IF EXISTS extsys_sdnc_table;
-CREATE TABLE extsys_sdnc_table (
-	SDNCONTROLLERID       VARCHAR(200)       NOT NULL,
-	URL                     VARCHAR(100)       NULL,
-	USERNAME                VARCHAR(100)       NULL,
-	PASSWORD                VARCHAR(100)       NULL,
-	PRODUCTNAME             VARCHAR(100)       NULL,
-	PROTOCOL                VARCHAR(100)       NULL,
-    CONSTRAINT extsys_sdnc_table PRIMARY KEY(SDNCONTROLLERID)
-);
-
-DROP TABLE IF EXISTS extsys_vim_table;
-CREATE TABLE extsys_vim_table (
-	VIMID                   VARCHAR(200)       NOT NULL,
-	URL                     VARCHAR(100)       NULL,
-	USERNAME                VARCHAR(100)       NULL,
-	PASSWORD                VARCHAR(100)       NULL,
-	DOMAIN                  VARCHAR(100)       NULL,
-	TENANT                  VARCHAR(100)       NULL,
-    CONSTRAINT extsys_vim_table PRIMARY KEY(VIMID)
-);
-
-DROP TABLE IF EXISTS extsys_vnfm_table;
-CREATE TABLE extsys_vnfm_table (
-	VNFMID                  VARCHAR(200)       NOT NULL,
-	URL                     VARCHAR(200)       NULL,
-	USERNAME                VARCHAR(100)       NULL,
-	PASSWORD                VARCHAR(100)       NULL,
-	VIMID                   VARCHAR(100)       NULL,
-	CERTIFICATEURL          VARCHAR(200)       NULL,
-    CONSTRAINT extsys_vnfm_table PRIMARY KEY(VNFMID)
-);
-