Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use testSimple method of org.testcontainers.junit.mysql.CustomizableMysqlTest class

Best Testcontainers-java code snippet using org.testcontainers.junit.mysql.CustomizableMysqlTest.testSimple

Source:CustomizableMysqlTest.java

...15    // Add MYSQL_ROOT_HOST environment so that we can root login from anywhere for testing purposes16    @Rule17    public MySQLContainer mysql = ((MySQLContainer) (new MySQLContainer("mysql:5.5").withDatabaseName(CustomizableMysqlTest.DB_NAME).withUsername(CustomizableMysqlTest.USER).withPassword(CustomizableMysqlTest.PWD).withEnv("MYSQL_ROOT_HOST", "%")));18    @Test19    public void testSimple() throws SQLException {20        HikariConfig hikariConfig = new HikariConfig();21        hikariConfig.setJdbcUrl(((((("jdbc:mysql://" + (mysql.getContainerIpAddress())) + ":") + (mysql.getMappedPort(MYSQL_PORT))) + "/") + (CustomizableMysqlTest.DB_NAME)));22        hikariConfig.setUsername(CustomizableMysqlTest.USER);23        hikariConfig.setPassword(CustomizableMysqlTest.PWD);24        HikariDataSource ds = new HikariDataSource(hikariConfig);25        Statement statement = ds.getConnection().createStatement();26        statement.execute("SELECT 1");27        ResultSet resultSet = statement.getResultSet();28        assertEquals("There is a result", resultSet.next(), true);29        int resultSetInt = resultSet.getInt(1);30        assertEquals("A basic SELECT query succeeds", 1, resultSetInt);31    }32}...

testSimple

Using AI Code Generation

1import org.testcontainers.containers.MySQLContainer;2import org.testcontainers.containers.output.Slf4jLogConsumer;3import org.testcontainers.containers.wait.strategy.Wait;4import org.testcontainers.utility.DockerImageName;5import org.slf4j.Logger;6import org.slf4j.LoggerFactory;7import java.sql.Connection;8import java.sql.DriverManager;9import java.sql.ResultSet;10import java.sql.Statement;11public class CustomizableMysqlTest {12    private static final Logger log = LoggerFactory.getLogger(CustomizableMysqlTest.class);13    public static void testSimple() throws Exception {14        MySQLContainer mysql = new MySQLContainer(DockerImageName.parse("mysql:8.0.26"))15                .withUsername("user")16                .withPassword("password")17                .withDatabaseName("test")18                .withLogConsumer(new Slf4jLogConsumer(log))19                .waitingFor(Wait.forListeningPort());20        mysql.start();21        try (Connection connection = DriverManager.getConnection(mysql.getJdbcUrl(), mysql.getUsername(), mysql.getPassword());22             Statement statement = connection.createStatement()) {23            statement.execute("create database test");24            statement.execute("use test");25            statement.execute("create table test(id int not null, name varchar(255), primary key(id))");26            statement.execute("insert into test(id, name) values(1, 'test')");27        }28        try (Connection connection = DriverManager.getConnection(mysql.getJdbcUrl(), mysql.getUsername(), mysql.getPassword());29             Statement statement = connection.createStatement()) {30            ResultSet resultSet = statement.executeQuery("select * from test");31            while (resultSet.next()) {32                log.info("id: {}, name: {}", resultSet.getInt("id"), resultSet.getString("name"));33            }34        }35        mysql.stop();36    }37}

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.