ok, the fix is here https://github.com/web2py/pydal/pull/211
Paolo On Tuesday, June 9, 2015 at 10:44:59 AM UTC+2, [email protected] wrote: > > Lovely! I was just about to post this problem. > > On Tuesday, 9 June 2015 07:56:35 UTC+1, Paolo Valleri wrote: >> >> I see the problem now, thanks for pointing it out. >> I'll post a fix later today. >> >> Paolo >> >> 2015-06-08 22:11 GMT+02:00 Donatas Burba <[email protected]>: >> >>> This is failing example: >>> >>> db=DAL('sqlite:memory') >>> >>> db.define_table('tt', >>> Field('vv', 'integer'), >>> Field.Virtual('x', lambda row: row.tt.vv * 10)) >>> >>> db.define_table('tt2', >>> Field('ttref', 'reference tt'), >>> Field('vv2', 'integer')) >>> >>> tt1 = db.tt.insert(vv='1') >>> tt2 = db.tt.insert(vv='3') >>> db.tt2.insert(ttref=tt1, vv2='3') >>> db.tt2.insert(ttref=tt2, vv2='4') >>> >>> records = db(db.tt).select( >>> db.tt.ALL, db.tt2.ALL, >>> join=[db.tt2.on(db.tt2.ttref == db.tt.id)] >>> ) >>> for r in records: >>> print r >>> >>> Result: >>> >>> <Row {'tt2': {'ttref': 1L, 'id': 1L, 'vv2': 3L}, 'tt': {'id': 1L, 'vv': >>> 1L}}> >>> <Row {'tt2': {'ttref': 2L, 'id': 2L, 'vv2': 4L}, 'tt': {'id': 2L, 'vv': >>> 3L}}> >>> >>> As you can see virtual field 'x' (in table 'tt') is missing. As I >>> understand this occurs when selecting records from more than one table. In >>> my case (with PostgreSQL) every time I use db(...).select(db.table.ALL, >>> TOTAL_ROWS, ...) where TOTAL_ROWS = 'COUNT(*) OVER()'. >>> >>> -- >>> 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 a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/web2py/l8V3nAzE4Hs/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- 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.
