io.r2dbc.spi.ConnectionFactories Java Exaples

Source File: CloudConfig.java From cf-butler with Apache License 2.0

8 votes

@Bean
@ConditionalOnProperty(VCAP_SERVICE_VARIABLE)
ConnectionFactory connectionFactory() {
    R2dbcProperties properties = r2dbcProperties();
    ConnectionFactoryOptions.Builder builder = ConnectionFactoryOptions
            .parse(properties.getUrl()).mutate();
    String username = properties.getUsername();
    if (StringUtils.hasText(username)) {
        builder.option(ConnectionFactoryOptions.USER, username);
    }
    String password = properties.getPassword();
    if (StringUtils.hasText(password)) {
        builder.option(ConnectionFactoryOptions.PASSWORD, password);
    }
    String databaseName = properties.getName();
    if (StringUtils.hasText(databaseName)) {
        builder.option(ConnectionFactoryOptions.DATABASE, databaseName);
    }
    if (properties.getProperties() != null) {
        properties.getProperties()
                .forEach((key, value) -> builder
                        .option(Option.valueOf(key), value));
    }
    return ConnectionFactories.get(builder.build());
}

Source File: TestcontainersR2DBCConnectionFactoryTest.java From testcontainers-java with MIT License

7 votes

@Test
public void reusesUntilConnectionFactoryIsClosed() {
    String url = "r2dbc:tc:postgresql:///db?TC_IMAGE_TAG=10-alpine";
    ConnectionFactory connectionFactory = ConnectionFactories.get(url);

    Integer updated = Flux
        .usingWhen(
            connectionFactory.create(),
            connection -> {
                return Mono
                    .from(connection.createStatement("CREATE TABLE test(id integer PRIMARY KEY)").execute())
                    .thenMany(connection.createStatement("INSERT INTO test(id) VALUES(123)").execute())
                    .flatMap(Result::getRowsUpdated);
            },
            Connection::close
        )
        .blockFirst();

    assertThat(updated).isEqualTo(1);

    Flux<Long> select = Flux
        .usingWhen(
            Flux.defer(connectionFactory::create),
            connection -> {
                return Flux
                    .from(connection.createStatement("SELECT COUNT(*) FROM test").execute())
                    .flatMap(it -> it.map((row, meta) -> (Long) row.get(0)));
            },
            Connection::close
        );

    Long rows = select.blockFirst();

    assertThat(rows).isEqualTo(1);

    close(connectionFactory);

    Assertions
        .assertThatThrownBy(select::blockFirst)
        .isInstanceOf(PostgresqlException.class)
        // relation "X" does not exists
        // https://github.com/postgres/postgres/blob/REL_10_0/src/backend/utils/errcodes.txt#L349
        .returns("42P01", e -> ((PostgresqlException) e).getErrorDetails().getCode());
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

7 votes

@Test
void invalidProgrammatic() {
    assertThat(assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(SSL, true)
        .build()))
        .getMessage())
        .contains("sslMode");

    for (SslMode mode : SslMode.values()) {
        if (mode.startSsl()) {
            assertThat(assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
                .option(DRIVER, "mysql")
                .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
                .option(USER, "root")
                .option(Option.valueOf("sslMode"), mode.name().toLowerCase())
                .build()))
                .getMessage())
                .contains("sslMode");
        }
    }
}

Source File: DatasourceConfig.java From tutorials with MIT License

6 votes

@Bean
public ConnectionFactory connectionFactory(R2DBCConfigurationProperties properties) {
    
    ConnectionFactoryOptions baseOptions = ConnectionFactoryOptions.parse(properties.getUrl());
    Builder ob = ConnectionFactoryOptions.builder().from(baseOptions);
    if ( !StringUtil.isNullOrEmpty(properties.getUser())) {
        ob = ob.option(USER, properties.getUser());
    }

    if ( !StringUtil.isNullOrEmpty(properties.getPassword())) {
        ob = ob.option(PASSWORD, properties.getPassword());
    }
    
    ConnectionFactory cf = ConnectionFactories.get(ob.build());
    return cf;
}

Source File: TestcontainersR2DBCConnectionFactory.java From testcontainers-java with MIT License

6 votes

@Override
public Publisher<? extends Connection> create() {
    return new ConnectionPublisher(
        () -> {
            if (future == null) {
                synchronized (this) {
                    if (future == null) {
                        future = CompletableFuture.supplyAsync(() -> {
                            R2DBCDatabaseContainer container = containerProvider.createContainer(options);
                            container.start();
                            return container;
                        }, EXECUTOR);
                    }
                }
            }
            return future.thenApply(it -> {
                return ConnectionFactories.find(
                    it.configure(options)
                );
            });
        }
    );
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void invalidServerPreparing() {
    assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, NotPredicate.class.getTypeName())
        .build()));

    assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, NotPredicate.class.getPackage() + "NonePredicate")
        .build()));
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void invalidUrl() {
    assertThat(assertThrows(
        IllegalArgumentException.class,
        () -> ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306?" +
            "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8"))).getMessage())
        .contains("sslMode");

    for (SslMode mode : SslMode.values()) {
        if (mode.startSsl()) {
            assertThat(assertThrows(
                IllegalArgumentException.class,
                () -> ConnectionFactories.get("r2dbc:mysql://root@localhost:3306?" +
                    "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8") +
                    "&sslMode=" + mode.name().toLowerCase())).getMessage())
                .contains("sslMode");
        }
    }
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void validUrl() throws UnsupportedEncodingException {
    assertThat(ConnectionFactories.get("r2dbc:mysql://root@localhost:3306")).isExactlyInstanceOf(MySqlConnectionFactory.class);
    assertThat(ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306")).isExactlyInstanceOf(MySqlConnectionFactory.class);
    assertThat(ConnectionFactories.get("r2dbc:mysql://root@localhost:3306?unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8")))
        .isExactlyInstanceOf(MySqlConnectionFactory.class);

    assertThat(ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306?" +
        "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8") +
        "&sslMode=disabled")).isNotNull();

    assertThat(ConnectionFactories.get(
        "r2dbcs:mysql://root:[email protected]:3306/r2dbc?" +
            "zeroDate=use_round&" +
            "sslMode=verify_identity&" +
            "serverPreparing=true" +
            String.format("tlsVersion=%s&", URLEncoder.encode("TLSv1.1,TLSv1.2,TLSv1.3", "UTF-8")) +
            String.format("sslCa=%s&", URLEncoder.encode("/path/to/ca.pem", "UTF-8")) +
            String.format("sslKey=%s&", URLEncoder.encode("/path/to/client-key.pem", "UTF-8")) +
            String.format("sslCert=%s&", URLEncoder.encode("/path/to/client-cert.pem", "UTF-8")) +
            "sslKeyPassword=ssl123456"
    )).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void invalidServerPreparing() {
    assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, NotPredicate.class.getTypeName())
        .build()));

    assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, NotPredicate.class.getPackage() + "NonePredicate")
        .build()));
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void invalidProgrammatic() {
    assertThat(assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(SSL, true)
        .build()))
        .getMessage())
        .contains("sslMode");

    for (SslMode mode : SslMode.values()) {
        if (mode.startSsl()) {
            assertThat(assertThrows(IllegalArgumentException.class, () -> ConnectionFactories.get(ConnectionFactoryOptions.builder()
                .option(DRIVER, "mysql")
                .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
                .option(USER, "root")
                .option(Option.valueOf("sslMode"), mode.name().toLowerCase())
                .build()))
                .getMessage())
                .contains("sslMode");
        }
    }
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void invalidUrl() {
    assertThat(assertThrows(
        IllegalArgumentException.class,
        () -> ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306?" +
            "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8"))).getMessage())
        .contains("sslMode");

    for (SslMode mode : SslMode.values()) {
        if (mode.startSsl()) {
            assertThat(assertThrows(
                IllegalArgumentException.class,
                () -> ConnectionFactories.get("r2dbc:mysql://root@localhost:3306?" +
                    "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8") +
                    "&sslMode=" + mode.name().toLowerCase())).getMessage())
                .contains("sslMode");
        }
    }
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

6 votes

@Test
void validUrl() throws UnsupportedEncodingException {
    assertThat(ConnectionFactories.get("r2dbc:mysql://root@localhost:3306")).isExactlyInstanceOf(MySqlConnectionFactory.class);
    assertThat(ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306")).isExactlyInstanceOf(MySqlConnectionFactory.class);
    assertThat(ConnectionFactories.get("r2dbc:mysql://root@localhost:3306?unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8")))
        .isExactlyInstanceOf(MySqlConnectionFactory.class);

    assertThat(ConnectionFactories.get("r2dbcs:mysql://root@localhost:3306?" +
        "unixSocket=" + URLEncoder.encode("/path/to/mysql.sock", "UTF-8") +
        "&sslMode=disabled")).isNotNull();

    assertThat(ConnectionFactories.get(
        "r2dbcs:mysql://root:[email protected]:3306/r2dbc?" +
            "zeroDate=use_round&" +
            "sslMode=verify_identity&" +
            "serverPreparing=true" +
            String.format("tlsVersion=%s&", URLEncoder.encode("TLSv1.1,TLSv1.2,TLSv1.3", "UTF-8")) +
            String.format("sslCa=%s&", URLEncoder.encode("/path/to/ca.pem", "UTF-8")) +
            String.format("sslKey=%s&", URLEncoder.encode("/path/to/client-key.pem", "UTF-8")) +
            String.format("sslCert=%s&", URLEncoder.encode("/path/to/client-cert.pem", "UTF-8")) +
            "sslKeyPassword=ssl123456"
    )).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: SpringDataR2dbcApp.java From cloud-spanner-r2dbc with Apache License 2.0

5 votes

@Bean
public static ConnectionFactory spannerConnectionFactory() {
  ConnectionFactory connectionFactory = ConnectionFactories.get(ConnectionFactoryOptions.builder()
      .option(Option.valueOf("project"), GCP_PROJECT)
      .option(DRIVER, DRIVER_NAME)
      .option(INSTANCE, SPANNER_INSTANCE)
      .option(DATABASE, SPANNER_DATABASE)
      .build());

  return connectionFactory;
}

Source File: BookExampleApp.java From cloud-spanner-r2dbc with Apache License 2.0

5 votes

/**
 * Constructor.
 *
 * @param sampleInstance the sample instance to use.
 * @param sampleDatabase the sample database to use.
 * @param sampleProjectId the sample project to use.
 */
public BookExampleApp(String sampleInstance, String sampleDatabase,
    String sampleProjectId) {
  this.connectionFactory = ConnectionFactories.get(ConnectionFactoryOptions.builder()
      .option(Option.valueOf("project"), sampleProjectId)
      .option(DRIVER, DRIVER_NAME)
      .option(INSTANCE, sampleInstance)
      .option(DATABASE, sampleDatabase)
      .build());
}

Source File: R2DBCDatabaseContainerProvider.java From testcontainers-java with MIT License

5 votes

@Nullable
default ConnectionFactoryMetadata getMetadata(ConnectionFactoryOptions options) {
    ConnectionFactoryOptions.Builder builder = options.mutate();
    if (!options.hasOption(ConnectionFactoryOptions.HOST)) {
        builder.option(ConnectionFactoryOptions.HOST, "localhost");
    }
    if (!options.hasOption(ConnectionFactoryOptions.PORT)) {
        builder.option(ConnectionFactoryOptions.PORT, 65535);
    }

    ConnectionFactory connectionFactory = ConnectionFactories.find(builder.build());
    return connectionFactory != null ? connectionFactory.getMetadata() : null;
}

Source File: AbstractR2DBCDatabaseContainerTest.java From testcontainers-java with MIT License

5 votes

@Test
public final void testGetOptions() {
    try (T container = createContainer()) {
        container.start();

        ConnectionFactory connectionFactory = ConnectionFactories.get(getOptions(container));
        runTestQuery(connectionFactory);
    }
}

Source File: TestcontainersR2DBCConnectionFactoryTest.java From testcontainers-java with MIT License

5 votes

@Test
public void failsOnUnknownProvider() {
    String nonExistingProvider = UUID.randomUUID().toString();
    Assertions
        .assertThatThrownBy(() -> {
            ConnectionFactories.get(String.format("r2dbc:tc:%s:///db", nonExistingProvider));
        })
        .hasMessageContaining("Missing provider")
        .hasMessageContaining(nonExistingProvider);
}

Source File: R2dbcConfig.java From FrameworkBenchmarks with BSD 3-Clause "New" or "Revised" License

5 votes

@Bean
public ConnectionFactory connectionFactory() {
    return ConnectionFactories.get(ConnectionFactoryOptions.builder()
            .option(DRIVER,"pool")
            .option(PROTOCOL,"postgresql")
            .option(HOST, host)
            .option(PORT, port)
            .option(USER, username)
            .option(PASSWORD, password)
            .option(DATABASE, name)
            .build());
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

4 votes

@Test
void validProgrammatic() {
    ConnectionFactoryOptions options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(SSL, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(Option.valueOf("sslMode"), "disabled")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(SSL, false)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(Option.valueOf("sslMode"), "disabled")
        .option(SSL, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(PORT, 3307)
        .option(USER, "root")
        .option(PASSWORD, "123456")
        .option(SSL, true)
        .option(CONNECT_TIMEOUT, Duration.ofSeconds(3))
        .option(DATABASE, "r2dbc")
        .option(Option.valueOf("zeroDate"), "use_round")
        .option(Option.valueOf("sslMode"), "verify_identity")
        .option(Option.valueOf("tlsVersion"), "TLSv1.2,TLSv1.3")
        .option(Option.valueOf("sslCa"), "/path/to/ca.pem")
        .option(Option.valueOf("sslKey"), "/path/to/client-key.pem")
        .option(Option.valueOf("sslCert"), "/path/to/client-cert.pem")
        .option(Option.valueOf("sslKeyPassword"), "ssl123456")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

4 votes

@Test
void serverPreparing() {
    ConnectionFactoryOptions options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, AllTruePredicate.class.getTypeName())
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, "true")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, "false")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, AllTruePredicate.INSTANCE)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, false)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

4 votes

@Test
void serverPreparing() {
    ConnectionFactoryOptions options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, AllTruePredicate.class.getTypeName())
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, "true")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, "false")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, AllTruePredicate.INSTANCE)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(USE_SERVER_PREPARE_STATEMENT, false)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: MySqlConnectionFactoryProviderTest.java From r2dbc-mysql with Apache License 2.0

4 votes

@Test
void validProgrammatic() {
    ConnectionFactoryOptions options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(USER, "root")
        .option(SSL, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(Option.valueOf("sslMode"), "disabled")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(SSL, false)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(Option.valueOf("unixSocket"), "/path/to/mysql.sock")
        .option(USER, "root")
        .option(Option.valueOf("sslMode"), "disabled")
        .option(SSL, true)
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);

    options = ConnectionFactoryOptions.builder()
        .option(DRIVER, "mysql")
        .option(HOST, "127.0.0.1")
        .option(PORT, 3307)
        .option(USER, "root")
        .option(PASSWORD, "123456")
        .option(SSL, true)
        .option(CONNECT_TIMEOUT, Duration.ofSeconds(3))
        .option(DATABASE, "r2dbc")
        .option(Option.valueOf("zeroDate"), "use_round")
        .option(Option.valueOf("sslMode"), "verify_identity")
        .option(Option.valueOf("tlsVersion"), "TLSv1.2,TLSv1.3")
        .option(Option.valueOf("sslCa"), "/path/to/ca.pem")
        .option(Option.valueOf("sslKey"), "/path/to/client-key.pem")
        .option(Option.valueOf("sslCert"), "/path/to/client-cert.pem")
        .option(Option.valueOf("sslKeyPassword"), "ssl123456")
        .build();

    assertThat(ConnectionFactories.get(options)).isExactlyInstanceOf(MySqlConnectionFactory.class);
}

Source File: AbstractR2DBCDatabaseContainerTest.java From testcontainers-java with MIT License

4 votes

@Test
public final void testUrlSupport() {
    ConnectionFactory connectionFactory = ConnectionFactories.get(createR2DBCUrl());
    runTestQuery(connectionFactory);
}

Source File: AbstractR2DBCDatabaseContainerTest.java From testcontainers-java with MIT License

4 votes

@Test
public final void testGetMetadata() {
    ConnectionFactory connectionFactory = ConnectionFactories.get(createR2DBCUrl());
    ConnectionFactoryMetadata metadata = connectionFactory.getMetadata();
    assertThat(metadata).isNotNull();
}

io.r2dbc.spi.ConnectionFactories Java Examples