Soft Delete

Soft delete is essentially an update operation. Instead of physically removing a record, it marks a boolean field (deleted) or a status field (status) as deleted.

Implementation

java

@Erupt(
        name = "Soft Delete",
        filter = @Filter("deleted = false"),
)
@SQLDelete(sql="update test set deleted = true, deleteTime = now() where id = ?")
@Table(name = "test")
@Entity
public class Test extends BaseModel {

    @EruptField(
            views = @View(title = "xxx"),
            edit = @Edit(title = "xxx")
    )
    private String name;
    
    private Date deleteTime;
    
    private Boolean deleted = false;
    
}

How It Works

The deleted field acts as the soft-delete flag.
The @SQLDelete annotation overrides the default delete SQL.
The filter attribute filters out deleted records in all queries.

Contributors

YuePeng

Claude Fable 5.1

Changelog

Last edited 4 minutes ago

View full history

Soft Delete ​

Implementation ​

How It Works ​

Contributors

Changelog

Soft Delete

Implementation

How It Works