Re: [sqlalchemy] Can't add unnamed column to column collection when defining UniqueConstraint

2019-01-08 Thread Riccardo Magliocchetti
Hello Mike, Il 08/01/19 19:00, Mike Bayer ha scritto: On Tue, Jan 8, 2019 at 12:40 PM Riccardo Magliocchetti wrote: Hello, I'd like to implement soft delete so I have to take into account when creating constraints the softdelete boolean column. The trick i want to implement is to get null

[sqlalchemy] Can't add unnamed column to column collection when defining UniqueConstraint

2019-01-08 Thread Riccardo Magliocchetti
Hello, I'd like to implement soft delete so I have to take into account when creating constraints the softdelete boolean column. The trick i want to implement is to get null for the column when the row is supposed to be deleted. When creating the index by hand in SQL it works just nice but in

Re: alembic autogenerated migrations do not see current tables

2018-11-27 Thread Riccardo Magliocchetti
include_schemas#alembic.runtime.environment.EnvironmentContext.configure.params.include_schemas > > > > On Wed, Nov 21, 2018 at 11:49 AM Riccardo Magliocchetti > > wrote: > > > > Hello, > > > > for some reason at each migration alembic does not find any table or > index and > > crea

Re: alembic vs system=True columns

2018-11-06 Thread Riccardo Magliocchetti
ek%2Falembic%2Fissues%2F515%2Fsystem-true-not-generated-for-column=D=1=AFQjCNHl8pc8qFcNHFFEcHTwrEWF415Qug> > > > and here is a patch to resolve: > > https://gerrit.sqlalchemy.org/#/c/zzzeek/alembic/+/910 > > On Wed, Oct 31, 2018 at 11:49 AM Riccardo Magliocchetti > >

Re: alembic vs system=True columns

2018-10-31 Thread Riccardo Magliocchetti
Il 31/10/18 16:32, Mike Bayer ha scritto: On Wed, Oct 31, 2018 at 11:00 AM Riccardo Magliocchetti wrote: Hello, we'd like to use Postgresql xmin column for optimistic concurrency, so we declared the column as: xmin = Column("xmin", Integer, system=True, server_default=Fe

alembic vs system=True columns

2018-10-31 Thread Riccardo Magliocchetti
n is added to the operations so the migrations fails. I've grepped the alembic source code for "system" and haven't found something sensible so wondering if alembic should check if the system attribute of the column is set and if so ignoring the column. Thanks, Riccardo Magliocchet