Thank you so much! It means a lot to me :-) Cheers,
Rahul On Friday, September 28, 2018 at 11:28:44 AM UTC+5:30, Massimo Di Pierro wrote: > > Congratulations! > > On Monday, 17 September 2018 23:39:50 UTC-7, Rahul wrote: >> >> Hi Everyone, >> I am glad to say that my application ( >> http://www.targetsoft.co.in/ ) is up and running on personal VPS. I've >> added links to total of three applications all written in web2py >> >> 1. HMS (Hospital Management system ) coded back in 2016 - may have a few >> issues >> 2. Target+ (Ticketing and Project Management system) - This is being >> written from last 9+ years and was iteratively developed from desktop >> single user with SQLite to now full fledged web application with multiple >> users and workspaces. Again this is my first huge application. You can read >> the details online. If anyone wants to go through the demo workspace let me >> know and I'll publish the access credentials. >> 3. Artpic [Artful pictures] (This is a review, news, blogging, social >> and photography site) for photogs. Although its huge application and would >> need its own space which will be available shortly :-) but currently it can >> be accessed as a web2py application from within the site. >> >> I admit there can be issues lingering in a few applications (and some may >> need updates) but nonetheless I am excited to launch my product in my >> favorite language python and my favorite web framework web2py :-) Do let >> me know if you encounter any issues OR if you have any suggestions or >> change request you can write here, mail me personally or use Contact us >> page of the website. I will be glad to hear from you. >> >> I want to thank all of you & Anthony specially for all the support >> provided to me with my issues. Web2py is superb. >> >> Thank you, >> >> Rahul Dhakate. >> >> On Thursday, August 2, 2018 at 10:17:17 AM UTC+5:30, Rahul wrote: >>> >>> Hi Anthony, >>> Yes there are many queries that are being fired - Since it is a >>> dashboard I have multiple queries being fired sequentially/simultaneously. >>> I have a number of those queries in try catch block as well. I certainly >>> agree that rolling back is not a good solution and in-fact I am in process >>> of getting rid of all try -catch block queries with proper DAL supported >>> queries. I also had quite a few *db.executesql (...)* statements which >>> I am replacing with appropriate DAL queries for maximum compatibility. I >>> would share the queries with you once my cleanup is done and if even after >>> that by removing *db.rollback()* they still throw errors. Since the >>> code is scattered in multiple functions, it is taking time for me to fix >>> it. >>> >>> Application in brief - The application I've written is huge with 26 >>> different modules (Dashboard being one of them). All other modules are >>> working fine except Dashboard which serves the users to view different >>> statistics, drill down in charts, with all sort of notifications, alerts >>> etc (eight sections in all), There are settings centrally for each section >>> to control its visibility. This is the reason for multiple queries that >>> provide data for viewing, analysis and updates are carried out separately >>> when required. >>> >>> Thanks, >>> Rahul >>> >>> ------------- >>> >>> >>> On Wednesday, August 1, 2018 at 8:59:27 PM UTC+5:30, Anthony wrote: >>>> >>>> On Wednesday, August 1, 2018 at 8:48:54 AM UTC-4, Rahul wrote: >>>>> >>>>> Hi Anthony, >>>>> I used *db.rollback**()* and viola - A lot of my failing >>>>> stuff started to work. I am rectifying the failing queries and still >>>>> trying to figure out the incorrect SQL statement that is causing the >>>>> error. >>>>> For below question - Again if I print db.rollback() a *None* is >>>>> returned. >>>>> What happens if you call db.rollback() right before running these >>>>> queries that are generating the error? >>>>> I still want to know what all does - >>>>> db.rollback() function what does it do exactly ? rollback previously >>>>> executed queries? It is working like a charm. >>>>> >>>> >>>> This is not the ideal solution because you may be rolling back good >>>> queries that you would otherwise want to commit. You should try to >>>> identify >>>> what queries are causing problems. Do you have any queries in a try/except >>>> that could be causing (uncaught) errors? What other queries are running >>>> before you get to the queries you have shown? >>>> >>>> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.