[sqlalchemy] Re: SQLAlchemy 0.4 beta5 (OperationalError) database table is locked '\nDROP TABLE os' () sqlite 3.4.2

2007-09-16 Thread Andreas Jung
--On 14. September 2007 10:07:27 -0700 jason kirtland [EMAIL PROTECTED] wrote: jean-marc pouchoulon wrote: helo, I don't understand why my sqlite database is locked on a drop ( the code is following) thanks for your explanation. [...snip...] ordinateurs =

[sqlalchemy] Re: SQLAlchemy 0.4 beta5 (OperationalError) database table is locked '\nDROP TABLE os' () sqlite 3.4.2

2007-09-14 Thread jason kirtland
jean-marc pouchoulon wrote: helo, I don't understand why my sqlite database is locked on a drop ( the code is following) thanks for your explanation. [...snip...] ordinateurs = computers_table.select(computers_table.c.prix 100.0).execute() ordinateur_pas_cher =

[sqlalchemy] Re: SQLAlchemy 0.4 beta5 (OperationalError) database table is locked '\nDROP TABLE os' () sqlite 3.4.2

2007-09-14 Thread jean-marc pouchoulon
j Here you're holding onto open cursors with 'something == ordinateurs.fetchone()'. Either explicitly close() the two result sets you're accessing with fetchone() or remove your reference to the rows and python gc will get around to closing the cursors at some point. ok thanks.