[sqlalchemy] (De)serialize Association Object

2015-09-27 Thread Ludovic Pessot
I'm building a Flask app and created an Association Table as described in the docs and now would like to build an API with POST and GET methods. However, I can't manage to serialize and deserialize the Association Object. Tried to tinker with Marshmallow but it gives me an error stating that I

Re: [sqlalchemy] DB sync on application level

2015-09-27 Thread Jonathan Vanasco
I don't like this idea. but... You should familiarize yourself with two-phase commits. sqlalchemy supports this on mysql and postgresql. basically everyone votes to commit yay/nay in phase 1, then a commit is made (if unanimous yays) or rollback executed in phase 2. -- You received this

Re: [sqlalchemy] DB sync on application level

2015-09-27 Thread Cornelinux K
Hi Michael, thanks for your response. At least it shows me, that obviously this seems to be no common idea - mostly known as a bad idea. I do not want to sync anything on a database level, but on a logical level. It is not important, that entries have the same index. In theory it would not

Re: [sqlalchemy] DB sync on application level

2015-09-27 Thread Mike Bayer
On 9/27/15 5:17 PM, Cornelinux K wrote: Hi Michael, thanks for your response. At least it shows me, that obviously this seems to be no common idea - mostly known as a bad idea. I do not want to sync anything on a database level, but on a logical level. It is not important, that entries

Re: [sqlalchemy] Capturing query parameters

2015-09-27 Thread George V. Reilly
On Saturday, September 19, 2015 at 8:14:31 AM UTC-7, Michael Bayer wrote: > > > > On 9/18/15 7:58 PM, George Reilly wrote: > > > Thanks for the prompt answer. I tried after_cursor_execute, but it didn't > really help as I just got a tuple of the values, without a clear way to > associate them

[sqlalchemy] SQLTap 0.3.10 released

2015-09-27 Thread George V. Reilly
SQLTap is a very useful library that helps you in profiling SQLAlchemy queries. It helps you understand where and when SQLAlchemy issues queries, how often they are issued, how many rows are returned, and if you are issuing queries with duplicate parameters. The last two are new in tonight's