i don't know much about cache yet, if i am not mistaken it caches the two queries separated
my query is this: years = [i.year for i in union(db(db.table1.station_id==this_station.id).select(db.table1.year),db(db.table2.station_id==this_station.id).select(db.table2.year)).sort(lambda row: row.year)] maybe i can create a function which will return the list of available records for the IS_IN_SET validator, the function will be something like: def yearset(id): return [i.year for i in union(db(db.table1.station_id==id).select(db.table1.year),db(db.table2.station_id==id).select(db.table2.year)).sort(lambda row: row.year)] so i can cache this with something like this (?) cache.ram(str(id), lambda: yearset(id), seconds) i have to read more about this so i can fully understand how it works On Thursday, August 1, 2013 3:27:43 PM UTC+3, Niphlod wrote: > > I sincerely hope that this gets cached somewhere in your app, because if > instead they are in models, you're doing 2 selects for every request > > On Thursday, August 1, 2013 2:21:07 PM UTC+2, Antonis Konstantinos Tzorvas > wrote: >> >> yes you are right, i was looking also in IS_IN_SET >> and finally after your reminder one solution came up easily, >> >> IS_IN_SET([i.name for i in rows = union(db().select(db.a.name >> ),db().select(db.b.name)).sort(lambda row: row.name)]) >> >> which now displays all the values of a required column from both tables! >> don't know if there is a better way to do this, or a way to use >> IS_IN_DB() but i think that this one works >> >> On Thursday, August 1, 2013 2:48:40 PM UTC+3, viniciusban wrote: >>> >>> I don't think so. >>> >>> The book says IS_IN_DB() can receive a Set, but not Rows. >>> >>> On Thu, Aug 1, 2013 at 8:33 AM, Antonis Konstantinos Tzorvas >>> <ant...@tzorvas.com> wrote: >>> >> --- https://groups.google.com/d/msg/web2py/o3GebSeC7j4/Sct76ynB3fsJ---- >>> >> >>> >> db=DAL()db.define_table('a',Field('name')) >>> >> db.define_table('b',Field('name')) >>> >> db.a.insert(name='Alex') >>> >> db.a.insert(name='Max') >>> >> db.a.insert(name='Tim') >>> >> db.b.insert(name='John') >>> >> db.b.insert(name='Jack') >>> >> def union(x,y): >>> >> y.colnames=x.colnames >>> >> return x|y >>> >> >>> >> rows = union(db().select(db.a.name),db().select(db.b.name)).sort(lambda >>> >>> >> row: row.name) >>> >> >>> >> for row in rows: print row.name >>> > >>> > >>> > this one worked for the union select part, >>> > but how can i use it with a validator like IS_IN_DB for a form? >>> > >>> > i have two identical tables which data are from different source but >>> the >>> > structure is the same >>> > >>> > -- >>> > >>> > --- >>> > 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 web2py+un...@googlegroups.com. >>> > For more options, visit https://groups.google.com/groups/opt_out. >>> > >>> > >>> >> -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
