neat! I need to keep closer track of GAE developments ...
On Dec 13, 2:17 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > At some point GAE added support for the IN operator. I do not know > when but when I found out I added it (belongs maps to IN). Notice that > this is not the same as LIKE. > > Massimo > > On Dec 12, 6:19 pm, Richard <richar...@gmail.com> wrote: > > > > > how did you add belongs support for GAE? I remember in a previous > > discussion this was considered not > > possible/practical:http://code.google.com/p/web2py/issues/detail?id=56&can=1 > > > On Dec 12, 4:42 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > I have re-factored a lot of code in gluon/contrib/gql.py in order to > > > make it leaner, more readable and add new syntax. Now you can do mix > > > and match queries like: > > > > q1=(db.table.id==1) > > > q2=(db.table.id>0) > > > q3=(db.table.field.belongs(('value1','value2','value3'))) > > > > in expressions like > > > > db(q1)(q2)q3).select() > > > db(q1&q&q3).select() > > > db(...).update(...) > > > db(...).delete() > > > > Before this patch, belongs was not supported by web2py on GAE, q1 and > > > q2 could not be mixed with other conditions. > > > > Now you can do for example: > > > > d=datetime.date.today() > > > db.define_table('person',Field('name'),Field('birthday','date')) > > > db.person.insert(name='John',birthday=d) > > > rows=db(db.person.id>0)(db.person.name.belongs(('John',))).count() > > > rows=db(db.person.id==1)(db.person.name.belongs(('John',)))\ > > > (birthday==d).update(name='Jim') > > > > Moreover the db['_lastsql'] now contains a complete representation of > > > the last query on GAE and it can be used for debugging, and both db, db > > > (...) and can serialized as a string. > > > > Please check it and report any problem. > > > > Also please let me know if you find places in the online documentation > > > that have just become obsolete. > > > > Massimo -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.