This is actually not a GAE issue. This is a smartgrid issue. Because you
are comparing with a datetime issue, it expects the time as part of the
date. I just change the parsing routine in trunk to fix this problem. Give
it a try.
Massimo
On Sunday, 8 April 2012 22:36:34 UTC-5, Douglas Ross wrote:
>
> Hi,
>
> I know the documentation explains that you cannot do 'complex' datetime
> queries in web2py with GAE, however I am hoping that this does not qualify
> as 'complex'.
>
> I am trying to use the smartquery (experimental) functionality that it
> works really well in the SQLlite db.
>
> Unfortunately, the same call fails in GAE.
>
> I am using Version 1.99.7, and the latest GAE.
>
> To reproduce the problem, I have a table with a datetime field:
>
> db.define_table('call',
> Field('start', 'datetime'),
> Field('end', 'datetime'),
> Field('created_on','datetime',default=request.now,
> label=T('Created On'),writable=False,readable=False),
> Field('modified_on','datetime',default=request.now,
> label=T('Modified On'),writable=False,readable=False,
> update=request.now))
>
> I have created an REST interface using the smartquery functionality, that
> works well on SQL lite:
>
> @request.restful()
> #@auth.requires_login()
> def calldatasmart():
> response.view = 'generic.'+request.extension
> def GET(search):
> try:
> rows = db.smart_query([db.call],search).select()
> return dict(result=rows)
> except RuntimeError:
> raise HTTP(400,"Invalid search string")
> return locals()
>
> Now if I do the following I get the correct response from SQLLite and an
> error from GAE. (Note: I created the data using the default=request.now
> function, so it should be a datetime in the datastore.
>
> http://localhost:8080/api/calldatasmart.json?search=call.created_on is
> greater than "2012-03-20"
>
> Error in GAE:
>
> File "/........./gluon/dal.py", line 3396, in represent
>
> time_items = map(int,str(obj)[11:].strip().split(':')[:3])
>
> ValueError: invalid literal for int() with base 10: ''
> Question:
> 1. Is this a bug in the experimental smartquery functionality?
> 2. Does all datetime comparisons not work with GAE?
> 3. Can I use a GQL call to do it, or is there a way in Web2py to do it
> nicely?
>
> BTW: I have not coded as much as this for 15 years, and I have not had so
> much fun in getting back into it. So thankyou all for the work you have
> done to create web2py...
>
> Doug
>
>
