It would be interesting to hear Michael's possition on this test failer,
but for some reasons our last two posts (and probably this one) don't
show on the SA-devel list.

Any idea why?

Werner

On 07/13/2011 02:12 PM, Philippe Makowski wrote:
> werner [2011-07-13 12:50] :
>> I did a bit of testing using my own application and so far found one
>> place where I run into the following exception if I change
>> "sa/dialect/firebird/base.py" to use "False" for "do_commit" and
>> "do_rollback".
>>
> yes that's strange, I don't understand why
> you can have the same problem running
> sqla_nose.py --db=firebird engine -v
>
> ======================================================================
> ERROR: test.engine.test_ddlevents.DDLExecutionTest.test_platform_escape
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/philippe/dev/python-environments/sqlaP27/lib/python2.7/site-packages/nose-1.0.0-py2.7.egg/nose/case.py",
> line 187, in runTest
> self.test(*self.arg)
> File "<string>", line 1, in<lambda>
> File "/home/philippe/dev/sqlalchemy/./test/lib/testing.py", line 112,
> in decorate
> return fn(*args, **kw)
> File "/home/philippe/dev/sqlalchemy/./test/engine/test_ddlevents.py",
> line 481, in test_platform_escape
> DDL("select 'foo%something'" + default_from)
> File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
> line 3056, in scalar
> row = self.first()
> File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
> line 3039, in first
> self.cursor, self.context)
> File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
> line 3035, in first
> row = self._fetchone_impl()
> File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
> line 2928, in _fetchone_impl
> return self.cursor.fetchone()
> ProgrammingError: (ProgrammingError) (-504, 'fetch: \n Dynamic SQL
> Error\n SQL error code = -504\n Invalid cursor reference\n Cursor is
> not open') None None
>
>
> I don't understand this sqlalchemy problem
> why the cursor is not open ?
>
> it seems that it close the connection, not only the transaction
> My sqlalchemy code knowledge is near None,
> I have to investigate
>
>
> By the way, I think we can improve firebird dialect in sqlachemy, even
> with kinterbasdb
>