forked from testcontainers/testcontainers-java
-
Notifications
You must be signed in to change notification settings - Fork 0
/
SimpleMSSQLServerTest.java
78 lines (66 loc) · 3.04 KB
/
SimpleMSSQLServerTest.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
78
package org.testcontainers.junit.mssqlserver;
import org.junit.Test;
import org.testcontainers.MSSQLServerTestImages;
import org.testcontainers.containers.MSSQLServerContainer;
import org.testcontainers.db.AbstractContainerDatabaseTest;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;
import static org.assertj.core.api.Assertions.assertThat;
public class SimpleMSSQLServerTest extends AbstractContainerDatabaseTest {
@Test
public void testSimple() throws SQLException {
try (
MSSQLServerContainer<?> mssqlServer = new MSSQLServerContainer<>(MSSQLServerTestImages.MSSQL_SERVER_IMAGE)
) {
mssqlServer.start();
ResultSet resultSet = performQuery(mssqlServer, "SELECT 1");
int resultSetInt = resultSet.getInt(1);
assertThat(resultSetInt).as("A basic SELECT query succeeds").isEqualTo(1);
}
}
@Test
public void testWithAdditionalUrlParamInJdbcUrl() {
try (
MSSQLServerContainer<?> mssqlServer = new MSSQLServerContainer<>(MSSQLServerTestImages.MSSQL_SERVER_IMAGE)
.withUrlParam("integratedSecurity", "false")
.withUrlParam("applicationName", "MyApp")
) {
mssqlServer.start();
String jdbcUrl = mssqlServer.getJdbcUrl();
assertThat(jdbcUrl).contains(";integratedSecurity=false;applicationName=MyApp");
}
}
@Test
public void testSetupDatabase() throws SQLException {
try (
MSSQLServerContainer<?> mssqlServer = new MSSQLServerContainer<>(MSSQLServerTestImages.MSSQL_SERVER_IMAGE)
) {
mssqlServer.start();
DataSource ds = getDataSource(mssqlServer);
Statement statement = ds.getConnection().createStatement();
statement.executeUpdate("CREATE DATABASE [test];");
statement = ds.getConnection().createStatement();
statement.executeUpdate("CREATE TABLE [test].[dbo].[Foo](ID INT PRIMARY KEY);");
statement = ds.getConnection().createStatement();
statement.executeUpdate("INSERT INTO [test].[dbo].[Foo] (ID) VALUES (3);");
statement = ds.getConnection().createStatement();
statement.execute("SELECT * FROM [test].[dbo].[Foo];");
ResultSet resultSet = statement.getResultSet();
resultSet.next();
int resultSetInt = resultSet.getInt("ID");
assertThat(resultSetInt).as("A basic SELECT query succeeds").isEqualTo(3);
}
}
@Test
public void testExposedAndLivenessCheckPorts() throws Exception {
try (
MSSQLServerContainer<?> mssqlServer = new MSSQLServerContainer<>(MSSQLServerTestImages.MSSQL_SERVER_IMAGE)
) {
mssqlServer.start();
assertThat(mssqlServer.getExposedPorts()).containsExactly(MSSQLServerContainer.MS_SQL_SERVER_PORT);
assertThat(mssqlServer.getLivenessCheckPortNumbers()).containsExactly(mssqlServer.getMappedPort(1433));
}
}
}