Re: [sqlalchemy] Re: SQLite: Rolling back DDL requests

2010-11-02 Thread Torsten Landschoff
Hi Michael, I only noticed the activity on this thread today. On Sat, 2010-08-14 at 11:07 -0400, Michael Bayer wrote: reproduce the problem and it suggests the problem stems from some behaviour of transactions or of the engine.base.Connection class. I don't quite know what to make of it

Re: [sqlalchemy] Re: SQLite: Rolling back DDL requests

2010-11-02 Thread Michael Bayer
On Nov 2, 2010, at 5:15 PM, Torsten Landschoff wrote: In addition, isolation_level=None with pysqlite disables the DBAPIs entire transactional system. SQLAlchemy relies upon this system to handle proper transactional behavior. Per their documentation, some statements will fail if

[sqlalchemy] Re: Best way to get data from database

2010-11-02 Thread Alvaro Reinoso
Thank you Eric! It's good approach and I'm gonna keep it in mind. I can get the data in hidden fields and just use the REST API to do POST, PUT and DELETE. On Oct 29, 10:33 pm, Eric Ongerth ericonge...@gmail.com wrote: I understand your question if you are getting different data from the server

[sqlalchemy] Weird error when I add a new attribute to one class

2010-11-02 Thread Alvaro Reinoso
Hello, I got a weird error when I try to create a new object. Before It worked without any problem, but I got this error after adding a new attribute to the User class. This attribute is related to Screen in a relation many to many through user_screens. This is the error: InvalidRequestError:

[sqlalchemy] Connection / disconnect / Pool

2010-11-02 Thread Warwick Prince
Hi Michael I have an issue I can't fathom regarding Pools.I'm doing testing and hit the following error at exatly the same point each time; File C:\Documents and Settings\wprince\Desktop\PY CODE DEVELOPMENT\pyDAP\DAPForm.py, line 3805, in _processQuery self._queryCount =