IN is not magic, and evaluates1 db query for each member, and should
be used carefully.
q3=(db.table.field.belongs(('value1','value2','value3')))
evaluates 3 db queries to get the result,
Robin
On Dec 13, 5:33 am, Richard <[email protected]> wrote:
> neat! I need to keep closer track of GAE developments ...
>
> On Dec 13, 2:17 pm, mdipierro <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
