[SQLObject] MySQL: Commands out of sync; you can't run this command now

2013-04-16 Thread Matchek
Hello list, I'm running into a problem when running a small web app in webpy with sqlobject. The app is a REST interface which handles URLs such as: GET /pkgdb/rest/srv4/7793c4a5ecd6494b25d475632618e44c/pkg-stats/ HTTP/1.1 and PUT /releases/catalogs/unstable/i386/SunOS5.9/7793c4a5ecd6494b25d475

Re: [SQLObject] MySQL: Commands out of sync; you can't run this command now

2013-04-24 Thread Matchek
2013/4/16 Oleg Broytman > > On Tue, Apr 16, 2013 at 10:52:29AM +0100, "Maciej (Matchek) Blizi??ski" > wrote: > > File > > "/opt/csw/lib/python/site-packages/sqlobject/mysql/mysqlconnection.py", > > line 71, in makeConnection > > co

[SQLObject] Temporary databases / Closing the :memory: database connection

2013-10-16 Thread Matchek
Hi guys, I'd like to use an in-memory sqlite database for testing, and I have a problem where I don't seem to be able to let go of a database which was once created. Here's a test that shows what I mean: class Foo(sqlobject.SQLObject): bar = sqlobject.UnicodeCol(length=250, unique=True) db_uri

Re: [SQLObject] Temporary databases / Closing the :memory: database connection

2013-10-16 Thread Matchek
2013/10/16 Oleg Broytman > > It does what I need, but it doesn't seem like it's what SQLObject > > developers intended. Do you have any recommendations? > >I don't. Do you want to propose an API? Or better a patch? Hey, thanks for the reply. I'm looking at the code right now, I need to look m

Re: [SQLObject] Temporary databases / Closing the :memory: database connection

2013-10-17 Thread Matchek
2013/10/17 Oleg Broytman > > Hi! > > On Wed, Oct 16, 2013 at 10:58:24PM +0100, "Maciej (Matchek) Blizi??ski" > wrote: > > - there already is special handling for in-memory databases, so > > maybe add a little more special handling for them; for example free

Re: [SQLObject] Temporary databases / Closing the :memory: database connection

2013-10-19 Thread Matchek
On Fri, Oct 18, 2013 at 01:14:46AM +0400, Oleg Broytman wrote: >It would be interesting to test if the problem lies in SQLite, > PySQLite or SQLObject. Looks like it's not SQLite, the following runs with stable memory use at about 7MB, I ran it for about an hour: import sqlite3 while True: