summaryrefslogtreecommitdiffstats
path: root/dblib/provider/src/test
diff options
context:
space:
mode:
authorJessica Wagantall <jwagantall@linuxfoundation.org>2020-12-01 11:48:20 -0800
committerJessica Wagantall <jwagantall@linuxfoundation.org>2020-12-01 11:48:20 -0800
commit32fb53c13342d5ad353c839b7ffd0ca85d14bd48 (patch)
treef1b92068cf7b79d29e96243899e12495abb4795a /dblib/provider/src/test
parent53eacd8519a535f96d8b4231e48925324f1086dd (diff)
Migrate sli-core files
Migrate sli-core repo files into new directory "core". Signed-off-by: Jessica Wagantall <jwagantall@linuxfoundation.org>
Diffstat (limited to 'dblib/provider/src/test')
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/CachedDataSourceTest.java121
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DBConfigExceptionTest.java19
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DblibConfigurationExceptionTest.java24
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/NoAvailableConnectionsExceptionTest.java16
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TerminatingCachedDataSourceTest.java94
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager.java70
-rw-r--r--dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager2.java95
-rw-r--r--dblib/provider/src/test/resources/dblib.properties38
8 files changed, 0 insertions, 477 deletions
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/CachedDataSourceTest.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/CachedDataSourceTest.java
deleted file mode 100644
index 45268107e..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/CachedDataSourceTest.java
+++ /dev/null
@@ -1,121 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.assertEquals;
-import static org.junit.Assert.assertFalse;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-import static org.junit.Assert.assertTrue;
-
-import java.sql.SQLException;
-import java.sql.SQLFeatureNotSupportedException;
-import java.util.Properties;
-
-import org.junit.BeforeClass;
-import org.junit.Test;
-import org.onap.ccsdk.sli.core.dblib.config.BaseDBConfiguration;
-import org.onap.ccsdk.sli.core.dblib.config.JDBCConfiguration;
-import org.onap.ccsdk.sli.core.dblib.jdbc.JdbcDBCachedDataSource;
-import org.slf4j.LoggerFactory;
-
-public class CachedDataSourceTest {
-
- private static final Properties props = new Properties();
- private static BaseDBConfiguration config;
- private static CachedDataSource ds;
-
- @BeforeClass
- public static void setUpBeforeClass() throws Exception {
- props.setProperty("org.onap.ccsdk.sli.dbtype", "jdbc");
- props.setProperty("org.onap.ccsdk.sli.jdbc.hosts", "localhost");
- props.setProperty("org.onap.ccsdk.sli.jdbc.url", "jdbc:mysql://dbhost:3306/test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.driver", "org.mariadb.jdbc.Driver");
- props.setProperty("org.onap.ccsdk.sli.jdbc.database", "test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.user", "dbuser");
- props.setProperty("org.onap.ccsdk.sli.jdbc.password", "passw0rd");
- props.setProperty("org.onap.ccsdk.sli.jdbc.connection.name", "testdb01");
- props.setProperty("org.onap.ccsdk.sli.jdbc.connection.timeout", "50");
- props.setProperty("org.onap.ccsdk.sli.jdbc.request.timeout", "100");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.init", "10");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.min", "10");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.max", "20");
- props.setProperty("org.onap.dblib.connection.recovery", "false");
-
- config = new JDBCConfiguration(props);
- ds = new JdbcDBCachedDataSource(config);
- }
-
- @Test
- public void testCachedDataSource() {
- assertNotNull(ds);
- }
-
- @Test
- public void testConfigure() {
-
- assertNotNull(ds.configure(config));
- }
-
- @Test
- public void testSetInitialDelay() {
- ds.setInitialDelay(1000L);
- assertTrue(ds.getInitialDelay() == 1000L);
- }
-
- @Test
- public void testSetInterval() {
- ds.setInterval(1000L);
- assertTrue(ds.getInterval() == 1000L);
- }
-
- @Test
- public void testSetExpectedCompletionTime() {
- ds.setExpectedCompletionTime(100L);
- assertTrue(ds.getExpectedCompletionTime() == 100L);
- }
-
- @Test
- public void testSetUnprocessedFailoverThreshold() {
- ds.setUnprocessedFailoverThreshold(100L);
- assertTrue(ds.getUnprocessedFailoverThreshold() == 100L);
- }
-
- @Test
- public void testGetParentLogger() {
- try {
- assertNull(ds.getParentLogger());
- } catch (SQLFeatureNotSupportedException e) {
- LoggerFactory.getLogger(CachedDataSourceTest.class).warn("Test Failure", e);
- }
- }
-
- @Test
- public void testGettersForJdbcDBCachedDataSource() {
-
- assertEquals("jdbc:mysql://dbhost:3306/test", ((JdbcDBCachedDataSource) ds).getDbUrl());
- assertEquals("dbuser", ((JdbcDBCachedDataSource) ds).getDbUserId());
- assertEquals("passw0rd", ((JdbcDBCachedDataSource) ds).getDbPasswd());
- assertEquals("testdb01", ((JdbcDBCachedDataSource) ds).toString());
- }
-
- @Test
- public void testIsInitialised() {
- assertTrue(ds.isInitialized());
- }
-
- @Test
- public void testIsWrapperFor() throws SQLException {
- assertFalse(ds.isWrapperFor(CachedDataSource.class));
- }
-
- @Test
- public void testGetSetNextErrorReportTime() throws SQLException {
- ds.setNextErrorReportTime(1L);
- assertEquals(1L, ds.getNextErrorReportTime());
- }
-
- @Test
- public void testGetSetGlobalHostName() throws SQLException {
- ds.setGlobalHostName("hostName");
- assertEquals("hostName", ds.getGlobalHostName());
- }
-} \ No newline at end of file
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DBConfigExceptionTest.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DBConfigExceptionTest.java
deleted file mode 100644
index 2a5b65c7a..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DBConfigExceptionTest.java
+++ /dev/null
@@ -1,19 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.assertNotNull;
-
-import org.junit.Test;
-
-public class DBConfigExceptionTest {
-
- @Test
- public void testDBConfigExceptionException() {
- assertNotNull(new DBConfigException("JUnit Test"));
- }
-
- @Test
- public void testDBConfigExceptionString() {
- assertNotNull(new DBConfigException(new Exception("JUnit Test")));
- }
-
-}
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DblibConfigurationExceptionTest.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DblibConfigurationExceptionTest.java
deleted file mode 100644
index 7becd1ae4..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/DblibConfigurationExceptionTest.java
+++ /dev/null
@@ -1,24 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.*;
-
-import org.junit.Test;
-
-public class DblibConfigurationExceptionTest {
-
- @Test
- public void testDblibConfigurationException() {
- assertNotNull(new DblibConfigurationException());
- }
-
- @Test
- public void testDblibConfigurationExceptionString() {
- assertNotNull(new DblibConfigurationException("JUnit Test"));
- }
-
- @Test
- public void testDblibConfigurationExceptionStringThrowable() {
- assertNotNull(new DblibConfigurationException("JUnit Test", new Exception("JUnit Test")));
- }
-
-}
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/NoAvailableConnectionsExceptionTest.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/NoAvailableConnectionsExceptionTest.java
deleted file mode 100644
index 2fdacb922..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/NoAvailableConnectionsExceptionTest.java
+++ /dev/null
@@ -1,16 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.*;
-
-import org.junit.AfterClass;
-import org.junit.BeforeClass;
-import org.junit.Test;
-
-public class NoAvailableConnectionsExceptionTest {
-
- @Test
- public void testNoAvailableConnectionsException() {
- assertNotNull(new NoAvailableConnectionsException(new Exception("test")));
- }
-
-}
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TerminatingCachedDataSourceTest.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TerminatingCachedDataSourceTest.java
deleted file mode 100644
index 160a3d4ae..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TerminatingCachedDataSourceTest.java
+++ /dev/null
@@ -1,94 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.*;
-
-import java.sql.SQLFeatureNotSupportedException;
-import java.util.Properties;
-
-import org.junit.Test;
-import org.onap.ccsdk.sli.core.dblib.config.BaseDBConfiguration;
-import org.onap.ccsdk.sli.core.dblib.config.JDBCConfiguration;
-import org.slf4j.LoggerFactory;
-
-public class TerminatingCachedDataSourceTest {
-
- @Test
- public void testTerminatingCachedDataSource() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- assertNotNull(ds);
- }
-
- @Test
- public void testConfigure() {
- Properties props = new Properties();
- props.setProperty("org.onap.ccsdk.sli.dbtype", "jdbc");
- props.setProperty("org.onap.ccsdk.sli.jdbc.hosts", "localhost");
- props.setProperty("org.onap.ccsdk.sli.jdbc.url", "jdbc:mysql://dbhost:3306/test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.driver", "org.mariadb.jdbc.Driver");
- props.setProperty("org.onap.ccsdk.sli.jdbc.database", "test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.user", "dbuser");
- props.setProperty("org.onap.ccsdk.sli.jdbc.password", "passw0rd");
- props.setProperty("org.onap.ccsdk.sli.jdbc.connection.name", "testdb01");
- props.setProperty("org.onap.ccsdk.sli.jdbc.connection.timeout", "50");
- props.setProperty("org.onap.ccsdk.sli.jdbc.request.timeout", "100");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.init", "10");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.min", "10");
- props.setProperty("org.onap.ccsdk.sli.jdbc.limit.max", "20");
- props.setProperty("org.onap.dblib.connection.recovery", "false");
- BaseDBConfiguration config = new JDBCConfiguration(props);
-
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- assertNull(ds.configure(config));
- }
-
- @Test
- public void testSetInitialDelay() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- ds.setInitialDelay(1000L);
- assertTrue(ds.getInitialDelay() == 1000L);
- }
-
- @Test
- public void testSetInterval() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- ds.setInterval(1000L);
- assertTrue(ds.getInterval() == 1000L);
- }
-
- @Test
- public void testSetExpectedCompletionTime() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- ds.setExpectedCompletionTime(100L);
- assertTrue(ds.getExpectedCompletionTime() == 100L);
- }
-
- @Test
- public void testSetUnprocessedFailoverThreshold() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- ds.setUnprocessedFailoverThreshold(100L);
- assertTrue(ds.getUnprocessedFailoverThreshold() == 100L);
- }
-
- @Test
- public void testGetParentLogger() {
- Properties props = new Properties();
- BaseDBConfiguration config = new JDBCConfiguration(props);
- CachedDataSource ds = new TerminatingCachedDataSource(config);
- ds.setInterval(100L);
- try {
- assertNull(ds.getParentLogger());
- } catch (SQLFeatureNotSupportedException e) {
- LoggerFactory.getLogger(TerminatingCachedDataSourceTest.class).warn("Test Failure", e);
- }
- }
-} \ No newline at end of file
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager.java
deleted file mode 100644
index 8d7d34324..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager.java
+++ /dev/null
@@ -1,70 +0,0 @@
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.*;
-
-import java.io.InputStream;
-import java.net.URL;
-import java.sql.SQLException;
-import java.util.Properties;
-
-import org.junit.Before;
-import org.junit.Test;
-
-import ch.vorburger.mariadb4j.DB;
-import ch.vorburger.mariadb4j.DBConfigurationBuilder;
-
-public class TestDBResourceManager {
-
- DbLibService dblibSvc;
- DBResourceManager dbm;
-
- @Before
- public void setUp() throws Exception {
- URL propUrl = getClass().getResource("/dblib.properties");
-
- InputStream propStr = getClass().getResourceAsStream("/dblib.properties");
-
- Properties props = new Properties();
-
- props.load(propStr);
-
- // 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"));
-
- dblibSvc = new DBResourceManager(props);
- dbm = new DBResourceManager(props);
- dblibSvc.writeData("CREATE TABLE DBLIB_TEST (name varchar(20));", null, null);
- dblibSvc.getData("SELECT * FROM DBLIB_TEST", null, null);
-
- }
-
- @Test
- public void testForceRecovery() {
- dbm.testForceRecovery();
- }
-
- @Test
- public void testGetConnection() throws SQLException {
- assertNotNull(dbm.getConnection());
- assertNotNull(dbm.getConnection("testUser", "testPaswd"));
- }
-
- @Test
- public void testCleanup() {
- dbm.cleanUp();
-
- }
-
- @Test
- public void testGetLogWriter() throws SQLException {
- assertNull(dbm.getLogWriter());
- }
-
-}
diff --git a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager2.java b/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager2.java
deleted file mode 100644
index a3cb8d914..000000000
--- a/dblib/provider/src/test/java/org/onap/ccsdk/sli/core/dblib/TestDBResourceManager2.java
+++ /dev/null
@@ -1,95 +0,0 @@
-/*-
- 2 * ============LICENSE_START=======================================================
- 3 * ONAP CCSDK
- 4 * ================================================================================
- 5 * Copyright (C) 2019 AT&T Intellectual Property. All rights
- 6 * reserved.
- 7 * ================================================================================
- 8 * Licensed under the Apache License, Version 2.0 (the "License");
- 9 * you may not use this file except in compliance with the License.
- 10 * You may obtain a copy of the License at
- 11 *
- 12 * http://www.apache.org/licenses/LICENSE-2.0
- 13 *
- 14 * Unless required by applicable law or agreed to in writing, software
- 15 * distributed under the License is distributed on an "AS IS" BASIS,
- 16 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- 17 * See the License for the specific language governing permissions and
- 18 * limitations under the License.
- 19 * ============LICENSE_END============================================
- 20 * ===================================================================
- 21 *
- 22 */
-package org.onap.ccsdk.sli.core.dblib;
-
-import static org.junit.Assert.*;
-
-import java.io.InputStream;
-import java.net.URL;
-import java.sql.SQLException;
-import java.util.Properties;
-
-import org.junit.Before;
-import org.junit.Test;
-
-import ch.vorburger.mariadb4j.DB;
-import ch.vorburger.mariadb4j.DBConfigurationBuilder;
-
-public class TestDBResourceManager2 {
-
- DbLibService dblibSvc;
- DBResourceManager dbm;
-
- @Before
- public void setUp() throws Exception {
- URL propUrl = getClass().getResource("/dblib.properties");
-
- InputStream propStr = getClass().getResourceAsStream("/dblib.properties");
-
- Properties props = new Properties();
-
- props.load(propStr);
-
- // 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, database name, and recovery
- props.setProperty("org.onap.ccsdk.sli.jdbc.database", "test");
- props.setProperty("org.onap.ccsdk.sli.jdbc.url", config.getURL("test"));
- props.setProperty("org.onap.dblib.connection.recovery", "true");
-
-
- dblibSvc = new DBResourceManager(props);
- dbm = new DBResourceManager(props);
- dblibSvc.writeData("CREATE TABLE DBLIB_TEST2 (name varchar(20));", null, null);
- dblibSvc.getData("SELECT * FROM DBLIB_TEST2", null, null);
-
-
- }
-
- @Test
- public void testForceRecovery() {
- dbm.testForceRecovery();
- }
-
- @Test
- public void testGetConnection() throws SQLException {
- assertNotNull(dbm.getConnection());
- assertNotNull(dbm.getConnection("testUser", "testPaswd"));
- }
-
- @Test
- public void testCleanup() {
- dbm.cleanUp();
-
- }
-
- @Test
- public void testGetLogWriter() throws SQLException {
- assertNull(dbm.getLogWriter());
- }
-
-}
diff --git a/dblib/provider/src/test/resources/dblib.properties b/dblib/provider/src/test/resources/dblib.properties
deleted file mode 100644
index 9506ac8d1..000000000
--- a/dblib/provider/src/test/resources/dblib.properties
+++ /dev/null
@@ -1,38 +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=========================================================
-###
-
-# dblib.properrties
-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
-