It sounds like (2) should be done in background. web2py's scheduler handles that. You write some code which does the insert, and then get the scheduler to run it. The "scheduler" is a separate web2py instance for your application, which doesn't serve web-pages, it just runs jobs. Apart from that, it works like everything else in web2py (so it uses your app's models and the DAL). You can actually develop your code as a controller function as if was to run interactively, and when you're comfortable with it, convert it into a scheduler job. The scheduler functionality is good. The book documents it quite well.
The DAL is also quite convenient for updating data. (3) depends on whether the processing can be done on the fly for graphing. On Friday, 21 February 2014 07:35:51 UTC+11, Trent Telfer wrote: > > I am attempting to create a fairly simple dashboard with data retrieved > from external data sources. I have currently written python scripts that > retrieve the data (date and volume data) from the external data source as a > list. My current conundrum is calling the script and inserting the list > into the database (the script will be ran once per day). So to break it > down I am attempting to: > > 1) Retrieve external data (completed). > 2) Insert into database using the DAL. > 3) Process data in database to be graphed and displayed. > > I can see how to do this with Flask/SQLAlchemy, but I have used web2py for > some simpler form based web projects and would prefer to use it Any ideas, > suggested tutorials or other methods would be most welcome. > > Regards, > > Trent > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
