Re: [sqlalchemy] Python 3 and mysql

On 4/5/15 1:49 PM, Thomas Tanner wrote: > Hello, > > which Python 3 compatible MySQL driver is recommended for SA? > I couldn't find a single package which both installs cleanly with pip > and passes the SA test suite. I've tried mysqlclient, mysqlconnector, > cymysql, oursql on OSX. Right now t

[sqlalchemy] Python 3 and mysql

Hello, which Python 3 compatible MySQL driver is recommended for SA? I couldn't find a single package which both installs cleanly with pip and passes the SA test suite. I've tried mysqlclient, mysqlconnector, cymysql, oursql on OSX. cheers, -- You received this message because you are subscribe

Re: [sqlalchemy] Eager loading of filtered children

Oh, thank you so much for such an elaborate reply! The "groupby method" totally suits me. On Sunday, April 5, 2015 at 6:17:35 PM UTC+3, Michael Bayer wrote: > > > > On 4/5/15 8:46 AM, Yegor Roganov wrote: > > Given the User-Addresses schema as in the docs, I need to select all users > along

Re: [sqlalchemy] Eager loading of filtered children

On 4/5/15 8:46 AM, Yegor Roganov wrote: > Given the User-Addresses schema as in the docs, I need to select all > users along with only those email addresses which end with "@gmail.com". > The question is how do I group these filtered emails by user? > Apparently I can use `contains_eager` to writ

[sqlalchemy] Eager loading of filtered children

Given the User-Addresses schema as in the docs, I need to select all users along with only those email addresses which end with "@gmail.com". The question is how do I group these filtered emails by user? Apparently I can use `contains_eager` to write something like this: session.query(User).