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 > <la...@rational-it.com<javascript:>> > 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 > > > 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 > > > Hope that helps, > > Simon > -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.