Skip to content

sqlalchemy 0.6.1 breaks firebird driver #1823

Closed
@sqlalchemy-bot

Description

@sqlalchemy-bot
Collaborator

Migrated issue, originally created by Anonymous

Hi,

SQLalchemy 0.6.1 breaks executing direct statements with firebird:

>>> import sqlalchemy
>>> from sqlalchemy import create_engine
>>> sqlalchemy.__version__
'0.6.1'
>>> engine = create_engine('firebird://sysdba:masterkey@127.0.0.1:3050/testdb?type_conv=300',echo=True)
>>>
... conn = engine.connect()
>>>
... a = conn.execute("SELECT * FROM RDB$DATABASE")
2010-06-09 12:26:37,902 INFO sqlalchemy.engine.base.Engine.0x...75d0 SELECT * FROM RDB$DATABASE
2010-06-09 12:26:37,904 INFO sqlalchemy.engine.base.Engine.0x...75d0 ()
Traceback (most recent call last):
  File "<stdin>", line 2, in <module>
  File "/Users/chris/Development/sqltest/lib/python2.6/site-packages/SQLAlchemy-0.6.1-py2.6.egg/sqlalchemy/engine/base.py", line 1157, in execute
    params)
  File "/Users/chris/Development/sqltest/lib/python2.6/site-packages/SQLAlchemy-0.6.1-py2.6.egg/sqlalchemy/engine/base.py", line 1253, in _execute_text
    return self.__execute_context(context)
  File "/Users/chris/Development/sqltest/lib/python2.6/site-packages/SQLAlchemy-0.6.1-py2.6.egg/sqlalchemy/engine/base.py", line 1268, in __execute_context
    context.parameters[0](0), context=context)
  File "/Users/chris/Development/sqltest/lib/python2.6/site-packages/SQLAlchemy-0.6.1-py2.6.egg/sqlalchemy/engine/base.py", line 1360, in _cursor_execute
    context)
TypeError: do_execute() takes exactly 4 arguments (5 given)

This is due to a change in SQLAlchemy-0.6.1-py2.6.egg/sqlalchemy/engine/base.py
The mysql engine has a different syntax

1351     def _cursor_execute(self, cursor, statement, parameters, context=None):

1355         try:
1356             self.dialect.do_execute(
1357                                 cursor,
1358                                 statement,
1359                                 parameters,
1360                                 context)

(old was:

self.dialect.do_execute(cursor, statement, parameters, context=context)

Thanks,

Christian

Activity

sqlalchemy-bot

sqlalchemy-bot commented on Jun 9, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

yah seems like 0.6.2 will have to be a quick release, a couple others like this are in there too

sqlalchemy-bot

sqlalchemy-bot commented on Jun 9, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

0707c94

sqlalchemy-bot

sqlalchemy-bot commented on Jun 9, 2010

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed status to closed
added
bugSomething isn't working
blockerissue that must be resolved asap as it is preventing things from working
on Nov 27, 2018
added this to the 0.6.2 milestone on Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    blockerissue that must be resolved asap as it is preventing things from workingbugSomething isn't workingfirebird

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @sqlalchemy-bot

        Issue actions

          sqlalchemy 0.6.1 breaks firebird driver · Issue #1823 · sqlalchemy/sqlalchemy