KaneAI - World’s First E2E Software Testing Agent.Signup for Private Beta 
How to use PostgreSQLR2DBCDatabaseContainer class of org.testcontainers.containers package
Best Testcontainers-java code snippet using org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer
Source:WaterFacilityRepositoryTest.java 
2import com.example.utilities.WaterFacility;3import com.example.utilities.WaterFacilityRepository;4import org.testcontainers.containers.PostgisContainerProvider;5import org.testcontainers.containers.PostgreSQLContainer;6import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;7import io.micronaut.runtime.EmbeddedApplication;8import io.micronaut.test.extensions.junit5.annotation.MicronautTest;9import jakarta.inject.Inject;10import org.junit.jupiter.api.Assertions;11import org.junit.jupiter.api.BeforeAll;12import org.junit.jupiter.api.Test;13import org.junit.jupiter.api.TestInstance;14import org.locationtech.jts.geom.CoordinateXY;15import org.locationtech.jts.geom.GeometryFactory;16import org.locationtech.jts.geom.Point;17import org.locationtech.jts.geom.PrecisionModel;18import org.testcontainers.junit.jupiter.Container;19import org.testcontainers.junit.jupiter.Testcontainers;20import static org.junit.jupiter.api.Assertions.assertEquals;21import static org.junit.jupiter.api.Assertions.assertNotNull;22@MicronautTest23@Testcontainers24@TestInstance(TestInstance.Lifecycle.PER_CLASS)25public class WaterFacilityRepositoryTest {26 final private GeometryFactory gf = new GeometryFactory(new PrecisionModel(), 4326);27// @Container28// private static final PostgreSQLContainer JDBC_CONTAINER;29// @Container30// private static final PostgreSQLR2DBCDatabaseContainer R2DBC_CONTAINER;31// static {32// PostgreSQLContainer container = (PostgreSQLContainer)new PostgisContainerProvider()33// .newInstance("latest");34//35// PostgreSQLR2DBCDatabaseContainer r2dbcContainer = new PostgreSQLR2DBCDatabaseContainer(container);36//37// R2DBC_CONTAINER = r2dbcContainer;38// }39 @Inject40 EmbeddedApplication<?> application;41 @Inject42 PostGisInitializer postgisInitializer;43 @Inject44 WaterFacilityRepository repository;45 @BeforeAll46 public void setup() {47 postgisInitializer.initialize().block();48 }49 @Test...
Source:DatabaseFixture.java
...6import io.r2dbc.postgresql.PostgresqlConnectionFactoryProvider;7import io.r2dbc.spi.ConnectionFactoryOptions;8import org.testcontainers.containers.BindMode;9import org.testcontainers.containers.PostgreSQLContainer;10import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;11public class DatabaseFixture {12 public DatabaseClient startAndSchemaDatabase() {13 PostgreSQLContainer<?> container = new PostgreSQLContainer<>("postgres:12.3-alpine")14 .withClasspathResourceMapping("./sql/1-init.sql", "/docker-entrypoint-initdb.d/1.sql", BindMode.READ_ONLY)15 .withClasspathResourceMapping("./sql/posts-data.sql", "/docker-entrypoint-initdb.d/2.sql", BindMode.READ_ONLY)16// .withCommand("postgres -c log_statement=all -c log_destination=stderr")17 .withStartupTimeoutSeconds(5);18 PostgreSQLR2DBCDatabaseContainer postgreSQLR2DBCDatabaseContainer = new PostgreSQLR2DBCDatabaseContainer(container);19 postgreSQLR2DBCDatabaseContainer.start();20// container.followOutput(outputFrame -> System.out.println(outputFrame.getUtf8String()));21 ConnectionFactoryOptions options = PostgreSQLR2DBCDatabaseContainer.getOptions(container);22 PostgresqlConnectionFactory postgresqlConnectionFactory = new PostgresqlConnectionFactoryProvider().create(options);23 ConnectionPoolConfiguration configuration = ConnectionPoolConfiguration.builder(postgresqlConnectionFactory)24 .build();25 ConnectionPool pool = new ConnectionPool(configuration);26 return new DatabaseClient(pool);27 }28}...
Source:DatabaseConfig.java
...4import io.r2dbc.spi.ConnectionFactoryOptions;5import org.springframework.boot.test.context.TestConfiguration;6import org.springframework.context.annotation.Bean;7import org.testcontainers.containers.PostgreSQLContainer;8import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;9@TestConfiguration10public class DatabaseConfig {11 @Bean(initMethod = "start", destroyMethod = "stop")12 public PostgreSQLR2DBCDatabaseContainer jdbcDatabaseContainer() {13 return new PostgreSQLR2DBCDatabaseContainer(14 new PostgreSQLContainer<>().withInitScript("schema.sql")15 );16 }17 @Bean18 public ConnectionFactory connectionFactory(PostgreSQLR2DBCDatabaseContainer jdbcDatabaseContainer) {19 ConnectionFactoryOptions options = jdbcDatabaseContainer.configure(ConnectionFactoryOptions.builder().build());20 var connectionFactoryProvider = new PostgresqlConnectionFactoryProvider();21 return connectionFactoryProvider.create(options);22 }23}...
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;2import org.testcontainers.junit.jupiter.Container;3import org.testcontainers.junit.jupiter.Testcontainers;4import org.junit.jupiter.api.Test;5import org.springframework.boot.test.context.SpringBootTest;6import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;7import org.testcontainers.containers.PostgreSQLContainer;8@SpringJUnitConfig(classes = {Testcontainers.class})9public class TestContainersDemoApplicationTests {10 public static PostgreSQLContainer container = new PostgreSQLContainer()11 .withDatabaseName("testcontainers")12 .withUsername("testcontainers")13 .withPassword("testcontainers");14 public void contextLoads() {15 }16}
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;2import org.testcontainers.utility.DockerImageName;3import org.testcontainers.containers.GenericContainer;4import org.testcontainers.containers.Network;5import org.testcontainers.containers.PostgreSQLContainer;6import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;7import org.testcontainers.containers.output.Slf4jLogConsumer;8import org.testcontainers.images.builder.ImageFromDockerfile;9import org.testcontainers.junit.jupiter.Container;10import org.testcontainers.junit.jupiter.Testcontainers;11import org.testcontainers.utility.DockerImageName;12import org.testcontainers.utility.MountableFile;13import org.testcontainers.containers.GenericContainer;14import org.testcontainers.containers.Network;15import org.testcontainers.containers.PostgreSQLContainer;16import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;17import org.testcontainers.containers.output.Slf4jLogConsumer;18import org.testcontainers.images.builder.ImageFromDockerfile;19import org.testcontainers.junit.jupiter.Container;20import org.testcontainers.junit.jupiter.Testcontainers;21import org.testcontainers.utility.DockerImageName;22import org.testcontainers.utility.MountableFile;23import org.testcontainers.containers.GenericContainer;24import org.testcontainers.containers.Network;25import org.testcontainers.containers.PostgreSQLContainer;26import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;27import org.testcontainers.containers.output.Slf4jLogConsumer;28import org.testcontainers.images.builder.ImageFromDockerfile;29import org.testcontainers.junit.jupiter.Container;30import org.testcontainers.junit.jupiter.Testcontainers;31import org.testcontainers.utility.DockerImageName;32import org.testcontainers.utility.MountableFile;33import org.testcontainers.containers.GenericContainer;34import org.testcontainers.containers.Network;35import org.testcontainers.containers.PostgreSQLContainer;36import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;37import org.testcontainers.containers.output.Slf4jLogConsumer;38import org.testcontainers.images.builder.ImageFromDockerfile;39import org.testcontainers.junit.jupiter.Container;40import org.testcontainers.junit.jupiter.Testcontainers;41import org.testcontainers.utility.DockerImageName;42import org.testcontainers.utility.MountableFile;43import org.testcontainers.containers.GenericContainer;44import org.testcontainers.containers.Network;45import org.testcontainers.containers.PostgreSQLContainer;46import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;47import org.testcontainers.containers.output.Slf4jLogConsumer;48import org.testcontainers.images.builder.ImageFrom
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;2public class 1 {3 public static void main(String[] args) {4 PostgreSQLR2DBCDatabaseContainer container = new PostgreSQLR2DBCDatabaseContainer();5 container.start();6 System.out.println("Container ID: " + container.getContainerId());7 System.out.println("Container Image: " + container.getDockerImageName());8 System.out.println("Container Port: " + container.getFirstMappedPort());9 System.out.println("Container Username: " + container.getUsername());10 System.out.println("Container Password: " + container.getPassword());11 container.stop();12 }13}
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;2import org.testcontainers.containers.PostgreSQLContainer;3import org.testcontainers.containers.GenericContainer;4import org.testcontainers.containers.output.Slf4jLogConsumer;5import java.io.IOException;6import java.util.logging.Logger;7import java.util.logging.Level;8public class Testcontainers {9 public static void main(String[] args) {10 Logger logger = Logger.getLogger(Testcontainers.class.getName());11 PostgreSQLR2DBCDatabaseContainer container = new PostgreSQLR2DBCDatabaseContainer();12 container.withLogConsumer(new Slf4jLogConsumer(logger));13 container.start();14 System.out.println("Container Started");15 System.out.println("Container ID: " + container.getContainerId());16 System.out.println("Container Info: " + container.getContainerInfo());17 System.out.println("Host: " + container.getHost());18 System.out.println("JDBC URL: " + container.getJdbcUrl());19 System.out.println("Password: " + container.getPassword());20 System.out.println("Port: " + container.getPort());21 System.out.println("R2DBC URL: " + container.getR2dbcUrl());22 System.out.println("Username: " + container.getUsername());23 container.stop();24 System.out.println("Container Stopped");25 }26}27Container Info: ContainerInfo{id=3b3f2f8c9f3a9a7d0c8a8d8e6b1f6e7b5d3f2e1d0c8a9b7c6e5d4f3e2d1f0e0, created=2021-06-03T11:41:24.836Z, path=/docker-entrypoint.sh, args=[postgres], state=running, image=postgres:12.6, resolvConfPath=/var/lib/docker/containers/3b3f2f8c9f3a9a7d0c8a8d8e6b1f6e7b5d3f2e1d
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import java.sql.*;2import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;3import org.testcontainers.utility.DockerImageName;4public class 1 {5 public static void main(String[] args) throws SQLException {6 PostgreSQLR2DBCDatabaseContainer container = new PostgreSQLR2DBCDatabaseContainer(DockerImageName.parse("postgres:13"));7 container.start();8 String url = container.getJdbcUrl();9 String username = container.getUsername();10 String password = container.getPassword();11 try (Connection connection = DriverManager.getConnection(url, username, password)) {12 Statement statement = connection.createStatement();13 ResultSet resultSet = statement.executeQuery("SELECT 1");14 resultSet.next();15 System.out.println(resultSet.getInt(1));16 }17 }18}
PostgreSQLR2DBCDatabaseContainer
Using AI Code Generation
1import org.testcontainers.containers.PostgreSQLR2DBCDatabaseContainer;2import org.testcontainers.utility.DockerImageName;3 public class TestPostgreSQLR2DBCDatabaseContainer {4 public static void main ( String [] args ) {5 PostgreSQLR2DBCDatabaseContainer container = new PostgreSQLR2DBCDatabaseContainer(6 DockerImageName.parse( "postgres:13.3" ).asCompatibleSubstituteFor( "postgres" ));7 container.start();8 System.out.println( "Container started." );9 System.out.println( "JDBC URL: " + container.getJdbcUrl());10 System.out.println( "User: " + container.getUsername());11 System.out.println( "Password: " + container.getPassword());12 }13}
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.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run Testcontainers-java automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Most used methods in PostgreSQLR2DBCDatabaseContainer
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
