[sqlalchemy] Multi-Tenancy with dynamic tables and relationships

2016-12-05 Thread John Kida
I have a multi-tenant (postgresql schema) system which supports the ability for creating custom tables and relationships. However each schema actually consists of the exact same tables. User can dynamically define new tables and relationships by saving information into TableMeta, FieldMeta

[sqlalchemy] UnicodeDecodeError when accessing PickleType column

2016-12-05 Thread Adam Pletcher
I'm upgrading one of our tools from Python 2.6.4 (SQLAlchemy 0.9.2) to Python 3.4.1 (SQLAlchemy 1.1.4), and hitting an error when accessing a PickleType column in one of the ORM classes. This is on MS SQL Server 2012, connecting with pyodbc, and client code running on Windows 8.1 64-bit. This

Re: [sqlalchemy] Core post_commit

2016-12-05 Thread Corwin Tanner
Then, in my case, I will have to use an alternative method where my code has control of the transaction. Thank you for the speedy reply. On Monday, December 5, 2016 at 11:15:12 AM UTC-6, Mike Bayer wrote: > > > > On 12/05/2016 11:10 AM, Corwin Tanner wrote: > > I need to be able to execute some

Re: [sqlalchemy] Core post_commit

2016-12-05 Thread mike bayer
On 12/05/2016 11:10 AM, Corwin Tanner wrote: I need to be able to execute some code upon the successful commit of a transaction. In this instance, I do not control the transaction and will not be the one calling commit. I tried listening to the commit event on the Connection object, but this do

[sqlalchemy] Core post_commit

2016-12-05 Thread Corwin Tanner
I need to be able to execute some code upon the successful commit of a transaction. In this instance, I do not control the transaction and will not be the one calling commit. I tried listening to the commit event on the Connection object, but this does not give the kind of guarantees I need as