使用testcontainers为mysql数据库设定种子

<dependency>
    <groupId>org.testcontainers</groupId>
    <artifactId>testcontainers</artifactId>
    <version>1.15.0</version>
    <scope>test</scope>
</dependency>

@Testcontainers
public class MyDatabaseTest {
    // ...
}

@Container
public static MySQLContainer<?> mysqlContainer = new MySQLContainer<>("mysql:8.0.26")
        .withDatabaseName("test")
        .withUsername("test")
        .withPassword("test");

@Test
public void testDatabaseInitialization() throws SQLException {
    Connection connection = DriverManager.getConnection(mysqlContainer.getJdbcUrl(),
            mysqlContainer.getUsername(), mysqlContainer.getPassword());

    // 执行初始化数据的操作，例如插入种子数据
    Statement statement = connection.createStatement();
    statement.executeUpdate("INSERT INTO my_table (column1, column2) VALUES ('value1', 'value2')");

    // 执行查询验证数据是否成功插入
    ResultSet resultSet = statement.executeQuery("SELECT COUNT(*) FROM my_table");
    resultSet.next();
    int rowCount = resultSet.getInt(1);
    assertEquals(1, rowCount);

    // 关闭连接
    resultSet.close();
    statement.close();
    connection.close();
}