Cool!
That is what I was looking for.
Thank you,
Ladislav Lenart
On 24.10.2012 20:00, Michael Bayer wrote:
with_entities() will give you this:
http://docs.sqlalchemy.org/en/rel_0_7/orm/query.html#sqlalchemy.orm.query.Query.with_entities
On Oct 24, 2012, at 11:21 AM, Ladislav Lenart
Hello.
Suppose I have the following query:
def people_older_than(age):
q = session.query(Person).order_by(Person.name)
q = q.filter(Person.age age)
return q
It returns a subset of Person instances. How can I augment the query so it
returns only their count? I.e.:
def
On Wed, Oct 24, 2012 at 3:59 PM, Ladislav Lenart lenart...@volny.cz wrote:
Hello.
Suppose I have the following query:
def people_older_than(age):
q = session.query(Person).order_by(Person.name)
q = q.filter(Person.age age)
return q
It returns a subset of Person instances.
Oh, you are right of course. This works, however I would still like to transform
the query programmatically (mainly out of curiosity) from
q = session.query(Person).order_by(Person.name)
q = q.filter(Person.age age)
return q
to
q = session.query(func.count(Person.id))
with_entities() will give you this:
http://docs.sqlalchemy.org/en/rel_0_7/orm/query.html#sqlalchemy.orm.query.Query.with_entities
On Oct 24, 2012, at 11:21 AM, Ladislav Lenart wrote:
Oh, you are right of course. This works, however I would still like to
transform
the query programmatically