[sqlalchemy] Re: Properly closing all database connections

2008-05-06 Thread jason kirtland
Karlo Lozovina wrote: I'm using SA with SQLite, and after executing session.close() and clear_mappers(), on Linux, lsof still says my SQLite file is open. Running engine.dispose() seems to finally close it, but I'm not sure if that's the proper way? That's correct. The engine holds the

[sqlalchemy] Re: Properly closing all database connections

2008-05-06 Thread az
yes, session/mappes are ORM level, metadata is lower and engine is lowest AFAIK. On Tuesday 06 May 2008 23:39:13 Karlo Lozovina wrote: I'm using SA with SQLite, and after executing session.close() and clear_mappers(), on Linux, lsof still says my SQLite file is open. Running engine.dispose()

[sqlalchemy] Re: Properly closing all database connections

2008-05-06 Thread Karlo Lozovina
On May 6, 10:53 pm, jason kirtland [EMAIL PROTECTED] wrote: That's correct.  The engine holds the connection pool and dispose() will close the connections it manages. Thanks... it's weird there's no mention of it in the docs. -- Karlo Lozovina - Mosor