forked from testcontainers/testcontainers-java
-
Notifications
You must be signed in to change notification settings - Fork 0
/
SimpleDb2Test.java
46 lines (36 loc) · 1.55 KB
/
SimpleDb2Test.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
package org.testcontainers.junit.db2;
import org.junit.Test;
import org.testcontainers.Db2TestImages;
import org.testcontainers.containers.Db2Container;
import org.testcontainers.db.AbstractContainerDatabaseTest;
import java.sql.ResultSet;
import java.sql.SQLException;
import static org.assertj.core.api.Assertions.assertThat;
public class SimpleDb2Test extends AbstractContainerDatabaseTest {
@Test
public void testSimple() throws SQLException {
try (Db2Container db2 = new Db2Container(Db2TestImages.DB2_IMAGE).acceptLicense()) {
db2.start();
ResultSet resultSet = performQuery(db2, "SELECT 1 FROM SYSIBM.SYSDUMMY1");
int resultSetInt = resultSet.getInt(1);
assertThat(resultSetInt).as("A basic SELECT query succeeds").isEqualTo(1);
assertHasCorrectExposedAndLivenessCheckPorts(db2);
}
}
@Test
public void testWithAdditionalUrlParamInJdbcUrl() {
try (
Db2Container db2 = new Db2Container(Db2TestImages.DB2_IMAGE)
.withUrlParam("sslConnection", "false")
.acceptLicense()
) {
db2.start();
String jdbcUrl = db2.getJdbcUrl();
assertThat(jdbcUrl).contains(":sslConnection=false;");
}
}
private void assertHasCorrectExposedAndLivenessCheckPorts(Db2Container db2) {
assertThat(db2.getExposedPorts()).containsExactly(Db2Container.DB2_PORT);
assertThat(db2.getLivenessCheckPortNumbers()).containsExactly(db2.getMappedPort(Db2Container.DB2_PORT));
}
}