Hello,
I'm using Google App Engine, and trying to make use of the new
'belongs' feature in queries (thanks much for adding it in!), and am
having a problem. It seems that when i construct the query my list is
being converted to a unicode string, and then the query generation
code fails.
here's my model:
db.define_table('media_type',
Field('name', 'string', notnull=True, unique=True,
requires=[IS_NOT_EMPTY(),
IS_NOT_IN_DB(db,'media_type.name')]))
here's my query:
rows = db(db.media_type.name.belongs(['paper', 'cd'])).select()
here's the error:
/cfhowes/clients/rockriver/source/web2py/applications/rockriver/
controllers/manage.py:song_media", line 68, in song_media\n File "/
home/cfhowes/clients/rockriver/source/web2py/gluon/contrib/gql.py",
line 666, in select\n (items, tablename, fields) = self._select
(*fields, **attributes)\n File "/home/cfhowes/clients/rockriver/
source/web2py/gluon/contrib/gql.py", line 617, in _select\n items =
items.filter(cond, val)\n File "/home/cfhowes/Desktop/gae/
google_appengine/google/appengine/ext/db/__init__.py", line 1882, in
filter\n raise BadValueError(\'Argument to the "in" operator must
be a list\')\nBadValueError: Argument to the "in" operator must be a
list\n
(sorry, it's how i copied it out of the GAE viewer....)
Here's my proposed solution - but I don't understand what i did well
enough to know the potential other side effects. If I modify gql.py
(from Version 1.72.3 (2009-11-10 09:17:13)) and add the following at
line 460:
elif isinstance(obj, list):
obj = obj
which keeps the check a few lines later from converting my list to a
unicode string. my query now works.
so, did i do something wrong in my query, or is this fix (or something
similar) needed to make belongs work in the latest build?
thanks,
christian
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---
