This is not a problem. Say you have
def index():
return dict()
def mydata():
row=db(db.mytable.id>0).select()
return dict(row=row)
you can access the latter from the former via ajax with a timer as a
component.
# view index.html
{{extend 'layout.html'}}
<scirpt>
function load_mydata() {
// load data via ajax
web2py_component('{{=URL('mydata.load')}}','xyz');
// refresh even 1000ms without reloading page
setTimeout(load_mydata,1000);
}
jQuery(document).ready(load_mydata);
</scipt>
<div id="xyz">loading...</div>
On Aug 14, 12:19 am, mart <[email protected]> wrote:
> Hi all,
>
> First day here and hoping to be able to pick the collective brain, if
> I can. But before I ask, I do have to say that I am absolutely
> enjoying my experience with web2py, and think that it is without a
> doubt an outstanding platform! - being a python junky, does make me
> bias, but regardless, thank you mr. Di Pierro and contributors!
>
> Ok, so here's the context: I'm a release manager(managing a team of 1,
> me) and I have an automation framework which is distributed across dev
> sites. it works a little like a community of servers and handles a
> number of tasks for me (from builds, to perforce tasks, to remote
> build deliveries, etc.). Upper management (you know the type ;) ) are
> requesting that I provide access to logs and reports to any and all
> processes running through the automation framework. Distribution of
> work and request are achieved through a messaging system between
> server to server (like "hey server_5, this is server_2, what in your
> queue? can you do THIS for me?, etc.) and from user to server. Job
> requests as well as status & reports are done in the same way. So, all
> that to say that that upper management is requesting access to logs ad
> reports. Great! so I tell them to open up a terminal, make a
> connection to any one of the servers and ask!. Well, seems this is too
> hard, too complicated... So here I am. was thinking of using web2py
> (something on T3 would be ideal (or cube2py - which I installed and
> WOW! is what comes to mind). I am thinking of providing the the
> following items and wanted to see if any one has done anything on it,
> thought about it or perhaps can point me in the right direction to
> start la demarche. My hope, is that what gets delivered to our
> technically challenged upper management be "too easy to handle" :)
>
> so, 3 questions:
>
> 1. Looking to create (if none exists) a widget that can "fioat from
> app to app (or web2py DB to web2py DB) and a) would detect the DB and
> expose its tables to the widget where a user could query that DB and
> retrieve the required data (this widget would keep alive wile pages
> are being opened and closed... Thoughts? suggestions?
>
> 2. does anybody know how to make data fields auto -update without
> having to refresh the page being displayed... Seems I once did
> something along those lines with flex some time ago...
>
> 3. well, I'll wait for that one... ;)
>
> I realize this may be a little far fetched (then again maybe not...),
> but any help or reality check o this would be greaty appreciated.
>
> Thanks for you time in reading this post,
>
> mart :)
