Discover AI-native insights at Testμ Conference‘25

How to use MariaDBContainer class of org.testcontainers.containers package

Best Testcontainers-java code snippet using org.testcontainers.containers.MariaDBContainer

2import java.util.Collections;3import org.slf4j.Logger;4import org.slf4j.LoggerFactory;5import org.testcontainers.containers.JdbcDatabaseContainer;6import org.testcontainers.containers.MariaDBContainer;7import org.testcontainers.containers.output.Slf4jLogConsumer;8public class MariadbTestContainer implements SqlTestContainer {9    private static final Logger log = LoggerFactory.getLogger(MariadbTestContainer.class);10    private MariaDBContainer<?> mariaDBContainer;11    @Override12    public void destroy() {13        if (null != mariaDBContainer && mariaDBContainer.isRunning()) {14            mariaDBContainer.stop();15        }16    }17    @Override18    public void afterPropertiesSet() {19        if (null == mariaDBContainer) {20            mariaDBContainer =21                new MariaDBContainer<>("mariadb:10.8.3")22                    .withDatabaseName("monoapp")23                    .withTmpFs(Collections.singletonMap("/testtmpfs", "rw"))24                    .withLogConsumer(new Slf4jLogConsumer(log))25                    .withReuse(true)26                    .withConfigurationOverride("testcontainers/mariadb");27        }28        if (!mariaDBContainer.isRunning()) {29            mariaDBContainer.start();30        }31    }32    @Override33    public JdbcDatabaseContainer<?> getTestContainer() {34        return mariaDBContainer;35    }...

MariaDBContainer

Using AI Code Generation

1import static org.junit.Assert.*;2import java.sql.Connection;3import java.sql.ResultSet;4import java.sql.SQLException;5import java.sql.Statement;6import org.junit.Test;7import org.testcontainers.containers.MariaDBContainer;8public class MariaDBContainerTest {9    public void testMariaDBContainer() throws SQLException {10        try (MariaDBContainer mariaDBContainer = new MariaDBContainer()) {11            mariaDBContainer.start();12            String jdbcUrl = mariaDBContainer.getJdbcUrl();13            String username = mariaDBContainer.getUsername();14            String password = mariaDBContainer.getPassword();15            try (Connection connection = mariaDBContainer.createConnection("")) {16                try (Statement statement = connection.createStatement()) {17                    statement.execute("CREATE DATABASE test");18                }19            }20            try (Connection connection = mariaDBContainer.createConnection("test")) {21                try (Statement statement = connection.createStatement()) {22                    boolean result = statement.execute("CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255))");23                    assertTrue(result);24                }25            }26            try (Connection connection = mariaDBContainer.createConnection("test")) {27                try (Statement statement = connection.createStatement()) {28                    boolean result = statement.execute("INSERT INTO Persons VALUES (1, 'Doe', 'John', 'Some Address', 'Some City')");29                    assertTrue(result);30                }31            }32            try (Connection connection = mariaDBContainer.createConnection("test")) {33                try (Statement statement = connection.createStatement()) {34                    try (ResultSet resultSet = statement.executeQuery("SELECT * FROM Persons")) {35                        assertTrue(resultSet.next());36                        assertEquals(1, resultSet.getInt(1));37                        assertEquals("Doe", resultSet.getString(2));38                        assertEquals("John", resultSet.getString(3));39                        assertEquals("Some Address", resultSet.getString(4));40                        assertEquals("Some City", resultSet.getString(5));41                    }42                }43            }44        }45    }46}

MariaDBContainer

Using AI Code Generation

1    public void testWithMariaDBContainer() throws SQLException {2        try (MariaDBContainer mariaDBContainer = new MariaDBContainer()) {3            mariaDBContainer.start();4            String jdbcUrl = mariaDBContainer.getJdbcUrl();5            String username = mariaDBContainer.getUsername();6            String password = mariaDBContainer.getPassword();7            try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {8            }9        }10    }11    public void testWithMySQLContainer() throws SQLException {12        try (MySQLContainer mySQLContainer = new MySQLContainer()) {13            mySQLContainer.start();14            String jdbcUrl = mySQLContainer.getJdbcUrl();15            String username = mySQLContainer.getUsername();16            String password = mySQLContainer.getPassword();17            try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {18            }19        }20    }21    public void testWithOracleContainer() throws SQLException {22        try (OracleContainer oracleContainer = new OracleContainer()) {23            oracleContainer.start();24            String jdbcUrl = oracleContainer.getJdbcUrl();25            String username = oracleContainer.getUsername();26            String password = oracleContainer.getPassword();27            try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {28            }29        }30    }31    public void testWithPostgreSQLContainer() throws SQLException {32        try (PostgreSQLContainer postgreSQLContainer = new PostgreSQLContainer()) {33            postgreSQLContainer.start();34            String jdbcUrl = postgreSQLContainer.getJdbcUrl();35            String username = postgreSQLContainer.getUsername();36            String password = postgreSQLContainer.getPassword();37            try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password)) {38            }39        }40    }41    public void testWithSQLServerContainer() throws SQLException {42        try (SQLServerContainer sqlServerContainer = new SQLServerContainer()) {43            sqlServerContainer.start();

MariaDBContainer

Using AI Code Generation

1MariaDBContainer mariaDBContainer = new MariaDBContainer("mariadb:10.4.6")2mariaDBContainer.start()3def jdbcUrl = mariaDBContainer.getJdbcUrl()4def username = mariaDBContainer.getUsername()5def password = mariaDBContainer.getPassword()6def driverClassName = mariaDBContainer.getDriverClassName()7def dockerImageName = mariaDBContainer.getDockerImageName()8def config = new ConfigSlurper().parseText("""9|    driverClassName: ${driverClassName}10|    username: ${username}11|    password: ${password}12|    url: ${jdbcUrl}

MariaDBContainer

Using AI Code Generation

1[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ testcontainers-demo ---2[INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ testcontainers-demo ---3[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ testcontainers-demo ---4[INFO] --- maven-compiler-plugin:3.1:testCompile (default-testCompile) @ testcontainers-demo ---5[INFO] --- maven-surefire-plugin:2.12.4:test (default-test) @ testcontainers-demo ---6[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ testcontainers-demo ---7[INFO] --- spring-boot-maven-plugin:1.5.10.RELEASE:repackage (default) @ testcontainers-demo ---

MariaDBContainer

Using AI Code Generation

1import org.testcontainers.containers.MariaDBContainer2def mariadb = new MariaDBContainer()3mariadb.start()4def jdbcUrl = mariadb.getJdbcUrl()5def username = mariadb.getUsername()6def password = mariadb.getPassword()7def driverClassName = mariadb.getDriverClassName()8mariadb.stop()9mariadb.close()10import org.testcontainers.containers.MySQLContainer11def mysql = new MySQLContainer()12mysql.start()13def jdbcUrl = mysql.getJdbcUrl()14def username = mysql.getUsername()15def password = mysql.getPassword()16def driverClassName = mysql.getDriverClassName()17mysql.stop()18mysql.close()19import org.testcontainers.containers.PostgreSQLContainer20def postgresql = new PostgreSQLContainer()21postgresql.start()22def jdbcUrl = postgresql.getJdbcUrl()23def username = postgresql.getUsername()24def password = postgresql.getPassword()25def driverClassName = postgresql.getDriverClassName()26postgresql.stop()27postgresql.close()28import org.testcontainers.containers.SQLServerContainer29def sqlserver = new SQLServerContainer()30sqlserver.start()31def jdbcUrl = sqlserver.getJdbcUrl()32def username = sqlserver.getUsername()

Blogs

Check out the latest blogs from LambdaTest on this topic:

A Step-By-Step Guide To Cypress API Testing

API (Application Programming Interface) is a set of definitions and protocols for building and integrating applications. It’s occasionally referred to as a contract between an information provider and an information user establishing the content required from the consumer and the content needed by the producer.

Developers and Bugs – why are they happening again and again?

Entering the world of testers, one question started to formulate in my mind: “what is the reason that bugs happen?”.

What will come after “agile”?

I think that probably most development teams describe themselves as being “agile” and probably most development teams have standups, and meetings called retrospectives.There is also a lot of discussion about “agile”, much written about “agile”, and there are many presentations about “agile”. A question that is often asked is what comes after “agile”? Many testers work in “agile” teams so this question matters to us.

How To Use CSS Contain Property To Optimize Browsers

Putting Together a Testing Team

As part of one of my consulting efforts, I worked with a mid-sized company that was looking to move toward a more agile manner of developing software. As with any shift in work style, there is some bewilderment and, for some, considerable anxiety. People are being challenged to leave their comfort zones and embrace a continuously changing, dynamic working environment. And, dare I say it, testing may be the most ‘disturbed’ of the software roles in agile development.

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.