We have a Web2py application hosted on Google app engine.
We are trying to implement Taskqueue for fetching record from tables, we
are passing the filter field (date type) and number of years as parameters.
These parameters will be then passed to a Query to fetch the data from the
Database.
Please find the code snippet as given below:
Task_handler() function accepts the 2 input parameters and calls the
taskqueue which is defined in the task_process() function. In
task_process() function we are calculating the date based on the number of
years parameters and using it in the query to fetch the records older than
the calculated date.
def task_handler():
if len(request.args):
field= request.args[0]
filter=int(request.args[1])
return
taskqueue.add(url=URL('task_process'),params={’field’:field,'diff':
filter,},method="POST")
def task_process():
field= request.form.get(‘field’)
diff = request.form.get('diff')
filter_date = datetime.date.today() + datetime.timedelta(-(365*(diff)))
result = []
result = db(field < filter_date).select()
Note :
field in this case is db.<tablename>.<columnname>
If we directly use the input parameter in query, it fails due to datatype
mismatch.
So we tried by hardcoding the table field name in the query but got
Attribute Error for that.
Kindly provide your inputs on what are we missing here or doing wrong.
Thanks.
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/c8da5f65-33a8-415a-8823-c3f5ccc1d3a9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.