Maybe raise the issue on the developers list: https://groups.google.com/forum/#!forum/web2py-developers
On Monday, December 7, 2015 at 1:07:54 PM UTC-5, Brian Craft wrote: > > Off-hand, I'm not sure of the best approach. I understand wanting to > automate cleanup of the db connection, but in this case a manual mechanism > would be useful. > > If the controller could get a db connection manually, it could then return > an iterator that closes the connection on the last value, and on error. > Perhaps this is already possible. Can the controller manually get a db > connection from the underlying db or connection pool? > > To make it slightly less error-prone, web2py could provide an iterable > wrapper that opens & closes the db connection, catching errors. > > > On Friday, December 4, 2015 at 3:29:15 PM UTC-8, Anthony wrote: >> >> Yes, I see this is tricky because web2py closes the database connection >> once the response is returned, yet if you return a generator that is >> iterating through database queries, the connection must remain open. Do you >> have a suggestion for how this can be achieved (i.e., something the >> framework could do differently)? >> >> Anthony >> >> On Friday, December 4, 2015 at 3:42:00 PM UTC-5, Brian Craft wrote: >>> >>> Ah, I see. I'm not sure that helps me, because I want the browser to >>> download the result. The problem from the UX perspective is this huge delay >>> between when the user clicks the download button & when the browser brings >>> up the "save" dialog. That delay is determined by when the server sends the >>> headers for the response. Because of the delay, it looks like the button >>> isn't working, and the user may click on it several more times. There's no >>> place to inject an ajax query in the built-in browser 'download' >>> functionality. >>> >>> There are various horrible work-arounds, like using cookies to determine >>> when the download has started. It's tempting to try writing a controller >>> that creates a thread which submits another request, where the db query >>> runs. >>> >>> Perhaps there should be a link to LOAD in the view docs, since it's a >>> view expression. >>> >>> On Thursday, December 3, 2015 at 4:27:19 PM UTC-8, Anthony wrote: >>>> >>>> On Thursday, December 3, 2015 at 5:37:51 PM UTC-5, Brian Craft wrote: >>>>> >>>>> I don't know what this means. >>>>> >>>> >>>> He's saying to load a parent page (that does not run the query or >>>> return any data), and once the parent page has loaded, then request the >>>> data via Ajax. >>>> >>>> >>>>> Also, I can't find docs for LOAD(). >>>>> >>>> >>>> >>>> http://web2py.com/books/default/chapter/29/12/components-and-plugins#Components--LOAD-and-Ajax >>>> >>>> Anthony >>>> >>> -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
