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] <javascript:>>: > >> 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] <javascript:>. >> 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.
