Setting up Cron jobs on GAE is simple enough.  But I'm not
understanding something with creating a cron that can delete table
entries.

I was attempting to make the cron remove all items in a selection
with:
db.delete(sqldb.item2)
return 'Delete complete'

The problem is it fetches the 1000 limit and deleting that many items
exceeds the 30-second process limit on GAE.

So I was trying to reduce the number of items deleted in each cron
with:
rows=db.(db.item2.id>0).select(limitby=(0,200))

That returns a row object which doesn't seem to take the delete
command.  Only a 'set' can be called with delete.
myset=db(db.item2.id>0)
myset.delete()

This works just fine as far as deleting goes, but the set can't be
limited like the selection can.

I'm sure I'm just missing something, but how do I perform a delete
command on something other than the max allowed selection of 1000?

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to