Maybe
def test():
rows = db(db.Table1.foo==db.Table2.foo).select(db.Table1.foo.with_alias(
'foo'), db.Table2.bar.with_alias('blah'))
for row in rows:
print row.foo, row.blah
return locals()
should work.
Another way - if you can rewrite tables definitions - is to use the "rname"
field value. From the web2py book
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?#Field-constructor
>
> *rname* provides the field was a "real name", a name for the field known
> to the database adapter; when the field is used, it is the rname value
> which is sent to the database. *The web2py name for the field is then
> effectively an alias*.
So with
db.define_table('Table2', Field('blah', 'string', rname="bar")
the query becomes
db(db.Table1.foo==db.Table2.foo).select(db.Table1.foo, db.Table2.blah)
If you want alias fields in a query without joins you could write
rows = db(db.Table2.id>0).select('bar AS blah')
Il giorno lunedì 28 agosto 2017 08:50:20 UTC+2, Brendan Barnwell ha scritto:
>
> On Monday, July 31, 2017 at 1:25:31 PM UTC-7, Paolo Caruccio wrote:
>>
>> Maybe the web2py book could help you:
>>
>>
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=with_alias#Self-Reference-and-aliases
>>
>>
> That appears to only be talking about using aliases for tables, and
> specifically to be able to create and query tables that reference one
> another. What I'm describing is conceptually much simpler than that: I
> just want to take a query that already works and give my own names to the
> columns of the result.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
