On Nov 21, 2013, at 6:32 AM, Chris Withers <[email protected]> wrote:
>
> Yep, in fact ended up with:
>
> positions = session.query(Part.instrument_id,
> func.sum(Part.quantity).label("quantity"))\
> .filter((Part.account_id=='td') & (Part.timestamp < date(2013, 11, 1)))\
> .group_by(Part.instrument_id)\
> .having(func.sum(Part.quantity)!=0).cte('positions')
>
> ...which left me wondering, if I had the query asL
>
> query = """
> 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
> """
>
> How could I combine that string with values for account_id and dt into a cte?
> I'm expecting something involving text(), but I can't figure out the right
> incantation…
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.
signature.asc
Description: Message signed with OpenPGP using GPGMail
