summaryrefslogtreecommitdiffstats
path: root/sql-resource/provider/src/test
diff options
context:
space:
mode:
authorJessica Wagantall <jwagantall@linuxfoundation.org>2020-12-01 11:26:31 -0800
committerJessica Wagantall <jwagantall@linuxfoundation.org>2020-12-01 11:27:11 -0800
commit11510b43c277b8e1dd7e58d79785544810118c8e (patch)
treeb88a497c999d24b5f357ea9b26bc93e0990fd5e7 /sql-resource/provider/src/test
parent5d2eab72fc4442f14108b41800cec88126913823 (diff)
Migrate sli-adaptor files
Migrate sli-adaptor repo files into a new "adaptors" directory. Signed-off-by: Jessica Wagantall <jwagantall@linuxfoundation.org>
Diffstat (limited to 'sql-resource/provider/src/test')
-rwxr-xr-xsql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/ITCaseSqlResource.java231
-rwxr-xr-xsql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/SqlResourceProviderTest.java38
-rwxr-xr-xsql-resource/provider/src/test/resources/delete.tests2
-rwxr-xr-xsql-resource/provider/src/test/resources/query.tests5
-rwxr-xr-xsql-resource/provider/src/test/resources/save.tests13
-rw-r--r--sql-resource/provider/src/test/resources/simplelogger.properties22
-rwxr-xr-xsql-resource/provider/src/test/resources/sql-resource.properties23
-rw-r--r--sql-resource/provider/src/test/resources/svclogic.properties35
8 files changed, 0 insertions, 369 deletions
diff --git a/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/ITCaseSqlResource.java b/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/ITCaseSqlResource.java
deleted file mode 100755
index 2863c6c96..000000000
--- a/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/ITCaseSqlResource.java
+++ /dev/null
@@ -1,231 +0,0 @@
-/*-
- * ============LICENSE_START=======================================================
- * openECOMP : SDN-C
- * ================================================================================
- * Copyright (C) 2017 AT&T Intellectual Property. 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.
- * ============LICENSE_END=========================================================
- */
-
-package org.onap.ccsdk.sli.adaptors.resource.sql;
-
-import java.io.BufferedReader;
-import java.io.InputStream;
-import java.io.InputStreamReader;
-import java.util.Enumeration;
-import java.util.Properties;
-
-import org.onap.ccsdk.sli.core.sli.SvcLogicContext;
-import org.onap.ccsdk.sli.core.sli.SvcLogicResource.QueryStatus;
-import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
-
-import ch.vorburger.mariadb4j.DB;
-import ch.vorburger.mariadb4j.DBConfigurationBuilder;
-import junit.framework.TestCase;
-
-public class ITCaseSqlResource extends TestCase {
-
- private static final Logger LOG = LoggerFactory
- .getLogger(ITCaseSqlResource.class);
-
-
- public void testExists() throws Exception {
-
-
- Properties props = new Properties();
- InputStream propStr = getClass().getResourceAsStream("/svclogic.properties");
- if (propStr == null) {
- fail("src/test/resources/svclogic.properties missing");
- }
-
- try {
- props.load(propStr);
- propStr.close();
- } catch (Exception e) {
- e.printStackTrace();
- fail("Could not initialize properties");
- }
-
-
- // Start MariaDB4j database
- DBConfigurationBuilder config = DBConfigurationBuilder.newBuilder();
- config.setPort(0); // 0 => autom. detect free port
- DB db = DB.newEmbeddedDB(config.build());
- db.start();
-
- // Override jdbc URL and database name
- props.setProperty("org.onap.ccsdk.sli.jdbc.database", "test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.url", config.getURL("test"));
-
- // Add properties to global properties
-
- Enumeration propNames = props.keys();
-
- while (propNames.hasMoreElements()) {
- String propName = (String) propNames.nextElement();
-
- System.setProperty(propName, props.getProperty(propName));
- }
-
- SqlResource sqlResource = new SqlResource(new SqlResourcePropertiesProviderImpl());
-
-
-
- InputStream testStr = getClass().getResourceAsStream("/save.tests");
- BufferedReader testsReader = new BufferedReader(new InputStreamReader(testStr));
- SvcLogicContext ctx = new SvcLogicContext();
-
- try {
- String testExpr = null;
-
- int testNum = 0;
- while ((testExpr = testsReader.readLine()) != null) {
- testExpr = testExpr.trim();
-
- if (testExpr.startsWith("#")) {
- testExpr = testExpr.substring(1).trim();
- String[] nameValue = testExpr.split("=");
- String name = nameValue[0].trim();
- String value = nameValue[1].trim();
-
- LOG.info("Setting context attribute " + name + " = "
- + value);
- ctx.setAttribute(name, value);
-
- } else {
-
- testNum++;
- String sqlStmt = testExpr;
- QueryStatus status = sqlResource.save("SQL", true, false, sqlStmt, null, "savetest"+testNum, ctx);
-
- switch (status) {
- case SUCCESS:
- LOG.info("Found data for query [" + sqlStmt + "]");
- break;
- case NOT_FOUND:
- LOG.info("Did not data for query [" + sqlStmt + "]");
- break;
- default:
- fail("Failure executing query [" + sqlStmt + "]");
-
- }
- }
- }
-
- } catch (Exception e) {
- e.printStackTrace();
- fail("Caught exception running tests");
- }
-
-
- testStr = getClass().getResourceAsStream("/query.tests");
- testsReader = new BufferedReader(new InputStreamReader(testStr));
-
- try {
- String testExpr = null;
-
- int testNum = 0;
- while ((testExpr = testsReader.readLine()) != null) {
- testExpr = testExpr.trim();
- if (testExpr.startsWith("#")) {
- testExpr = testExpr.substring(1).trim();
- String[] nameValue = testExpr.split("=");
- String name = nameValue[0].trim();
- String value = nameValue[1].trim();
-
- LOG.info("Setting context attribute " + name + " = "
- + value);
- ctx.setAttribute(name, value);
-
- } else {
-
- testNum++;
-
- String sqlStmt = testExpr;
- QueryStatus status = sqlResource.query("SQL", false, null,
- sqlStmt, "querytest" + testNum, null, ctx);
-
- switch (status) {
- case SUCCESS:
- LOG.info("Found data for query [" + sqlStmt + "]");
- break;
- case NOT_FOUND:
- LOG.info("Did not data for query [" + sqlStmt + "]");
- break;
- default:
- fail("Failure executing query [" + sqlStmt + "]");
-
- }
- }
- }
-
- } catch (Exception e) {
- e.printStackTrace();
- fail("Caught exception running tests");
- }
-
-
- testStr = getClass().getResourceAsStream("/delete.tests");
- testsReader = new BufferedReader(new InputStreamReader(testStr));
-
- try {
- String testExpr = null;
-
- int testNum = 0;
- while ((testExpr = testsReader.readLine()) != null) {
- testExpr = testExpr.trim();
- if (testExpr.startsWith("#")) {
- testExpr = testExpr.substring(1).trim();
- String[] nameValue = testExpr.split("=");
- String name = nameValue[0].trim();
- String value = nameValue[1].trim();
-
- LOG.info("Setting context attribute " + name + " = "
- + value);
- ctx.setAttribute(name, value);
-
- } else {
-
- testNum++;
-
- String sqlStmt = testExpr;
- QueryStatus status = sqlResource.delete("SQL", sqlStmt, ctx);
-
- switch (status) {
- case SUCCESS:
- LOG.info("Found data for query [" + sqlStmt + "]");
- break;
- case NOT_FOUND:
- LOG.info("Did not data for query [" + sqlStmt + "]");
- break;
- default:
- fail("Failure executing query [" + sqlStmt + "]");
-
- }
- }
- }
-
- } catch (Exception e) {
- e.printStackTrace();
- fail("Caught exception running tests");
- }
-
- for (String attrName : ctx.getAttributeKeySet()) {
- LOG.info("ctx.getAttribute("+attrName+") = "+ctx.getAttribute(attrName));
- }
- }
-
-}
diff --git a/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/SqlResourceProviderTest.java b/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/SqlResourceProviderTest.java
deleted file mode 100755
index b261b9f7d..000000000
--- a/sql-resource/provider/src/test/java/org/onap/ccsdk/sli/adaptors/resource/sql/SqlResourceProviderTest.java
+++ /dev/null
@@ -1,38 +0,0 @@
-package org.onap.ccsdk.sli.adaptors.resource.sql;
-
-import static org.junit.Assert.assertNotNull;
-import java.lang.reflect.Field;
-import java.util.Map;
-import java.util.Properties;
-
-import org.junit.Test;
-
-public class SqlResourceProviderTest {
-
- private static SqlResourcePropertiesProvider provider;
- private static final String SDNC_CONFIG_DIR = "SDNC_CONFIG_DIR";
-
- @Test
- public void testSqlResourceProvider() {
- try{
- Map<String, String> env = System.getenv();
- Class<?> cl = env.getClass();
- Field field = cl.getDeclaredField("m");
- field.setAccessible(true);
- Map<String, String> writableEnv = (Map<String, String>) field.get(env);
- writableEnv.put(SDNC_CONFIG_DIR, "./src/test/resources");
- } catch (Exception e) {
- throw new IllegalStateException("Failed to set environment variable", e);
- }
-
- provider = new SqlResourcePropertiesProviderImpl();
- assertNotNull(provider);
- }
-
- @Test
- public void testGetProperties() {
- Properties properties = provider.getProperties();
- assertNotNull(properties);
- }
-
-}
diff --git a/sql-resource/provider/src/test/resources/delete.tests b/sql-resource/provider/src/test/resources/delete.tests
deleted file mode 100755
index a60a3bc73..000000000
--- a/sql-resource/provider/src/test/resources/delete.tests
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE SQLRESOURCE_ORDER;
-DROP TABLE SQLRESOURCE_ORDER_ITEM;
diff --git a/sql-resource/provider/src/test/resources/query.tests b/sql-resource/provider/src/test/resources/query.tests
deleted file mode 100755
index ec05c22e3..000000000
--- a/sql-resource/provider/src/test/resources/query.tests
+++ /dev/null
@@ -1,5 +0,0 @@
-# max-price = 100
-SELECT * FROM SQLRESOURCE_ORDER where placed_on < now();
-SELECT SQLRESOURCE_ORDER.order_number, clli, service, price FROM SQLRESOURCE_ORDER, SQLRESOURCE_ORDER_ITEM where SQLRESOURCE_ORDER.order_number = SQLRESOURCE_ORDER_ITEM.order_number and price > $max-price ;
-SELECT SQLRESOURCE_ORDER.order_number, clli, service, price FROM SQLRESOURCE_ORDER, SQLRESOURCE_ORDER_ITEM where SQLRESOURCE_ORDER.order_number = SQLRESOURCE_ORDER_ITEM.order_number and price < $max-price ;
-SELECT SQLRESOURCE_ORDER.order_number AS ordernum, clli, service, price FROM SQLRESOURCE_ORDER, SQLRESOURCE_ORDER_ITEM where SQLRESOURCE_ORDER.order_number = SQLRESOURCE_ORDER_ITEM.order_number and price < $max-price ;
diff --git a/sql-resource/provider/src/test/resources/save.tests b/sql-resource/provider/src/test/resources/save.tests
deleted file mode 100755
index e2c42217d..000000000
--- a/sql-resource/provider/src/test/resources/save.tests
+++ /dev/null
@@ -1,13 +0,0 @@
-# order-number = 1234
-# zero = 0
-# item[0].clli = MTJNJA14
-# item[0].service = NoD
-# item[0].price = 1000000
-# item[1].clli = MTJNJA14
-# item[1].service = Pizza
-# item[1].price = 10
-CREATE TABLE IF NOT EXISTS SQLRESOURCE_ORDER (order_number VARCHAR(40), placed_on TIMESTAMP);
-CREATE TABLE IF NOT EXISTS SQLRESOURCE_ORDER_ITEM (order_number VARCHAR(40), clli VARCHAR(40), service VARCHAR(40), price INTEGER(4));
-INSERT INTO SQLRESOURCE_ORDER VALUES ( $order-number , now());
-INSERT INTO SQLRESOURCE_ORDER_ITEM VALUES( $order-number , $item[$zero].clli , $item[0].service , $item[0].price );
-INSERT INTO SQLRESOURCE_ORDER_ITEM VALUES( $order-number , $item[1].clli , $item[1].service , $item[1].price );
diff --git a/sql-resource/provider/src/test/resources/simplelogger.properties b/sql-resource/provider/src/test/resources/simplelogger.properties
deleted file mode 100644
index 61d82660f..000000000
--- a/sql-resource/provider/src/test/resources/simplelogger.properties
+++ /dev/null
@@ -1,22 +0,0 @@
-###
-# ============LICENSE_START=======================================================
-# openECOMP : SDN-C
-# ================================================================================
-# Copyright (C) 2017 AT&T Intellectual Property. 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.
-# ============LICENSE_END=========================================================
-###
-
-org.slf4j.simpleLogger.defaultLogLevel=debug
diff --git a/sql-resource/provider/src/test/resources/sql-resource.properties b/sql-resource/provider/src/test/resources/sql-resource.properties
deleted file mode 100755
index ac32f7734..000000000
--- a/sql-resource/provider/src/test/resources/sql-resource.properties
+++ /dev/null
@@ -1,23 +0,0 @@
-###
-# ============LICENSE_START=======================================================
-# openECOMP : SDN-C
-# ================================================================================
-# Copyright (C) 2017 AT&T Intellectual Property. 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.
-# ============LICENSE_END=========================================================
-###
-
-org.openecomp.sdnc.resource.sql.cryptkey=QtfJMKggVk
-
diff --git a/sql-resource/provider/src/test/resources/svclogic.properties b/sql-resource/provider/src/test/resources/svclogic.properties
deleted file mode 100644
index 6504e1aec..000000000
--- a/sql-resource/provider/src/test/resources/svclogic.properties
+++ /dev/null
@@ -1,35 +0,0 @@
-###
-# ============LICENSE_START=======================================================
-# openECOMP : SDN-C
-# ================================================================================
-# Copyright (C) 2017 AT&T Intellectual Property. 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.
-# ============LICENSE_END=========================================================
-###
-org.onap.ccsdk.sli.dbtype=jdbc
-
-org.onap.ccsdk.sli.jdbc.hosts=sdnctldb01
-org.onap.ccsdk.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl
-org.onap.ccsdk.sli.jdbc.driver=org.mariadb.jdbc.Driver
-org.onap.ccsdk.sli.jdbc.database=sdnctl
-org.onap.ccsdk.sli.jdbc.user=sdnctl
-org.onap.ccsdk.sli.jdbc.password=gamma
-org.onap.ccsdk.sli.jdbc.connection.name=sdnctldb01
-org.onap.ccsdk.sli.jdbc.connection.timeout=50
-org.onap.ccsdk.sli.jdbc.request.timeout=100
-org.onap.ccsdk.sli.jdbc.limit.init=10
-org.onap.ccsdk.sli.jdbc.limit.min=10
-org.onap.ccsdk.sli.jdbc.limit.max=20
-org.onap.dblib.connection.recovery=false