使用Spring JPA处理软删除 [英] Handling soft-deletes with Spring JPA

问题描述

我有一张桌子 Stuff 定义为......

I have a table Stuff defined as...

id, <fields>..., active

有效是软删除标志，始终是 1 或 0 。从长远来看，这可能会偏向于历史表。

Active is the soft-delete flag and is always 1 or 0. Long term this may go away in favor of a historical table.

public interface StuffRepository extends JpaRepository<StuffEntity, Long> {} 

在代码中，我们总是使用活动记录。有没有办法让Spring始终为为此存储库生成的查询附加 active = 1 条件？或者更理想的是允许我扩展用于生成查询的语法？

In code, we always use active records. Is there any way to get Spring to always append an active=1 condition to queries generated for this repository? Or more ideally allow me to extend the grammar used to generate the queries?

我知道我可以创建命名 @queues 无处不在，但后来我失去了生成查询的便利性。我还想避免使用活动方法来污染接口。

I understand that I can create named @queues everywhere but then I lose the convenience of the generated queries. I also want to avoid polluting the interface with "active" methods.

如果重要的话，我使用Hibernate 4.2作为我的JPA实现。

I am using Hibernate 4.2 as my JPA implementation if that matters.

推荐答案

这是一个老问题，你可能已经找到了答案。但是，所有Spring / JPA / Hibernate程序员都在那里寻求答案 -

This is an old question, and you probably already found the answer. BUT, for all the Spring/JPA/Hibernate programmers out there seeking for answer -

假设你有一个实体Dog：

Say you have an entity Dog:

 @Entity
 public class Dog{

 ......(fields)....        

 @Column(name="is_active")
 private Boolean active;
 }

和存储库：

public interface DogRepository extends JpaRepository<Dog, Integer> {
} 

您需要做的就是在实体级别添加@Where注释，结果：

All you need to do is add the @Where annotation on the entity level, resulting:

@Entity
@Where(clause="is_active=1")
public class Dog{

......(fields)....        

@Column(name="is_active")
private Boolean active;
}

存储库执行的所有查询都会自动过滤掉非活动状态 行。

All the queries performed by the repository will automatically filter out the "non-active" rows.

这篇关于使用Spring JPA处理软删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！