It's not working :(
In the best scenario i can leave one connection opened in a whole
request (with other combinations it leaves at least 10 more or less)
only with:
self.db.commit()
from gluon.dal import BaseAdapter
BaseAdapter.close_all_instances('commit')
2012/7/7 Daniel Gonzale <dgzabal...@gmail.com>:
> Of course, i will try this afternoon.
>
>
>
> El 07/07/2012, a las 03:33, Massimo Di Pierro <massimo.dipie...@gmail.com>
> escribió:
>
> Meanwhile, can you check the new db.close() in trunk?
>
> On Friday, 6 July 2012 15:40:57 UTC-5, demetrio wrote:
>>
>> Mail with the code sended :)
>>
>> 2012/7/6 Massimo Di Pierro <massimo.dipie...@gmail.com>:
>> > I do not recall. Can you resend it please. My personal inbox is a bit
>> > messy.
>> >
>> >
>> > On Friday, 6 July 2012 05:51:04 UTC-5, demetrio wrote:
>> >>
>> >> I will try this weekend.
>> >>
>> >> Massimo did you received the code of the apllication?
>> >>
>> >> Thanks everyone
>> >>
>> >>
>> >>
>> >> El 06/07/2012, a las 04:32, Massimo Di Pierro
>> >> <massimo.dipie...@gmail.com>
>> >> escribió:
>> >>
>> >> Looks like I prematurely close the issue. There is now a db.close() in
>> >> trunk. Please check it out.
>> >>
>> >> massimo
>> >>
>> >> On Thursday, 5 July 2012 13:05:47 UTC-5, nick name wrote:
>> >>>
>> >>> On Thursday, June 28, 2012 10:47:15 AM UTC-4, Massimo Di Pierro wrote:
>> >>>>
>> >>>> why not simply?
>> >>>>
>> >>>> db.commit()
>> >>>> db.close()
>> >>>>
>> >>>> if db in an on object attribute like self.db you can do
>> >>>>
>> >>>> if self.db:
>> >>>> self.db.commit()
>> >>>> self.db.close()
>> >>>> self.db = 0
>> >>>>
>> >>>> you can also do:
>> >>>>
>> >>>> BaseAdapter.close_all_instances('commit')
>> >>>
>> >>>
>> >>> This is not enough, as was documented on issue
>> >>> http://code.google.com/p/web2py/issues/detail?id=731. The code that
>> >>> works
>> >>> for me for sqlite is as follows:
>> >>>
>> >>> def closebase(base):
>> >>> if not base: return
>> >>> # see: http://code.google.com/p/web2py/issues/detail?id=731
>> >>> # see:
>> >>> https://groups.google.com/d/topic/web2py/hmsupVHdDHo/discussion
>> >>> # was: base._adapter.close()
>> >>> from gluon.dal import thread
>> >>> thread.instances.remove(base._adapter)
>> >>> base._adapter.close()
>> >>>
>> >>> and then I call closebase(db); db = None which is enough for me with
>> >>> sqlite -- but apparently, the original poster has tried that, and that
>> >>> is
>> >>> not sufficient for mysql.
