SDN Controller Blueprints Data Adaptor

Creating SDN Controller Blueprints Data Adaptor Junit Tests

Change-Id: Icc825e46b5b128049ddcd4adc3fdc1037d0bee55
Issue-ID: CCSDK-511
Signed-off-by: Singal, Kapil (ks220y) <ks220y@att.com>

6 files changed, 242 insertions, 0 deletions

diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/log4j.properties b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/log4j.properties
new file mode 100644
index 000000000..ce75592ff
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/log4j.properties
@@ -0,0 +1,5 @@
+log4j.rootLogger=INFO, A1
+log4j.appender.A1=org.apache.log4j.ConsoleAppender
+log4j.appender.A1.layout=org.apache.log4j.PatternLayout
+log4j.appender.A1.layout.ConversionPattern=%d{ISO8601} %5p %t %X{UUID} %c{3}:%L - %m%n
+log4j.logger.org.hibernate=INFO
diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/mappings/service-mapping.json b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/mappings/service-mapping.json
new file mode 100644
index 000000000..e595e1613
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/mappings/service-mapping.json
@@ -0,0 +1,11 @@
+{

+	"resource": {

+		"name": "bundle-mac",

+		"searchCriteriaDefintion": {

+			"sourceSystemResourceResolution": {

+				"searchCriteriaValue": "$ptnni_equip_name",

+				"searchCriteriaType": "equipment"

+			}

+		}

+	}

+}         

diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/reference/resource_data.json b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/reference/resource_data.json
new file mode 100644
index 000000000..32162ecaf
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/reference/resource_data.json
@@ -0,0 +1,3 @@
+{

+	"group-name": "AG_AUTORP_NOOVERRIDE"

+}

diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql
new file mode 100644
index 000000000..15d22e242
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/sql/schema.sql
@@ -0,0 +1,46 @@
+
+CREATE TABLE IF NOT EXISTS CONFIG_RESOURCE (
+   config_resource_id   	VARCHAR(50) 	PRIMARY KEY,
+   resource_id          	VARCHAR(50)   	NOT NULL,
+   resource_type        	VARCHAR(50)   	NOT NULL,
+   service_template_name   	VARCHAR(50)		NULL          DEFAULT NULL,
+   service_template_version VARCHAR(50)		NULL          DEFAULT NULL,
+   template_name        	VARCHAR(50)   	NOT NULL,
+   recipe_name          	VARCHAR(50)   	NOT NULL,
+   request_id           	VARCHAR(50)   	NOT NULL,
+   resource_data        	LONGTEXT      	NULL          DEFAULT NULL,
+   mask_data            	LONGTEXT      	NULL          DEFAULT NULL,
+   created_date         	DATETIME      	NOT NULL      DEFAULT CURRENT_TIMESTAMP,
+   status               	VARCHAR(20)   	NOT NULL,
+   updated_by           	VARCHAR(50)   	NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS CONFIG_RESOURCE_ASSIGNMENT_DATA (
+   config_resource_assignment_data_id 	VARCHAR(50) 	PRIMARY KEY,
+   config_resource_id    				VARCHAR(50) 	NOT NULL,
+   version 								INT(11) 		NOT NULL,
+   updated_date    						DATETIME		NOT NULL        DEFAULT CURRENT_TIMESTAMP,
+   updated_by      						VARCHAR(50)    	NOT NULL,
+   template_key_name     				VARCHAR(50)    	NOT NULL,
+   resource_name   						VARCHAR(50)    	NOT NULL,
+   data_type       						VARCHAR(100)    NOT NULL,
+   entry_schema    						VARCHAR(100)    NULL 			DEFAULT NULL,
+   resource_value  						LONGTEXT        NOT NULL,
+   source   							VARCHAR(50)    	NOT NULL,
+   status   							VARCHAR(50)    	NOT NULL,
+   message  							LONGTEXT        NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS CONFIG_TRANSACTION_LOG (
+   config_transaction_log_id  VARCHAR(50)	PRIMARY KEY,
+   request_id                 VARCHAR(50)   NULL          DEFAULT NULL,
+   message_type               VARCHAR(100)  NULL          DEFAULT NULL,
+   creation_date              DATETIME      NOT NULL      DEFAULT CURRENT_TIMESTAMP,
+   message                    LONGTEXT      NULL          DEFAULT NULL
+);
+
+CREATE TABLE IF NOT EXISTS CONFIG_PROPERTY_MAP (
+   reference_key  		VARCHAR(100) 	NOT NULL,
+   reference_value  	VARCHAR(250) 	NOT NULL
+);
+
diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context-h2db.xml b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context-h2db.xml
new file mode 100644
index 000000000..5b0004c1c
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context-h2db.xml
@@ -0,0 +1,82 @@
+<?xml version="1.0" encoding="utf-8"?>

+<!--

+  Copyright © 2017-2018 AT&T Intellectual Property.

+  

+  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.

+-->

+

+<beans xmlns="http://www.springframework.org/schema/beans"

+	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

+	xmlns:jdbc="http://www.springframework.org/schema/jdbc"

+	xmlns:context="http://www.springframework.org/schema/context"

+	xsi:schemaLocation="http://www.springframework.org/schema/beans

+	http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

+	http://www.springframework.org/schema/jdbc

+ 	http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd

+ 	http://www.springframework.org/schema/context

+ 	http://www.springframework.org/schema/context/spring-context-3.1.xsd">

+

+	<context:annotation-config />

+

+	<bean id="test.dataSource"

+		class="org.springframework.jdbc.datasource.DriverManagerDataSource"

+		lazy-init="false">

+		<property name="driverClassName" value="org.h2.Driver" />

+		<property name="url"

+			value="jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MODE=MySQL" />

+	</bean>

+

+	<jdbc:initialize-database

+		data-source="test.dataSource">

+		<jdbc:script location="sql/schema.sql" />

+	</jdbc:initialize-database>

+

+	<bean id="jdbcTemplate"

+		class="org.springframework.jdbc.core.JdbcTemplate">

+		<property name="dataSource" ref="test.dataSource" />

+	</bean>

+

+	<bean id="namedParameterJdbcTemplate"

+		class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">

+		<constructor-arg ref="test.dataSource" />

+	</bean>

+

+	<bean id="configResourceDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.ConfigResourceDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="configPropertyMapDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.ConfigPropertyMapDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="queryExecutorDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.QueryExecutorDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="namedQueryExecutorDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.NamedQueryExecutorDaoImpl">

+		<constructor-arg ref="namedParameterJdbcTemplate" />

+	</bean>

+

+	<bean id="transactionLogDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.TransactionLogDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<context:component-scan

+		base-package="org.onap.ccsdk.config.data.adaptor" />

+

+</beans>

diff --git a/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context.xml b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context.xml
new file mode 100644
index 000000000..0e73b40b3
--- /dev/null
+++ b/blueprints-processor/adaptors/data-adaptor-provider/src/test/resources/test-context.xml
@@ -0,0 +1,95 @@
+<?xml version="1.0" encoding="utf-8"?>

+<!--

+  Copyright © 2017-2018 AT&T Intellectual Property.

+  

+  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.

+-->

+

+<beans xmlns="http://www.springframework.org/schema/beans"

+	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

+	xmlns:jdbc="http://www.springframework.org/schema/jdbc"

+	xmlns:context="http://www.springframework.org/schema/context"

+	xsi:schemaLocation="http://www.springframework.org/schema/beans

+	http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

+	http://www.springframework.org/schema/jdbc

+ 	http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd

+ 	http://www.springframework.org/schema/context

+ 	http://www.springframework.org/schema/context/spring-context-3.1.xsd

+ 					">

+

+	<context:annotation-config />

+

+	<bean id="test.dataSource"

+		class="org.springframework.jdbc.datasource.DriverManagerDataSource"

+		lazy-init="false">

+		<property name="driverClassName"

+			value="org.mariadb.jdbc.Driver" />

+		<property name="url"

+			value="jdbc:mysql://localhost:3306/sdnctl" />

+		<property name="username" value="sdnctl" />

+		<property name="password" value="sdnctl" />

+	</bean>

+

+

+	<!-- <bean id="test.dataSource" -->

+	<!-- class="org.springframework.jdbc.datasource.DriverManagerDataSource" -->

+	<!-- lazy-init="false"> -->

+	<!-- <property name="driverClassName" value="org.h2.Driver" /> -->

+	<!-- <property name="url" -->

+	<!-- value="jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MODE=MySQL" /> -->

+	<!-- </bean> -->

+	<!-- <jdbc:initialize-database data-source="test.dataSource"> -->

+	<!-- <jdbc:script location="sql/schema.sql" /> -->

+	<!-- </jdbc:initialize-database> -->

+	<!-- <bean id="dataSetup" -->

+	<!-- class="org.onap.ccsdk.config.data.adaptor.db.utils.DataSetup"> -->

+	<!-- <property name="testDb" ref="testDb" /> -->

+	<!-- </bean> -->

+	<!-- <bean id="testDb" class="org.onap.ccsdk.config.data.adaptor.db.utils.TestDb"> -->

+	<!-- <property name="jdbcTemplate" ref="jdbcTemplate" /> -->

+	<!-- </bean> -->

+

+	<bean id="jdbcTemplate"

+		class="org.springframework.jdbc.core.JdbcTemplate">

+		<property name="dataSource" ref="test.dataSource" />

+	</bean>

+

+	<bean id="namedParameterJdbcTemplate"

+		class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">

+		<constructor-arg ref="test.dataSource" />

+	</bean>

+

+	<bean id="configResourcelDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.ConfigResourceDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="ConfigPropertyMapDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.ConfigPropertyMapDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="queryExecutorDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.QueryExecutorDaoImpl">

+		<constructor-arg ref="jdbcTemplate" />

+	</bean>

+

+	<bean id="namedQueryExecutorDao"

+		class="org.onap.ccsdk.config.data.adaptor.dao.NamedQueryExecutorDaoImpl">

+		<constructor-arg ref="namedParameterJdbcTemplate" />

+	</bean>

+

+	<context:component-scan

+		base-package="org.onap.ccsdk.config.data.adaptor" />

+

+</beans>