Thanks it works now.
Also why do you think that cron is better then the sleep function?
On Dec 3, 1:55 pm, "Anand Chitipothu" <[EMAIL PROTECTED]> wrote:
> On Dec 3, 2007 7:57 AM, placid <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > Hi All,
>
> > I'm trying to write a function that only runs (automatically) every
> > two weeks that will just archive some rows in the database to another
> > table. So far this is what i have (which doesn't work, i get a
> > KeyError exception on the line were i try to do the select )
>
> > import web,threading,time
>
> > def archiver():
> > while True:
> > data = web.select('data',where='finish_data <= '14'))
> > # do stuff with data
> > #time.sleep(1209600), for testing purposes use 10 second
> > intervals
> > time.sleep(10)
>
> > if __name__ == '__main__':
>
> > web.config.db_parameters = dict(dbn='mysql', user='user',
> > pw='password', db='mydatabse')
>
> > # start archiver thread
> > archiver_thread =
> > threading.Thread(target=archiver,name='archiver_thread')
> > archiver_thread.setDaemon(True)
> > archiver_thread.start()
>
> > web.run(urls, globals(), web.reloader)
>
> You need to call web.load() in the begining of archiver() function.
> I think, it is better to use cron to run the script regularly than
> running it using sleep in the function.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" 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/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
