Open WanWizard opened 12 years ago
Note that this must be completely transparent for the application.
The column used in the table to mark the delete state should not be considered a valid column name from the applications point of view. You should not be able to select() it. It should be added as a where() filter to every interaction with every table that has this feature defined. If you set it (as an object property) it should be ignored when compiling SQL. It must be completely hidden.
Got a +1 from @ingdiaz and @tarciozemel
In certain environments, regulations do not allow you to really delete any information.
To facilitate this, DataMapper needs an option to be able to mark records as deleted, and to "hide" these deleted records from every interaction you have with the database.