org.springframework.data.r2dbc.core.DatabaseClient Java Examples

@Override
public void initialize(GenericApplicationContext context) {

	MssqlConnectionConfiguration.Builder builder = MssqlConnectionConfiguration
			.builder()
			.host(this.properties.getHost())
			.port(this.properties.getPort())
			.database(this.properties.getDatabase())
			.username(this.properties.getUsername())
			.password(this.properties.getPassword())
			.connectTimeout(this.properties.getConnectTimeout())
			.preferCursoredExecution(this.properties.isPreferCursoredExecution());

	if (this.properties.isSsl()) {
		builder.enableSsl();
	}

	MssqlConnectionConfiguration configuration = builder.build();

	context.registerBean(DatabaseClient.class, () -> DatabaseClient.builder().connectionFactory(new MssqlConnectionFactory(configuration)).build());
}
 

@Override
public void initialize(GenericApplicationContext context) {

	PostgresqlConnectionConfiguration configuration = PostgresqlConnectionConfiguration
			.builder()
			.host(this.properties.getHost())
			.port(this.properties.getPort())
			.database(this.properties.getDatabase())
			.username(this.properties.getUsername())
			.password(this.properties.getPassword())
			.build();

	context.registerBean(DatabaseClient.class, () -> DatabaseClient.builder().connectionFactory(new PostgresqlConnectionFactory(configuration)).build());
}
 

/**
 * Initializes the integration test environment for the Spanner R2DBC dialect.
 */
@BeforeEach
public void initializeTestEnvironment() {
  Connection connection = Mono.from(connectionFactory.create()).block();

  this.databaseClient = DatabaseClient.create(connectionFactory);

  if (SpannerTestUtils.tableExists(connection, "PRESIDENT")) {
    this.databaseClient.execute("DROP TABLE PRESIDENT")
        .fetch()
        .rowsUpdated()
        .block();
  }

  this.databaseClient.execute(
      "CREATE TABLE PRESIDENT ("
          + "  NAME STRING(256) NOT NULL,"
          + "  START_YEAR INT64 NOT NULL"
          + ") PRIMARY KEY (NAME)")
      .fetch()
      .rowsUpdated()
      .block();
}
 

@Autowired
public R2dbcAppMetricsRepository(
	DatabaseClient client,
	DbmsSettings settings) {
	this.client = client;
	this.settings = settings;
}
 

@Override
public void initialize(GenericApplicationContext context) {

	H2ConnectionConfiguration configuration = H2ConnectionConfiguration
			.builder()
			.url(this.properties.getUrl())
			.username(this.properties.getUsername())
			.password(this.properties.getPassword())
			.build();

	context.registerBean(DatabaseClient.class, () -> DatabaseClient.builder().connectionFactory(new H2ConnectionFactory(configuration)).build());

}
 

@Bean
ApplicationRunner runner(DatabaseClient dbc, ReservationRepository reservationRepository) {
	return args -> {

		dbc.execute("create table reservation\n" + "(\n" + "    id   serial primary key,\n"
				+ "    name varchar(255) not null\n" + ")").fetch().rowsUpdated().subscribe();

		reservationRepository.save(new Reservation(null, "Andy")).subscribe();
		reservationRepository.save(new Reservation(null, "Sebastien")).subscribe();

		reservationRepository.findAll().subscribe(System.out::println);
		;
	};
}
 

@Autowired
public DatabaseCreator(
	DatabaseClient client,
	ResourceLoader resourceLoader,
	DbmsSettings settings,
	ApplicationEventPublisher publisher) {
	this.client = client;
	this.resourceLoader = resourceLoader;
	this.settings = settings;
	this.publisher = publisher;
}
 

@Override
public void initialize(GenericApplicationContext context) {

	JasyncConnectionFactory jasyncConnectionFactory = new JasyncConnectionFactory(new MySQLConnectionFactory(
			URLParser.INSTANCE.parseOrDie(properties.getUrl(), StandardCharsets.UTF_8)));
	context.registerBean(DatabaseClient.class, () -> DatabaseClient.builder().connectionFactory(jasyncConnectionFactory).build());
}
 

@Autowired
public R2dbcPoliciesRepository(
	DatabaseClient dbClient,
	PolicyIdProvider idProvider,
	ObjectMapper mapper) {
	this.dbClient = dbClient;
	this.idProvider = idProvider;
	this.mapper = mapper;
}
 

public DataInitializer(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

public UserRepository(DatabaseClient client) {
	this.client = client;
}
 

public DataInitializer(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

public DataInitializer(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

public DataInitializer(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

public DataInitializer(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

public R2dbcDbRepository(DatabaseClient databaseClient) {
    this.databaseClient = databaseClient;
}
 

@Bean
public DatabaseClient databaseClient(ConnectionFactory connectionFactory) {
    return DatabaseClient.create(connectionFactory);
}
 

@Autowired
public R2dbcAppRelationshipRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcQueryRepository(DatabaseClient client) {
    this.client = client;
}
 

@Autowired
public R2dbcSpaceRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcServiceInstanceDetailRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcHistoricalRecordRepository(DatabaseClient client) {
	this.client = client;
}
 

public R2dbcTkRepository(DatabaseClient client) {
    this.client = client;
}
 

@Autowired
public R2dbcOrganizationRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcAppDetailRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcSpaceUsersRepository(DatabaseClient client) {
	this.client = client;
}
 

@Autowired
public R2dbcServiceInstanceMetricsRepository(
	DatabaseClient client) {
	this.client = client;
}
 

@Setup
public void setUp() {

	R2dbcFixture fixture = new R2dbcFixture(profile);

	ConfigurableApplicationContext context = fixture.getContext();

	this.operations = context.getBean(DatabaseClient.class);
	this.mapper = row -> new Book(row.get("id", Long.class), row.get("title", String.class),
			row.get("pages", Integer.class));

	this.repository = context.getBean(R2dbcBookRepository.class);
}