Spring Boot JPA Soft Deletes with Spring Data Rest

Simple example of how to use custom JPA repository implementation for soft deletes functionality.

List of Things

• Service layer
• Project Lombok
• Controller layer
• Repository layer
• Entity Validation
• JSON Configuration
• usage of JPA Specifications
• generic soft delete functionality
• custom JPA Repository implementation
• generic schedule soft delete functionality
• association table entities are with @IdClass
• Spring Data Rest endpoints merged with custom controller endpoints
• generic methods to use in repositories (see the methods from the interface below)
• on creation of new entity check whether a soft deleted version already exists in the database
• BackendIdConverter for every association entity so you can use Spring Data REST to manipulate entity
  • http GET localhost:8080/roleUsers/1_1
  • http DELETE localhost:8080/roleUsers/1_1 // TODO
  • http PATCH localhost:8080/roleUsers/1_1 otherField="field"
• use @UniqueConstraint inside @Table to define unique constraints (MUST MATCH DATABASE SCHEMA)
  • @Table(uniqueConstraints = { @UniqueConstraint(columnNames = { "single" }) })
  • @Table(uniqueConstraints = { @UniqueConstraint(columnNames = { "single1" }), @UniqueConstraint(columnNames = { "single2" }) })
  • @Table(uniqueConstraints = { @UniqueConstraint(columnNames = { "double1", "double2" }) })
• CustomRepositoryRestConfigurerAdapter to register the BackendIdConverters and expose the ID fields for all entities
• integration of the entity check functionality on create with Spring Data REST, the check is done on Spring Data REST repository endpoints POST methods

TODO

• write tests
• write examples and usage
• write documentation about everything
• make generic repository methods accessable trough Spring Data Rest endpoints

Notes

• Because of using Lombok, mapped entities should be excluded from the toString() method
  • check the User entity for example

  @ToString(exclude = { "roles" })
  

Generic Repository Methods

long countActive();

T findOneActive(ID id);

boolean existsActive(ID id);

Iterable<T> findAllActive();

Iterable<T> findAllActive(Sort sort);

Page<T> findAllActive(Pageable pageable);

Iterable<T> findAllActive(Iterable<ID> ids);

void softDeleteAll();

void softDelete(ID id);

void softDelete(T entity);

void softDelete(Iterable<? extends T> entities);

void scheduleSoftDelete(ID id, LocalDateTime localDateTime);

void scheduleSoftDelete(T entity, LocalDateTime localDateTime);

Entity mapping examples

//

Example HTTP calls

//

In Short

In order to use this, we first must create our CustomJpaRepositoryFactoryBean and enable that in our main class using:

@EnableJpaRepositories(repositoryFactoryBeanClass = CustomJpaRepositoryFactoryBean.class)

This returns our custom SoftDeletesRepositoryImpl instead of the default SimpleJpaRepository.

There's a BaseEntity which all of our entities must extend, that contains the necessary field to enable us to use this functionality.

Now for every repository interface, instead of extending the JpaRepository we extend our SoftDeletesRepository (UserRepository example).

Installing

Just clone or download the repo and import it as an existing maven project.

You'll also need to set up Project Lombok or if you don't want to use this library you can remove the associated annotations from the code and write the getters, setters, constructors, etc. by yourself.

License

This project is licensed under the MIT License - see the LICENSE file for details