How to implement logical delete (SoftDelete) in ActiveJDBC?

[logue]

How do I implement a logical delete that flags a record for deletion, rather than physically deleting the record from the table, like Eloquent's SoftDelete trait?

If implemented normally, the validator defined in the model will running.

[ipolevoy]

We do not have this feature in the framework directly. However, it does not seem hard to implement at the application level, for instance:

1. Add column deleted_at to PEOPLE table

2. Write a model class:

class Person extends Model{

   boolean isDeleted(){
       return get("deleted_at") != null;
   }

   void delete(){
       set("deleted_at", new Date());
       saveIt();
    }
}

after that, add this to other queries: "...where deleted_at is NULL"

as you can see, not that hard. However, adding this feature directly to the framework is a good idea.

[logue]

It went well.
Thank you very much.

Since it is a boolean type, exactly isn't it.

public boolean delete() {
    set("deleted_at", new Date());
    return save();
}

[ipolevoy]

sure, this works. Just keep in mind that save() and saveIt() are not the same.