Dear experts, All the entity tables in my data model have an "is_deleted" column. The many-to-many mapping tables, however, do not. I was wondering if it is possible to implement a system-wide, generic soft delete mechanism, specifically focused on data retrieval where any entity records that have been marked as deleted will automatically be excluded from any SQLAlchemy select statements being generated. This should include specific queries as well as automatic selects due to pre-defined table relationships.
Is there an easy way to implement this e.g. by sub-classing Base or Query? I'm still new to SQLAlchemy, so any advice would be much appreciated. Thank you and kind regards, Jaco -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.