How to extract the operator of the query in familiar "==" or "="
db_set.query.second.op return adapter bound operator... Richard On Tue, Apr 28, 2015 at 12:15 PM, Richard Vézina < [email protected]> wrote: > I guess the best option would be to do the same as SQLFORM.grid search?? > > On Tue, Apr 28, 2015 at 12:10 PM, Richard <[email protected]> > wrote: > >> Hello, >> >> I need to pass a db_set to a widget that is used into an IS_IN_DB() >> validator. This as to be done in order to the widget which is a custom >> autocomplet widget using bootstrap typeahead can make the correct query >> with ajax call to a returning json function which feed the widget with >> result base on user input... Actually my widget don't consider the requires >> of the field for populating the dropdown which as side effect that suggest >> elements base on user input are not in db because of the IS_IN_DB() >> validator set... So, I want to pass the set to the widget so it can digest >> it and send the query to the sub-function returning json on ajax call to >> feed autocomplet widget with proper suggestion... >> >> So, I know I can pass a bunch of vars then recreate the query on the >> orther side and reduce the query like that : >> >> query = reduce(lambda a, b: a & b, where_clauses) >> rows = db(query).select(*output_columns) >> >> But I wouldn't have to construct db_set query into returning json >> function because it is restrictive, because I have predetermined query >> constructor base on variables available and I have to write new constructor >> of query for every db_set... I want something more flexible than that... >> But I am concern about security if I passing query as an URL vars... Is >> this a bad/good idea? >> >> Thanks >> >> Richard >> >> -- >> 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. >> > > -- 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.
