Re: [sqlalchemy] Creating a dynamic/new column using Text selects?

On Thursday, March 22, 2018 at 4:27:18 PM UTC-4, Mike Bayer wrote: > > > probably just make a fake column:column('counted') see what that > does > > Bingo. Thanks! counted_column = sqlalchemy.Column('counted') stmt = sqlalchemy.text('''SELECT...''') stmt = stmt.columns(Foo.id,

Re: [sqlalchemy] Creating a dynamic/new column using Text selects?

On Thu, Mar 22, 2018 at 4:16 PM, Jonathan Vanasco wrote: > I have a large and complex analytics query that I'd like to keep in raw SQL. > It generally looks like this: > > SELECT foo.id, >foo.name, >tally.counted > FROM(... >

[sqlalchemy] Creating a dynamic/new column using Text selects?

I have a large and complex analytics query that I'd like to keep in raw SQL. It generally looks like this: SELECT foo.id, foo.name, tally.counted FROM(... ...) tally JOIN foo ON tally.foo_id = foo.id WHERE tally.counted > 1 ORDER BY

Re: [sqlalchemy] Hi, Why doc not sync pdf version?

the PDF generation was very buggy and never worked correctly.If you want to work on it, the sphinx source is all there, if it were well-maintained I could add it back as part of the documentation generation (which at the time was on readthedocs but has since been moved to my own scripts

[sqlalchemy] Hi, Why doc not sync pdf version?

I remember SQLAlchemy has pdf in early version, But I can't found now. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See