Spring R2DBC Relationships

A set of annotations to handle entity relationships when working on Spring Data R2DBC.

As of the release date of this library, Spring R2DBC does not yet offer any mechanism to manage entity relationships. Providing relations is not a trivial problem for R2DBC, as the correct way to populate the relations is by converting and emitting results as received in a single connection. Simply put, it should not collect the results into a List to issue queries that populate the relations. However, until R2DBC offers a proper solution, collecting the results is the only option on userland.

Spring R2DBC Relationships leverages the Entity Callback API to intercept the entity mapping and persistence lifecycle. Looking for field annotations and their configuration, it abstracts and generalizes the process to populate, persist, and link the relationships.

Features

Simple and intuitive.
Ultrafast reflection based on Lambda Metafactory.
Flexible--Works with both mutable and immutable entities:
- Java Records are supported. You can use getter methods either with or without the get prefix.
- You can either use traditional setters or immutable withers to make updates.
Support for entity projections.
Considers any custom R2DBC Repositories.

Install

Spring R2DBC Relationships is available in Maven Central. You can also find a link and the latest version on the badge above.

Gradle

implementation('io.github.joselion:spring-r2dbc-relationships:x.y.z')

Maven

<dependency>
  <groupId>io.github.joselion</groupId>
  <artifactId>spring-r2dbc-relationships</artifactId>
  <version>x.y.z</version>
</dependency>

Requirements

Spring R2DBC Relationships requires:

JDK level 17 and above
Spring Data R2DBC 3.x and above

Usage

To add the relational entity callbacks, you must register an R2dbcRelationshipsCallbacks<T> bean in your application context. However, Spring R2DBC Relationships provides the R2dbcRelationshipsAutoConfiguration configuration, so Spring Boot users only need to add the dependency, and the bean will be automatically registered. If you register the bean manually, ensure the bean remains generic to intercept any entity and ensure your injected R2dbcTemplate bean is lazy to avoid dependency cycles.

@Configuration
public class MyApplicationConfiguration {

  @Bean
  public <T> R2dbcRelationshipsCallbacks<T> relationshipsCallbacks(
    final @Lazy R2dbcEntityTemplate template,
    final ApplicationContext context
  ) {
    return new R2dbcRelationshipsCallbacks(templete, context);
  }
}

Spring R2DBC is not an ORM, and Spring R2DBC Relationships abides by the same philosophy. In that sense, the library will persist entities when necessary and link them to their relations, but you still need to have all fields that map those links in your entities, a.k.a. the "foreign key" column fields.

@OneToOne

[!HINT] You can find the complete list of parameters for this annotation in the @OneToOne Javadocs reference.

The @OneToOne annotation lets you mark fields to have a one-to-one relationship. The default behavior of the annotation is to populate the field after mapping the entity object, create/update the associated entity, and link the relation by setting the "foreign key" field in the proper entity.

You can use the annotation on both sides of the relationship to achieve a bidirectional association--the annotation handles cyclic persistence and population automatically. However, persisting from the parent side of the relationship is highly recommended since the parent entity will be unlinked (and optionally deleted) whenever the parent field in the child is null. So, suppose you configure the foreign key in the database to ON DELETE CASCADE. In that case, the persist operation will fail with a TransientDataAccessResourceException because the child entity gets deleted before the update can finish. Similarly, if the foreign key column is NOT NULL, you won't be able to have a child without its parent.

Example

Given the following tables present in your database:

CREATE TABLE phone(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  number varchar(255) NOT NULL
);

CREATE TABLE details(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  phone_id uuid NOT NULL,
  provider varchar(255) NOT NULL,
  technology varchar(255) NOT NULL,
  FOREIGN KEY (phone_id) REFERENCES phone ON DELETE CASCADE
);

You can use the @OneToOne annotation in both Phone and Details entities:

@With
public record Phone(
  @Id UUID id,
  LocalDateTime createdAt,
  String number,
  @OneToOne Details details
) {

 // implementation omitted...
}

@With
public record Details(
  @Id UUID id,
  LocalDateTime createdAt,
  UUID phoneId,
  @OneToOne(readonly = true) Phone phone,
  String provider,
  String technology
) {

  // implementation omitted...
}

Note

The annotation in Details is a backreference to Phone, and in the example details cannot exist without a phone. To prevent data integrity violations, we have configured the Details#phone field as read-only, meaning it's never persisted or linked whenever Details persists.

@OneToMany

[!HINT] You can find the complete list of parameters for this annotation in the @OneToMany Javadocs reference.

The @OneToMany annotation lets you mark fields to have a one-to-many relationship. The default behavior of the annotation is to populate the field after mapping the entity object, create/update the children entities, and link the relations by setting the "foreign key" field in each child entity.

You can achieve bidirectional one-to-many relationships using the @ManyToOne annotation on the children's side of the relationship. Check the next section for more details on that. There's also a different use case where the children entities already exist, and you only need to link them to the parent without changing the existing entities. You can set linkOnly = true in the annotation parameters to achieve said behavior. However, link-only associations will fail if the linked entity does not exist when you create/update the parent.

Important

The annotation only supports List<T> types for now. We'll consider support for more collection types as the use cases present.

Handling orphans

Usually, one-to-one relationships have a parent-child configuration, meaning the child needs to have the parent assigned to it. By default, the annotation will delete the associated entity when it becomes an orphan or the child is no longer assigned to the parent. You can prevent this behavior by setting keepOrphan = true in the annotation parameters, in which case it will only remove the link of the orphan entity with the parent.

Example

Given the following tables present in your database:

CREATE TABLE country(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  name varchar(255) NOT NULL
);

CREATE TABLE city(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  country_id uuid NOT NULL,
  name varchar(255) NOT NULL,
  FOREIGN KEY (country_id) REFERENCES country ON DELETE CASCADE
);

You can use the @OneToMany annotation in the Country entity:

public record Country(
  @Id UUID id,
  LocalDateTime createdAt,
  String name,
  @OneToMany List<City> cities
) {

 // implementation omitted...
}

By default, the annotations will sort the populated list of cities by the created_at column in a descendant direction. You can customize the sorting column and direction using the annotation parameters.

Handling orphans

The @OneToMany annotation handles orphan children removal for you. Meaning it will delete any entities that no longer exist in the list whenever the entity is updated. So, if you want to remove all children, you can pass an empty list to the field and update the entity. Finally, if you don't want to modify the children upon update, you can set the field to null to tell the annotation to ignore the field. You can change the orphan removal behavior by setting keepOrphans = true in the annotation parameters.

@ManyToOne

[!HINT] You can find the complete list of parameters for this annotation in the @ManyToOne Javadocs reference.

The @ManyToOne annotation lets you mark fields to have a many-to-one relationship. As mentioned in the previous section, the many-to-one relationship is the backreference of a one-to-many relationship. Simply put, this annotation lets you have a reference to the parent entity on each child. That said, the default behavior of the annotation is to populate the field after mapping the entity object, but it will not create, update, or link the parent entity. By default, this side of the relationship is read-only. You can change this behavior by setting persist = true in the annotation parameters, but remember that changing a single child's parent will affect all the children.

As mentioned above, you can achieve bidirectional many-to-one relationships using the @OneToMany annotation on the parent side of the relationship. Check the previous section for more details on that.

Example

Using the same database tables as in the one-to-many example, you can use the @ManyToOne annotation in the City entity:

@With
public record City(
  @Id UUID id,
  LocalDateTime createdAt,
  UUID countryId,
  @ManyToOne Country country,
  String name,
) {

  // implementation omitted...
}

Note

Notice that having the countryId field, which maps to the foreign key column, is required for the relationship to work properly.

If the annotation is persist = true and the field is null upon persistence, the annotation shall never delete the parent because it can still have other linked children. However, it will change the foreign key to null to unlink the children from the parent.

@ManyToMany

[!HINT] You can find the complete list of parameters for this annotation in the @ManyToMany Javadocs reference.

The @ManyToMany annotation lets you mark fields to have a many-to-many relationship. The default behavior of the annotation is to populate the field after mapping the entity object, create/update the associated entities, and link the relations on the join table. The annotation uses the join table transparently, meaning you don't need to create an entity type for the join table on your codebase.

You can use the annotation on both sides of the relationship to achieve a bidirectional association. Many-to-many relationships keep track of their associations in a separate join table, so updates to one entity do not impact the others. There's also a different use case where the associated entities already exist, and you only need to link them together without changing the existing entities. You can set linkOnly = true in the annotation parameter to achieve said behavior. However, link-only associations will fail if the linked entity does not exist when you create/update the current entity.

Important

The annotation only supports List<T> types for now. We'll consider support for more collection types as the use cases present.

Example

Given the following tables present in your database:

CREATE TABLE author(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  name varchar(255) NOT NULL
);

CREATE TABLE book(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  created_at timestamp(9) NOT NULL DEFAULT localtimestamp(),
  title varchar(255) NOT NULL
);

CREATE TABLE author_book(
  id uuid NOT NULL DEFAULT random_uuid() PRIMARY KEY,
  author_id uuid NOT NULL,
  book_id uuid NOT NULL,
  FOREIGN KEY (author_id) REFERENCES author ON DELETE CASCADE,
  FOREIGN KEY (book_id) REFERENCES book ON DELETE CASCADE,
  UNIQUE (author_id, book_id)
);

You can use the @ManyToMany annotation in both Author and Book entities:

@With
public record Author(
  @Id UUID id,
  LocalDateTime createdAt,
  String name
  @ManyToMany List<Book> books
) {

  // implementation omitted...
}

@With
public record Book(
  @Id UUID id,
  LocalDateTime createdAt,
  String title
  @ManyToMany List<Author> authors
) {

  // implementation omitted...
}

By default, the annotations will sort the populated list of books/authors by the created_at column in a descendant direction. You can customize the sorting column and direction using the annotation parameters.

Handling orphans

Usually, many-to-many relationships are not mutually exclusive to each other, meaning that one can exist without the other even when not linked by the join table. In this context, "orphans" refers to all entities no longer associated with the current entity. By default, the @ManyToMany annotation will only delete the links to the "orphan" entities in the join table. Similarly to @OneToMany, if you want to remove all associations, you can pass an empty list to the field and update the entity. If you don't want to modify the children upon update, you can set the field to null to tell the annotation to ignore the field.

However, there's also the case where you manage the associations from one side of the relationship. In this case, you may want the annotation to delete "orphan" entities for you instead of only removing their link. You can achieve said behavior by setting deleteOrphans = true in the annotation parameters.

Projections

Spring Data allows us to use Entity Projections right out of the box--there's no need to add anything to the projected type. However, Spring R2DBC Relationships needs the complete entity information so the relationship processors can obtain accurate metadata hidden in the projection.

Using projections on relationship types, you can annotate the type with @ProjectionOf(..) and provide the projected type's value parameter. For example, given a Person entity that contains a large number of properties, you can create a projection named PersonMin with minimum properties:

@With
@ProjectionOf(Person.class)
public record PersonMin(
  UUID id,
  String firstName,
  String lastName,
  Integer age
) {

  // implementation omitted...
}

API Reference

You can find more details of the API in the latest Javadocs. If you need the Javadocs of an older version, you can use the full URL as shown below, replacing x.y.z with the version you want to see:

https://javadoc.io/doc/io.github.joselion/spring-r2dbc-relationships/x.y.z

Contributing

Something's missing?

Suggestions are always welcome! Please create an issue describing the request, feature, or bug. Opening meaningful issues is as helpful as opening Pull Requests.

Contributions

Pull Requests are very welcome as well! Please fork this repository and open your PR against the main branch.

License

MIT License

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

README.md

README.md

Spring R2DBC Relationships

Features

Table of Contents

Install

Requirements

Usage

@OneToOne

Example

@OneToMany

Handling orphans

Example

Handling orphans

@ManyToOne

Example

@ManyToMany

Example

Handling orphans

Projections

API Reference

Contributing

Something's missing?

Contributions

License

Files

README.md

Latest commit

History

README.md

File metadata and controls

Spring R2DBC Relationships

Features

Table of Contents

Install

Requirements

Usage

@OneToOne

Example

@OneToMany

Handling orphans

Example

Handling orphans

@ManyToOne

Example

@ManyToMany

Example

Handling orphans

Projections

API Reference

Contributing

Something's missing?

Contributions

License