[sqlalchemy] Re: Generic "soft delete" implementation

The FAQ http://docs.sqlalchemy.org/en/latest/faq/sessions.html#how-do-i-make-a-query-that-always-adds-a-certain-filter-to-every-query points to an example in the wiki: https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/PreFilteredQuery -- SQLAlchemy - The Python SQL Toolkit and Object R

[sqlalchemy] Generic "soft delete" implementation

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

Re: [sqlalchemy] Abstract Table Concrete Inheritance. Could not determine join condition between parent/child tables

On 05/15/2017 09:27 PM, Никита Крокош wrote: So, how should i do if I need many encumbrances for every cadastral object (flat.encumrances, building.encumbrances, ...etc). If I get it correctly, I need something like: class iCadastralObject(Base): __abstract__ =True def __init__(se

Re: [sqlalchemy] jsonb_set in PostgreSQL 9.5+

Thanks a lot for the explanation, it's all clear now! On 15 May 2017 at 18:56, mike bayer wrote: > > > On 05/15/2017 11:56 AM, Zsolt Ero wrote: >> >> I might not be understanding something, but for me there are two >> different concepts here: >> >> map_obj = dbsession.query(Map).get(id_) >> >> is