Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2013-02-22 Thread Femi Anthony
Hi, I know this is a long time, but did you ever get SQLAlchemy to successfully work with Vertica ? Please let me know as I am interested in doing the same. Thanks, Femi Anthony On Tuesday, February 2, 2010 11:37:15 AM UTC-5, Bo wrote: Hi Michael, Thanks for the tip on dialect creation; I

Re: [sqlalchemy] is there a more proper way to chain dynamic or clauses ?

2013-02-22 Thread Simon King
On Fri, Feb 22, 2013 at 1:31 AM, Jonathan Vanasco jonat...@findmeon.com wrote: basd on a bunch of error messages, this example works... criteria = ( ('male',35),('female','35) ) query = session.query( model.Useraccount ) ands = [] for set_ in criteria :

[sqlalchemy] Re: is there a more proper way to chain dynamic or clauses ?

2013-02-22 Thread Jonathan Vanasco
thanks. i was really focused on the query.filter(sa.or_(*ands)) concept. that's what seemed kind of weird to me. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [sqlalchemy] is there a more proper way to chain dynamic or clauses ?

2013-02-22 Thread Conor
On 02/21/2013 07:31 PM, Jonathan Vanasco wrote: basd on a bunch of error messages, this example works... criteria = ( ('male',35),('female','35) ) query = session.query( model.Useraccount ) ands = [] for set_ in criteria : ands.append(\

Re: [sqlalchemy] is there a more proper way to chain dynamic or clauses ?

2013-02-22 Thread Eric Rasmussen
Using sa.tuple_ looks like the nicest solution here, but back to your original question about building or clauses, expressions built with or_ can be passed as arguments to or_ to build more complex expressions. One simple iterative way to do this is: clauses = or_() # empty starting value