line 934 in sqlhtml.py On Wed, Feb 17, 2010 at 2:10 PM, Wes James <compte...@gmail.com> wrote: > I'm noticing now why this is a problem. When I put [] in the field > and submit it, it gets processed and comes out '[]' instead of just > []. If it is a StringListProperty, shouldn't that come out [] not > '[]'? > > -wes > > On Wed, Feb 17, 2010 at 1:57 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: >> because now >> >> db.table.insert(yourlistfield=.....) >> >> has to be a list. You need to create a validator that takes the input >> and filters it into a list. I cannot write that for you since it >> depends on how you insert the data. >> >> On Feb 17, 12:57 pm, Wes James <compte...@gmail.com> wrote: >>> I removed all the data and tweaked the model a bit so all it looks like is: >>> >>> if request.env.web2py_runtime_gae: >>> db = DAL('gae') >>> session.connect(request, response, db=db) # and store sessions and >>> tickets there >>> else: >>> db = DAL('sqlite://storage.sqlite') >>> >>> from gluon.tools import * >>> crud=Crud(globals(),db) >>> >>> from gluon.contrib.gql import gae >>> >>> db.define_table('ideModelAPI', >>> Field('ideModelAPIitem','string'), >>> Field('ideModelAPITip','text'), >>> Field('ideModelAPIkey',type=gae.StringListProperty()) >>> ) >>> >>> but when I go to /app/ >>> >>> /app/default/controller/create/table >>> >>> and submit the data, I still get: >>> >>> BadValueError: Property ideModelAPIkey must be a list >>> >>> This is even with a blank value, or [], or ['a'] for tests. >>> >>> Is there something wrong with gql.py? >>> >>> -wes >>> >>> On Wed, Feb 17, 2010 at 9:56 AM, Wes James <compte...@gmail.com> wrote: >>> > After some changes when I try to add an entity on gae through their >>> > interface, the StringListProperty field does not even show for me to >>> > put data in it. >>> >>> > If I edit a record that already has some data, the StringListProperty >>> > field has [] in it, but if I leave it blank or add some data like >>> > ['a','b'] I get the error: >>> >>> > ...' >>> >>> > File >>> > "/base/data/home/apps/web2pyapi/1.339952435474722330/gluon/contrib/gql.py", >>> > line 719, in update >>> > setattr(item, field, value) >>> > File "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", >>> > line 472, in __set__ >>> > value = self.validate(value) >>> > File "/base/python_lib/versions/1/google/appengine/ext/db/__init__.py", >>> > line 2731, in validate >>> > raise BadValueError('Property %s must be a list' % self.name) >>> > BadValueError: Property ideModelAPIkey must be a list >>> >>> > What is it about blank, or even [] or ['a','b'] that is not a list? >>> >>> > and why is google interface not providing a field for adding a list >>> > value for that field? >>> >>> > -wes >>> >>> > On Wed, Feb 17, 2010 at 9:09 AM, mdipierro <mdipie...@cs.depaul.edu> >>> > wrote: >>> >> As far as web2py is concerned you just change the type. >>> >> As far as GAE is concerned I do not know. >>> >> Try and see what happens. >>> >>> >> On Feb 17, 9:56 am, Wes James <compte...@gmail.com> wrote: >>> >>> OK. That field is a text field on gae now, how do I change it to >>> >>> gae.StringListProperty type? >>> >>> >>> On Tue, Feb 16, 2010 at 9:50 PM, mdipierro <mdipie...@cs.depaul.edu> >>> >>> wrote: >>> >>> > You are mixing gae syntax and dal syntax. >>> >>> >>> > This is only allowed in >>> >>> >>> > from gluon.contrib.gql import gae >>> >>> > db.define_table('mytable',Field('this_is_a_list',type=gae.StringListProperty())) >>> >>> >>> > queries must use dal syntax. >>> >>> >>> > On Feb 16, 5:46 pm, Wes James <compte...@gmail.com> wrote: >>> >>> >> There does not seem to be an .all(). How should the line be >>> >>> >> written? >>> >>> >>> >> thx, >>> >>> >>> >> -wes >>> >>> >>> >> On Tue, Feb 16, 2010 at 4:25 PM, Wes James <compte...@gmail.com> >>> >>> >> wrote: >>> >>> >> > so if I created a field >>> >>> >>> >> > Field('fieldKey', 'text') >>> >>> >>> >> > and put ['web2py', 'web2p', 'web2', 'web', 'we', 'w'], in for the >>> >>> >> > value and then did >>> >>> >>> >> > query=request.vars._query >>> >>> >>> >> > rows=db(db.table.all().filter('fieldKey >=', >>> >>> >> > query).filter('fieldKey >>> >>> >> > <', query + u'\ufffd')).select(db.table.ALL, >>> >>> >> > orderby=db.table.tableitem) >>> >>> >>> >> > this would work? >>> >>> >>> >> > On Sun, Feb 14, 2010 at 3:57 AM, Richard <richar...@gmail.com> >>> >>> >> > wrote: >>> >>> >> >> sounds like this will be useful. >>> >>> >>> >> >> StringListProperty is a native gae type now supported by web2py: >>> >>> >> >>http://code.google.com/appengine/docs/python/datastore/typesandproper... >>> >>> >> >>http://groups.google.com/group/web2py/browse_thread/thread/7d284c9fa4... >>> >>> >>> >> >> To get around the like problem you can do something like this: >>> >>> >> >> Model.all().filter('ngrams >=', word).filter('ngrams <', word + >>> >>> >> >> u'\ufffd') >>> >>> >>> >> >> Check out Thadeus's code for a full example. >>> >>> >>> >> >> There's also info how to do this in the docs: >>> >>> >> >>http://code.google.com/appengine/docs/python/datastore/queriesandinde... >>> >>> >>> >> >> Richard >>> >>> >>> >> >> On Feb 14, 1:52 pm, Wes James <compte...@gmail.com> wrote: >>> >>> >> >>> Richard, >>> >>> >>> >> >>> Do you have a python example of this? I'll check on >>> >>> >> >>> StringListProperty also and see how it works. (would this work on >>> >>> >> >>> gae?) I was trying somthing else since like is not supported, >>> >>> >> >>> but this >>> >>> >> >>> might work. I would like this site to provide quick search on >>> >>> >> >>> anything that would be helpful in building a web2py app. There >>> >>> >> >>> are a >>> >>> >> >>> lot of things in tools.py that could go here for instance, and >>> >>> >> >>> maybe >>> >>> >> >>> another page with docstrings? Whatever anyone thinks would be >>> >>> >> >>> helpful. >>> >>> >>> >> >>> -wes >>> >>> >>> >> >>> On Sat, Feb 13, 2010 at 4:26 PM, Richard <richar...@gmail.com> >>> >>> >> >>> wrote: >>> >>> >> >>> > hi wes, >>> >>> >>> >> >>> > something like this could be really nice for browsing the >>> >>> >> >>> > function >>> >>> >> >>> > docstrings. Do you intend to take it further? >>> >>> >>> >> >>> > If you use a StringListProperty to store all the ngrams (eg: >>> >>> >> >>> > web2py, >>> >>> >> >>> > web2p, web2, web, we, w) then it could match partial words. >>> >>> >>> >> >>> > Richard >>> >>> >>> >> >> -- >>> >>> >> >> 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 >>> >>> >> >> athttp://groups.google.com/group/web2py?hl=en. >>> >>> >>> > -- >>> >>> > 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 >>> >>> > athttp://groups.google.com/group/web2py?hl=en. >>> >>> >> -- >>> >> 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 >>> >> athttp://groups.google.com/group/web2py?hl=en. >> >> -- >> 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. >> >> >
-- 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.