here’s a patch: http://www.sqlalchemy.org/trac/ticket/2877
it’s quite short. I just don’t like the current contract of SelectBase, which has many methods that don’t apply here, so might want to rework the base classes. On Nov 22, 2013, at 5:06 AM, Chris Withers <ch...@simplistix.co.uk> wrote: > On 21/11/2013 19:25, Michael Bayer wrote: >> >> hoping you’ve already figured it out but otherwise I’m not entirely >> following what the larger query you’re looking for would look like. I >> doubt you need text() for anything. > > Okay, pseudo code that doesn't work: > > positions = something(""" > select instrument_id, sum(quantity) as quantity > from transaction where > account_id = :account_id and > timestamp < :dt and > group by instrument_id > having sum(quantity) != 0 > """, dict(dt=date(2013, 1, 1), account_id='foo')).cte('positions') > > print session.query(Instrument, positions.c.quantity)\ > .select_from(Instrument)\ > .join(positions, Instrument.id=positions.instrument_id)\ > .all() > > (this latter query will likely have more stuff in it, not sure I used > .select_from(...).join(...) correctly either ;-) > > Hope that illustrates what I'm after... > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out.
signature.asc
Description: Message signed with OpenPGP using GPGMail