Re: [sqlalchemy] too many SQL variables in in_

2014-09-13 Thread pyArchInit ArcheoImagineers
Il giorno giovedì 11 settembre 2014 18:39:24 UTC+2, Jonathan Vanasco ha scritto: i once thought about extending SqlAlchemy to handle this issue behind the scenes, but each database treats `IN()` differently. for example: oracle maxes out at a number of elements, while mysql maxes out based

Re: [sqlalchemy] too many SQL variables in in_

2014-09-13 Thread Wichert Akkerman
On 13 Sep 2014, at 11:25, pyArchInit ArcheoImagineers pyarchi...@gmail.com wrote: Il giorno giovedì 11 settembre 2014 18:39:24 UTC+2, Jonathan Vanasco ha scritto: i once thought about extending SqlAlchemy to handle this issue behind the scenes, but each database treats `IN()`

Re: [sqlalchemy] too many SQL variables in in_

2014-09-13 Thread pyArchInit ArcheoImagineers
I had a mystical appearence!!! I will put in a dictionary the parameters of searching used in the GUI. If I would to sort the record, the script will re-do the search, which at this time will use only a few parametrs, and I'll put an ORDER_BY in the query. The script will write dinamically as

Re: [sqlalchemy] Deferring a many-to-many mapping

2014-09-13 Thread Michael Bayer
On Sep 12, 2014, at 8:46 PM, Brian the Lion brian.ro...@gmail.com wrote: Hi all, I am having trouble deferring a many-to-many mapping. I just had a couple of questions related there-to: (1) The most visible implementations of vanilla many-to-many mappings seem to use

Re: [sqlalchemy] SQLAlchemy connection errors

2014-09-13 Thread Matthijs Blaas
@Jonathan Vanasco: i have no input on the issues michael identified. but i'm curious about a sqlalchemy event somehow not firing. which transaction event were you using? after_begin or after_transaction_create ? I used the after_begin event to set the search_path, but moved it into the