-
Notifications
You must be signed in to change notification settings - Fork 1.8k
/
DerbyDatabaseTest.java
77 lines (61 loc) · 3.02 KB
/
DerbyDatabaseTest.java
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
package liquibase.database.core;
import static org.mockito.ArgumentMatchers.anyString;
import static org.mockito.Mockito.RETURNS_SMART_NULLS;
import static org.mockito.Mockito.doNothing;
import static org.mockito.Mockito.mock;
import static org.mockito.Mockito.never;
import static org.mockito.Mockito.spy;
import static org.mockito.Mockito.verify;
import static org.mockito.Mockito.when;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
import junit.framework.TestCase;
import liquibase.database.Database;
import liquibase.database.jvm.JdbcConnection;
import liquibase.exception.DatabaseException;
public class DerbyDatabaseTest extends TestCase {
public void testGetDefaultDriver() throws DatabaseException {
try (Database database = new DerbyDatabase()) {
assertEquals("org.apache.derby.jdbc.EmbeddedDriver", database.getDefaultDriver("java:derby:liquibase;create=true"));
assertNull(database.getDefaultDriver("jdbc:oracle://localhost;databaseName=liquibase"));
} catch (final DatabaseException e) {
throw e;
}
}
public void testGetDateLiteral() {
assertEquals("TIMESTAMP('2008-01-25 13:57:41')", new DerbyDatabase().getDateLiteral("2008-01-25 13:57:41"));
assertEquals("TIMESTAMP('2008-01-25 13:57:41.300000')", new DerbyDatabase().getDateLiteral("2008-01-25 13:57:41.3"));
assertEquals("TIMESTAMP('2008-01-25 13:57:41.340000')", new DerbyDatabase().getDateLiteral("2008-01-25 13:57:41.34"));
assertEquals("TIMESTAMP('2008-01-25 13:57:41.347000')", new DerbyDatabase().getDateLiteral("2008-01-25 13:57:41.347"));
}
public void testCloseShutsEmbeddedDerbyDown() throws Exception {
Connection con = mockConnection();
DerbyDatabase database = spyDatabase(con);
database.close();
verify(database).shutdownDerby(anyString(), anyString());
verify(con).close();
}
public void testCloseDoesNotShutEmbeddedDerbyDown() throws Exception {
Connection con = mockConnection();
DerbyDatabase database = spyDatabase(con);
database.setShutdownEmbeddedDerby(false);
database.close();
verify(database, never()).shutdownDerby(anyString(), anyString());
verify(con).close();
}
private static DerbyDatabase spyDatabase(Connection con) throws DatabaseException {
DerbyDatabase database = spy(new DerbyDatabase());
doNothing().when(database).shutdownDerby(anyString(), anyString());
database.setConnection(new JdbcConnection(con));
return database;
}
private static Connection mockConnection() throws SQLException {
Connection con = mock(Connection.class);
DatabaseMetaData metaData = mock(DatabaseMetaData.class, RETURNS_SMART_NULLS);
when(metaData.getURL()).thenReturn("jdbc:derby:memory:foo");
when(metaData.getDriverName()).thenReturn("org.apache.derby.jdbc.EmbeddedDriver");
when(con.getMetaData()).thenReturn(metaData);
return con;
}
}