using add_column does not seem to work the same as including both
items in the query [like below]
query = meta.Session.query(Article,
comment_count_subquery.c.article_comment_count)
it does not return an iterable result
is there any way to add subqueries to the query after the query has
been created, that replicates the functionality you would expect if
you had included both items in the initial query() call?
On Jul 15, 9:05 am, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> The Devil's Programmer wrote:
>
> > I can do this -
>
> > comment_count_subquery = meta.Session.query(Comment.article_id,
> > func.count('*').label('article_comment_count')).group_by
> > (Comment.article_id).subquery()
> > query = meta.Session.query(Article,
> > comment_count_subquery.c.article_comment_count)
>
> > but when I do it like this -
>
> > query = meta.Session.query(Article)
> > comment_count_subquery = meta.Session.query(Comment.article_id,
> > func.count('*').label('article_comment_count')).group_by
> > (Comment.article_id).subquery()
> > query.add_entity(comment_count_subquery.c.article_comment_count)
>
> you'd want "add_column()" to add a column after the fact to a Query.
> add_entity() and add_column() are both a little old school.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
