OK, never mind |-)
should be:
q = q.with_entities(Report.number)
q = q.add_columns(Report.number)
sry
On Mon, Sep 9, 2013 at 2:43 PM, lars van gemerden <[email protected]>wrote:
> Ok, i've tried both (and each separately), as in:
>
> r1 = Report(number = 1, title = "The Bird")
> r2 = Report(number = 2, title = "The Bucket")
> session.add_all([r1, r2])
> session.commit()
> q = self.session.query(Report.title)
> q.with_entities(Report.number)
> q.add_columns(Report.number)
> print q.all()
>
> printing:
>
> [(u'The Bird',), (u'The Bucket',)]
>
> what i would like to see is:
>
> [(u'The Bird', 1), (u'The Bucket', 2)]
>
> or something similar.
>
> Cheers, Lars
>
> On Wednesday, September 4, 2013 1:24:28 PM UTC+2, Simon King wrote:
>
>> On Wed, Sep 4, 2013 at 12:05 PM, lars van gemerden <[email protected]>
>> wrote:
>> > I think i must be reading over something, but:
>> >
>> > is there a way to delay the selection of attributes in a query;
>> something
>> > like
>> >
>> > >>> session.query(Person).filter(**Person.age >
>> > 100).select(Person.name).**first()
>> >
>> > >>> (u"Ancient Bob",)
>> >
>>
>> I'm not sure quite what you mean, but the with_entities method of
>> Query would seem to be the closest to your example:
>>
>> http://docs.sqlalchemy.org/en/**rel_0_8/orm/query.html#**
>> sqlalchemy.orm.query.Query.**with_entities<http://docs.sqlalchemy.org/en/rel_0_8/orm/query.html#sqlalchemy.orm.query.Query.with_entities>
>>
>> I assume you know you can also do this:
>>
>> session.query(Person.name).**filter(Person.age > 100).first()
>>
>> You can also defer certain columns so that they will be loaded lazily:
>>
>> http://docs.sqlalchemy.org/en/**rel_0_8/orm/mapper_config.**
>> html#deferred-column-loading<http://docs.sqlalchemy.org/en/rel_0_8/orm/mapper_config.html#deferred-column-loading>
>>
>> Hope that helps,
>>
>> Simon
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "sqlalchemy" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/sqlalchemy/7hA4UZV8uaA/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
====================================
Lars van Gemerden
[email protected]
+31 6 26 88 55 39
====================================
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
