-
-
Notifications
You must be signed in to change notification settings - Fork 1.6k
/
SimpleMariaDBTest.java
71 lines (51 loc) · 2.59 KB
/
SimpleMariaDBTest.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
package org.testcontainers.junit.mariadb;
import org.apache.commons.lang.SystemUtils;
import org.junit.Test;
import org.testcontainers.containers.MariaDBContainer;
import org.testcontainers.db.AbstractContainerDatabaseTest;
import java.sql.ResultSet;
import java.sql.SQLException;
import static org.junit.Assume.assumeFalse;
import static org.rnorth.visibleassertions.VisibleAssertions.assertEquals;
import static org.rnorth.visibleassertions.VisibleAssertions.assertTrue;
public class SimpleMariaDBTest extends AbstractContainerDatabaseTest {
@Test
public void testSimple() throws SQLException {
try (MariaDBContainer<?> mariadb = new MariaDBContainer<>()) {
mariadb.start();
ResultSet resultSet = performQuery(mariadb, "SELECT 1");
int resultSetInt = resultSet.getInt(1);
assertEquals("A basic SELECT query succeeds", 1, resultSetInt);
}
}
@Test
public void testSpecificVersion() throws SQLException {
try (MariaDBContainer<?> mariadbOldVersion = new MariaDBContainer<>("mariadb:5.5.51")) {
mariadbOldVersion.start();
ResultSet resultSet = performQuery(mariadbOldVersion, "SELECT VERSION()");
String resultSetString = resultSet.getString(1);
assertTrue("The database version can be set using a container rule parameter", resultSetString.startsWith("5.5.51"));
}
}
@Test
public void testMariaDBWithCustomIniFile() throws SQLException {
assumeFalse(SystemUtils.IS_OS_WINDOWS);
try (MariaDBContainer<?> mariadbCustomConfig = new MariaDBContainer<>("mariadb:10.1.16")
.withConfigurationOverride("somepath/mariadb_conf_override")) {
mariadbCustomConfig.start();
ResultSet resultSet = performQuery(mariadbCustomConfig, "SELECT @@GLOBAL.innodb_file_format");
String result = resultSet.getString(1);
assertEquals("The InnoDB file format has been set by the ini file content", "Barracuda", result);
}
}
@Test
public void testMariaDBWithCommandOverride() throws SQLException {
try (MariaDBContainer<?> mariadbCustomConfig = new MariaDBContainer<>("mariadb:10.1.16")
.withCommand("mysqld --auto_increment_increment=10")) {
mariadbCustomConfig.start();
ResultSet resultSet = performQuery(mariadbCustomConfig, "show variables like 'auto_increment_increment'");
String result = resultSet.getString("Value");
assertEquals("Auto increment increment should be overriden by command line", "10", result);
}
}
}