How to apply soft-delete for a node deletion?

uralbash / sqlalchemy_mptt

SQLAlchemy nested sets mixin (MPTT)

http://sqlalchemy-mptt.readthedocs.io

MIT License

196 stars 32 forks source link

How to apply soft-delete for a node deletion? #66

Open okaprinarjaya opened 4 years ago

okaprinarjaya commented 4 years ago

Hi,

I need to apply soft-delete when doing a node deletion. I will use an extra field named: deleted with its value 1 char Y for the row is soft-deleted and 1 char N forr the row is not soft-deleted.

I don't want to hard delete using real SQL DELETE command. because hard / real DELETE will make worst performance in database.

Please Enligthenment

Thank you