diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-05-09 18:57:40 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-05-09 18:57:40 +0000 |
| commit | cbabd91c21eb6fdee4786a3cd3195113fb0b8bed (patch) | |
| tree | e4155418aac211c6a1dc34086b8929e36e4fc56a /doc/build/content/ormtutorial.txt | |
| parent | 0bbb0e9b572929c05c5c0b3b0e22ffdeda29ad59 (diff) | |
| download | sqlalchemy-cbabd91c21eb6fdee4786a3cd3195113fb0b8bed.tar.gz | |
added query.subquery() as shorthand for query.statement.alias()
Diffstat (limited to 'doc/build/content/ormtutorial.txt')
| -rw-r--r-- | doc/build/content/ormtutorial.txt | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/build/content/ormtutorial.txt b/doc/build/content/ormtutorial.txt index f784d57cf..efbe4c951 100644 --- a/doc/build/content/ormtutorial.txt +++ b/doc/build/content/ormtutorial.txt @@ -674,11 +674,11 @@ Using the `Query`, we build a statement like this from the inside out. The `sta {python} >>> from sqlalchemy.sql import func - >>> stmt = session.query(Address.user_id, func.count('*').label('address_count')).group_by(Address.user_id).statement.alias() + >>> stmt = session.query(Address.user_id, func.count('*').label('address_count')).group_by(Address.user_id).subquery() -The `func` keyword generates SQL functions, and the `alias()` method on `Select` (the return value of `query.statement`) creates a SQL alias, in this case an anonymous one which will have a generated name. +The `func` keyword generates SQL functions, and the `subquery()` method on `Query` produces a SQL expression construct representing a SELECT statement embedded within an alias (it's actually shorthand for `query.statement.alias()`). -Once we have our statement, it behaves like a `Table` construct, which we created for `users` at the top of this tutorial. The columns on the statement are accessible through an attribute called `c`: +Once we have our statement, it behaves like a `Table` construct, such as the one we created for `users` at the start of this tutorial. The columns on the statement are accessible through an attribute called `c`: {python} {sql}>>> for u, count in session.query(User, stmt.c.address_count).outerjoin((stmt, User.id==stmt.c.user_id)): # doctest: +NORMALIZE_WHITESPACE |
