From e0c883ee7726aff7d414a2cb7f5145c9444c3a2d Mon Sep 17 00:00:00 2001
From: Lathishbabu Ganesan <lathishbabu.ganesan@ericsson.com>
Date: Thu, 28 Feb 2019 11:48:43 -0500
Subject: [PATCH] Added test case for Connection Factory

Increased the code coverage from 0% to 100%

Issue-ID: APPC-1515
Change-Id: I186f57ce78127c64cc120bcdaa61b418e67fb0de
Signed-off-by: Lathishbabu Ganesan <lathishbabu.ganesan@ericsson.com>
---
 .../dao/util/TestAppcJdbcConnectionFactory.java    | 81 ++++++++++++++++++++++
 1 file changed, 81 insertions(+)
 create mode 100644 appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/test/java/org/onap/appc/dao/util/TestAppcJdbcConnectionFactory.java

diff --git a/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/test/java/org/onap/appc/dao/util/TestAppcJdbcConnectionFactory.java b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/test/java/org/onap/appc/dao/util/TestAppcJdbcConnectionFactory.java
new file mode 100644
index 000000000..30cbf3de6
--- /dev/null
+++ b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/test/java/org/onap/appc/dao/util/TestAppcJdbcConnectionFactory.java
@@ -0,0 +1,81 @@
+/*-
+ * ============LICENSE_START=======================================================
+ * ONAP : APPC
+ * ================================================================================
+ * Copyright (C) 2019 Ericsson
+ * ================================================================================
+ * 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.appc.dao.util;
+
+import static org.junit.Assert.assertNotNull;
+import static org.mockito.Mockito.doThrow;
+import static org.mockito.Mockito.times;
+import static org.mockito.Mockito.verify;
+import java.sql.Connection;
+import java.sql.SQLException;
+import org.junit.Before;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.mockito.Mockito;
+import org.mockito.internal.verification.VerificationModeFactory;
+import org.onap.appc.dao.util.exception.JdbcRuntimeException;
+import org.powermock.api.mockito.PowerMockito;
+import org.powermock.core.classloader.annotations.PrepareForTest;
+import org.powermock.modules.junit4.PowerMockRunner;
+
+@RunWith(PowerMockRunner.class)
+@PrepareForTest(DBUtils.class)
+public class TestAppcJdbcConnectionFactory {
+
+    AppcJdbcConnectionFactory appcJdbcConnectionFactory;
+    private Connection connection;
+
+    @Before
+    public void setUp() throws SQLException {
+        appcJdbcConnectionFactory = new AppcJdbcConnectionFactory();
+        connection = Mockito.mock(Connection.class);
+        PowerMockito.mockStatic(DBUtils.class);
+        PowerMockito.when(DBUtils.getConnection("sdnctl")).thenReturn(connection);
+    }
+
+    @Test
+    public void testOpenDbConnection() throws SQLException {
+        appcJdbcConnectionFactory.setSchema("sdnctl");
+        assertNotNull(appcJdbcConnectionFactory.openDbConnection());
+        PowerMockito.verifyStatic(VerificationModeFactory.times(1));
+        DBUtils.getConnection("sdnctl");
+    }
+
+    @Test(expected = JdbcRuntimeException.class)
+    public void testOpenDbConnectionException() throws SQLException {
+        PowerMockito.when(DBUtils.getConnection("sdnctl")).thenThrow(new SQLException());
+        appcJdbcConnectionFactory.setSchema("sdnctl");
+        assertNotNull(appcJdbcConnectionFactory.openDbConnection());
+    }
+
+    @Test
+    public void testCloseDbConnection() throws SQLException {
+        appcJdbcConnectionFactory.closeDbConnection(connection);
+        verify(connection, times(1)).close();
+    }
+
+    @Test(expected = JdbcRuntimeException.class)
+    public void testCloseDbConnectionException() throws SQLException {
+        doThrow(new SQLException()).when(connection).close();
+        appcJdbcConnectionFactory.closeDbConnection(connection);
+    }
+}
-- 
2.16.6