Unit test failures with sqlalchemy 1.0.6

Bug #1469501 reported by Thomas Goirand
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
sqlalchemy-migrate
New
Undecided
Unassigned

Bug Description

Migrate fails unit tests with the python-sqlalchemy package currently in Sid. We need to fix this ASAP. It'd be good if we could switch everything to SQLA 1.0.x anyway, as it brings a lot of nice enhancements (like full support for ALTER with SQLite, which has always been a big issue for SQLite support).

======================================================================
FAIL: migrate.tests.changeset.test_constraint.TestConstraint.test_define_fk
migrate.tests.changeset.test_constraint.TestConstraint.test_define_fk
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_define_fk
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 96, in dec
    f(self, *a, **kw)
  File "migrate/tests/changeset/test_constraint.py", line 95, in test_define_fk
    self.assertEqual(key, self.table.c.fkey.name)
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 338, in assertEqual
    self.assertThat(observed, matcher, message)
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 423, in assertThat
    raise mismatch_error
MismatchError: !=:
reference = Column('fkey', Integer(), ForeignKey(u'mytable.id'), table=<mytable>, nullable=False)
actual = u'fkey'

======================================================================
FAIL: migrate.tests.versioning.test_database.TestConnect.test_connect
migrate.tests.versioning.test_database.TestConnect.test_connect
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_connect
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 96, in dec
    f(self, *a, **kw)
  File "migrate/tests/versioning/test_database.py", line 11, in test_connect
    select(['42'],bind=self.engine).execute()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/base.py", line 386, in execute
    return e._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1994, in _execute_clauseelement
    return connection._execute_clauseelement(elem, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (_mysql_exceptions.OperationalError) (1054, "Unknown column '42' in 'field list'") [SQL: u'SELECT `42`']

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_changeset
migrate.tests.versioning.test_schema.TestControlledSchema.test_changeset
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_changeset
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_compare_model_to_db
migrate.tests.versioning.test_schema.TestControlledSchema.test_compare_model_to_db
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_compare_model_to_db
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_create_model
migrate.tests.versioning.test_schema.TestControlledSchema.test_create_model
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_create_model
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_update_db_from_model
migrate.tests.versioning.test_schema.TestControlledSchema.test_update_db_from_model
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_update_db_from_model
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_upgrade_runchange
migrate.tests.versioning.test_schema.TestControlledSchema.test_upgrade_runchange
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_upgrade_runchange
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control
migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_version_control
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control_invalid
migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control_invalid
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_version_control_invalid
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control_specified
migrate.tests.versioning.test_schema.TestControlledSchema.test_version_control_specified
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
  File "<string>", line 2, in test_version_control_specified
  File "migrate/tests/fixture/database.py", line 109, in dec
    six.reraise(*fail)
  File "migrate/tests/fixture/database.py", line 93, in dec
    raise RuntimeError('Exception during _setup(): %r' % e)
RuntimeError: Exception during _setup(): ValueError('In File: migrate/tests/versioning/test_schema.py\nTestCase.setUp was already called. Do not explicitly call setUp from your tests. In your own setUp, use super to call the base setUp.',)

======================================================================
FAIL: process-returncode
process-returncode
----------------------------------------------------------------------
_StringException: returncode 1

----------------------------------------------------------------------
Ran 175 tests in 212.169s

FAILED (failures=11)
Total tests: 175
Passed tests: 164
Failed tests: 11
Skipped tests: 0
Seen tags: worker-0
Test id Runtime (s)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.