1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
/*-
* ============LICENSE_START=======================================================
* ONAP : APPC
* ================================================================================
* Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
* ================================================================================
* Copyright (C) 2017 Amdocs
* ================================================================================
* Modifications (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.dbcp;
import org.apache.commons.dbcp2.BasicDataSource;
import org.junit.After;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.junit.rules.ExpectedException;
import org.mockito.Mockito;
import org.onap.appc.dao.util.exception.DBConnectionPoolException;
import org.powermock.reflect.Whitebox;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map;
public class DBConnectionPoolTest {
private final String connectURI = "jdbc:h2:mem:~/test;MODE=MYSQL;DB_CLOSE_DELAY=-1";
private final String username = "sa";
private final String password = "sa";
private final String driverClass = "org.h2.Driver";
private DBConnectionPool dbcp;
private DBConnectionPool dbcp2;
private Connection connection;
@Rule
public ExpectedException expectedEx = ExpectedException.none();
@Before
public void setUp() throws Exception {
dbcp = new DBConnectionPool(connectURI, username, password, driverClass);
dbcp2 = new DBConnectionPool(connectURI, username, password, driverClass);
}
@Test
public void testGetConnection() {
try {
connection = dbcp.getConnection();
} catch (DBConnectionPoolException e) {
Assert.fail(e.getMessage());
}
Assert.assertNotNull(connection);
}
@Test
public void testGetConnectionSQLExceptionFlow() throws SQLException {
DBConnectionPool dbcpSpy = Mockito.spy(new DBConnectionPool(connectURI, username, password, driverClass));
BasicDataSource mockDataSource = Mockito.mock(BasicDataSource.class);
Mockito.when(mockDataSource.getConnection()).thenThrow(new SQLException());
Whitebox.setInternalState(dbcpSpy, "dataSource", mockDataSource);
expectedEx.expect(SQLException.class);
connection = dbcpSpy.getConnection();
}
@Test
public void testGetConnectionDBConnectionPoolExceptionFlow() throws SQLException {
DBConnectionPool dbcpSpy = Mockito.spy(new DBConnectionPool(connectURI, username, password, driverClass));
BasicDataSource mockDataSource = Mockito.mock(BasicDataSource.class);
Mockito.when(mockDataSource.getConnection()).thenReturn(null);
Whitebox.setInternalState(dbcpSpy, "dataSource", mockDataSource);
expectedEx.expect(DBConnectionPoolException.class);
connection = dbcpSpy.getConnection();
}
@Test
public void testGetDataSourceStatus() {
Map<String, Integer> dataSourceStatus = dbcp.getDataSourceStatus();
Assert.assertNotNull(dataSourceStatus);
}
@Test(expected = DBConnectionPoolException.class)
public void testShutdown() throws DBConnectionPoolException {
dbcp2.shutdown();
connection = dbcp2.getConnection();
Assert.assertNull(connection);
}
@Test
public void testShutdownException() throws SQLException {
DBConnectionPool dbcpSpy = Mockito.spy(new DBConnectionPool(connectURI, username, password, driverClass,
0, 0, 0, 0, 0));
BasicDataSource mockDataSource = Mockito.mock(BasicDataSource.class);
Mockito.doThrow(new SQLException()).when(mockDataSource).close();
Whitebox.setInternalState(dbcpSpy, "dataSource", mockDataSource);
dbcpSpy.shutdown();
Mockito.verify(mockDataSource).close();
}
@After
public void clean() {
if (dbcp != null) {
dbcp.shutdown();
}
if (dbcp2 != null) {
dbcp2.shutdown();
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
|
