Not sure. Try this: myset=db(db.item2.id>0) while myset.delete(): pass
Massimo On Oct 14, 9:29 am, Chris S <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
