- edited description
py3k support for MySQLdb via mysqlclient
Issue #3358
resolved
sqlalchemy HEAD, mysql 5.5.38, mysqlclient 1.3.6,
mysql=mysql+mysqldb://user:password@localhost/test_schema
running
`py.test --db mysql --dropfirst --backend-only`
(I get the same table users exists errors with mysql-connector)
```
platform darwin -- Python 3.4.3 -- py-1.4.26 -- pytest-2.7.0 --
==================================== ERRORS ====================================
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_autoincrement_col
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_deprecated_get_primary_keys
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_dialect_initialize
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
___ ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_columns ___
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_columns_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_default_schema_name
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_foreign_keys _
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_foreign_keys_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
___ ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_indexes ___
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_indexes_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_pk_constraint
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_pk_constraint_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_schema_names _
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
_ ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_table_names _
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_table_names_fks
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_table_names_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
__ ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_table_oid __
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_table_oid_with_schema
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_tables_and_views
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_temp_table_columns
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_temp_table_indexes
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_temp_table_names
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_temp_table_unique_constraints
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
ERROR at setup of ComponentReflectionTest_mysql_mysqldb.test_get_temp_view_columns
Traceback (most recent call last):
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'users' already exists")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "$site/_pytest/runner.py", line 403, in prepare
col.setup()
File "$site/_pytest/python.py", line 548, in setup
setup_class(self.obj)
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "$path/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "$path/test/../lib/sqlalchemy/sql/schema.py", line 3611, in create_all
tables=tables)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1843, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1471, in _run_visitor
**kwargs).traverse_single(element)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 727, in visit_metadata
_is_metadata_operation=True)
File "$path/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 761, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "$path/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception
exc_info
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 181, in reraise
raise value.with_traceback(tb)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 371, in _query
rowcount = self._do_query(q)
File "$site/MySQLdb/cursors.py", line 335, in _do_query
db.query(q)
File "$site/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1050, "Table 'users' already exists") [SQL: '\nCREATE TABLE test_schema.users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\ttest1 CHAR(5) NOT NULL, \n\ttest2 FLOAT(5) NOT NULL, \n\tparent_user_id INTEGER, \n\tPRIMARY KEY (user_id), \n\tFOREIGN KEY(parent_user_id) REFERENCES test_schema.users (user_id)\n)ENGINE=InnoDB\n\n']
=================================== FAILURES ===================================
________________ TypesTest_mysql_mysqldb.test_bit_50_roundtrip _________________
Traceback (most recent call last):
File "<string>", line 2, in test_bit_50_roundtrip
File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 95, in decorate
return self._do(config._current, fn, *args, **kw)
File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 124, in _do
self._expect_failure(config, ex, name=fn.__name__)
File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 136, in _expect_failure
util.raise_from_cause(ex)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 182, in reraise
raise value
File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 122, in _do
return_value = fn(*args, **kw)
File "<string>", line 2, in test_bit_50_roundtrip
File "$path/test/../lib/sqlalchemy/testing/util.py", line 195, in provide_metadata
return fn(*args, **kw)
File "$path/test/dialect/mysql/test_types.py", line 336, in test_bit_50_roundtrip
roundtrip([0, 0, 0, 0, i, i, i, i])
File "$path/test/dialect/mysql/test_types.py", line 320, in roundtrip
row = table.select().execute().first()
File "$path/test/../lib/sqlalchemy/sql/base.py", line 386, in execute
return e._execute_clauseelement(self, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1985, in _execute_clauseelement
return connection._execute_clauseelement(elem, multiparams, params)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1335, in _handle_dbapi_exception
util.reraise(*exc_info)
File "$path/test/../lib/sqlalchemy/util/compat.py", line 182, in reraise
raise value
File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute
cursor.execute(statement, parameters)
File "$site/MySQLdb/cursors.py", line 220, in execute
self.errorhandler(self, exc, value)
File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
File "$site/MySQLdb/cursors.py", line 209, in execute
r = self._query(query)
File "$site/MySQLdb/cursors.py", line 372, in _query
self._post_get_result()
File "$site/MySQLdb/cursors.py", line 376, in _post_get_result
self._rows = self._fetch_row(0)
File "$site/MySQLdb/cursors.py", line 344, in _fetch_row
return self._result.fetch_row(size, self._fetch_type)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start byte
=========================== short test summary info ============================
FAIL test/dialect/mysql/test_types.py::TypesTest_mysql_mysqldb::()::test_bit_50_roundtrip
!!!!!!!!!!!!!!!!!!! Interrupted: stopping after 25 failures !!!!!!!!!!!!!!!!!!!!
========= 1 failed, 86 passed, 344 skipped, 24 error in 52.00 seconds ==========
```
Comments (11)
-
reporter
-
repo owner
you need to run with -x so we can see where the failures begin. The "users exist" thing is very likely just the setup/teardown of something else failing.
The test suite has never been run against "mysqlclient" before as this is a new DBAPI, and the "MySQLdb" series of dialects have never been tested for Python 3 so there are likely many issues to be resolved.
PyMySQL is the client that works for now.
As for mysql-connector, that DBAPI should be passing all tests for Python 3, here is the latest jenkins run that's against both pymysql and mysql-connector at the same time in four child processes: http://jenkins.sqlalchemy.org/job/sqlalchemy-default-mysql-multi-3.3/373/console
-
repo owner
- changed milestone to 1.0.xx
- changed title to py3k support for MySQLdb via mysqlclient
-
reporter
with -x and more debugging info
DEBUG:sqlalchemy.pool.QueuePool:Created new connection <_mysql.connection open to 'localhost' at 7fd7d9060018> INFO:sqlalchemy.engine.base.Engine:SHOW VARIABLES LIKE 'sql_mode' INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:SELECT DATABASE() INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin' INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1 INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1 INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1 INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW FULL TABLES FROM `test_schema` INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW FULL TABLES FROM `test_schema` INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Created new connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW FULL TABLES FROM `test_schema` INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW FULL TABLES FROM `test_schema` INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> rollback-on-return ============================= test session starts ============================== platform darwin -- Python 3.4.3 -- py-1.4.26 -- pytest-2.7.0 -- collecting ... DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT CURRENT_TIMESTAMP AS current_timestamp_1 INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW VARIABLES LIKE 'lower_case_table_names' INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW VARIABLES LIKE 'lower_case_table_names' INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW VARIABLES LIKE 'lower_case_table_names' INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da1c1418> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW VARIABLES LIKE 'lower_case_table_names' INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7d9060018> rollback-on-return collected 1846 items test/dialect/mysql/test_types.py::TypesTest_mysql_mysqldb::test_bit_50_roundtrip FAILEDINFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 INFO:sqlalchemy.pool.QueuePool:Pool recreating =================================== FAILURES =================================== ________________ TypesTest_mysql_mysqldb.test_bit_50_roundtrip _________________ Traceback (most recent call last): File "<string>", line 2, in test_bit_50_roundtrip File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 95, in decorate return self._do(config._current, fn, *args, **kw) File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 124, in _do self._expect_failure(config, ex, name=fn.__name__) File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 136, in _expect_failure util.raise_from_cause(ex) File "$path/test/../lib/sqlalchemy/util/compat.py", line 188, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) File "$path/test/../lib/sqlalchemy/util/compat.py", line 182, in reraise raise value File "$path/test/../lib/sqlalchemy/testing/exclusions.py", line 122, in _do return_value = fn(*args, **kw) File "<string>", line 2, in test_bit_50_roundtrip File "$path/test/../lib/sqlalchemy/testing/util.py", line 195, in provide_metadata return fn(*args, **kw) File "$path/test/dialect/mysql/test_types.py", line 336, in test_bit_50_roundtrip roundtrip([0, 0, 0, 0, i, i, i, i]) File "$path/test/dialect/mysql/test_types.py", line 320, in roundtrip row = table.select().execute().first() File "$path/test/../lib/sqlalchemy/sql/base.py", line 386, in execute return e._execute_clauseelement(self, multiparams, params) File "$path/test/../lib/sqlalchemy/engine/base.py", line 1985, in _execute_clauseelement return connection._execute_clauseelement(elem, multiparams, params) File "$path/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "$path/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "$path/test/../lib/sqlalchemy/engine/base.py", line 1335, in _handle_dbapi_exception util.reraise(*exc_info) File "$path/test/../lib/sqlalchemy/util/compat.py", line 182, in reraise raise value File "$path/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "$path/test/../lib/sqlalchemy/engine/default.py", line 442, in do_execute cursor.execute(statement, parameters) File "$site/MySQLdb/cursors.py", line 220, in execute self.errorhandler(self, exc, value) File "$site/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorvalue File "$site/MySQLdb/cursors.py", line 209, in execute r = self._query(query) File "$site/MySQLdb/cursors.py", line 372, in _query self._post_get_result() File "$site/MySQLdb/cursors.py", line 376, in _post_get_result self._rows = self._fetch_row(0) File "$site/MySQLdb/cursors.py", line 344, in _fetch_row return self._result.fetch_row(size, self._fetch_type) UnicodeDecodeError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start byte ----------------------------- Captured stderr call ----------------------------- DEBUG:sqlalchemy.pool.QueuePool:Created new connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DESCRIBE `mysql_bits` INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:ROLLBACK INFO:sqlalchemy.engine.base.Engine: CREATE TABLE mysql_bits ( b1 BIT, b2 BIT, b3 BIT NOT NULL, b4 BIT(1), b5 BIT(8), b6 BIT(32), b7 BIT(63), b8 BIT(64) ) INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SHOW CREATE TABLE `mysql_bits` INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:INSERT INTO mysql_bits (b1, b2, b3, b4, b5, b6, b7, b8) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) INFO:sqlalchemy.engine.base.Engine:(0, 0, 0, 0, 0, 0, 0, 0) INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT mysql_bits.b1, mysql_bits.b2, mysql_bits.b3, mysql_bits.b4, mysql_bits.b5, mysql_bits.b6, mysql_bits.b7, mysql_bits.b8 FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DELETE FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:INSERT INTO mysql_bits (b1, b2, b3, b4, b5, b6, b7, b8) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) INFO:sqlalchemy.engine.base.Engine:(None, None, 0, None, None, None, None, None) INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT mysql_bits.b1, mysql_bits.b2, mysql_bits.b3, mysql_bits.b4, mysql_bits.b5, mysql_bits.b6, mysql_bits.b7, mysql_bits.b8 FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DELETE FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:INSERT INTO mysql_bits (b1, b2, b3, b4, b5, b6, b7, b8) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) INFO:sqlalchemy.engine.base.Engine:(1, 1, 1, 1, 1, 1, 1, 1) INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT mysql_bits.b1, mysql_bits.b2, mysql_bits.b3, mysql_bits.b4, mysql_bits.b5, mysql_bits.b6, mysql_bits.b7, mysql_bits.b8 FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DELETE FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:INSERT INTO mysql_bits (b1, b2, b3, b4, b5, b6, b7, b8) VALUES (b'1', b'1', b'1', b'1', b'1', b'1', b'1', b'1') INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT mysql_bits.b1, mysql_bits.b2, mysql_bits.b3, mysql_bits.b4, mysql_bits.b5, mysql_bits.b6, mysql_bits.b7, mysql_bits.b8 FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DELETE FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:INSERT INTO mysql_bits (b1, b2, b3, b4, b5, b6, b7, b8) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) INFO:sqlalchemy.engine.base.Engine:(0, 0, 0, 0, 255, 255, 255, 255) INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:SELECT mysql_bits.b1, mysql_bits.b2, mysql_bits.b3, mysql_bits.b4, mysql_bits.b5, mysql_bits.b6, mysql_bits.b7, mysql_bits.b8 FROM mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:ROLLBACK DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> checked out from pool INFO:sqlalchemy.engine.base.Engine:DESCRIBE `mysql_bits` INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine: DROP TABLE mysql_bits INFO:sqlalchemy.engine.base.Engine:() INFO:sqlalchemy.engine.base.Engine:COMMIT DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> being returned to pool DEBUG:sqlalchemy.pool.QueuePool:Connection <_mysql.connection open to 'localhost' at 7fd7da9a5218> rollback-on-return =========================== short test summary info ============================ FAIL test/dialect/mysql/test_types.py::TypesTest_mysql_mysqldb::()::test_bit_50_roundtrip !!!!!!!!!!!!!!!!!!!! Interrupted: stopping after 1 failures !!!!!!!!!!!!!!!!!!!! =============== 1 failed, 66 passed, 11 skipped in 67.54 seconds =============== -
repo owner
this looks like a bug in the DBAPI, because its choking on data coming back from the DB:
#! File "$site/MySQLdb/cursors.py", line 209, in execute r = self._query(query) File "$site/MySQLdb/cursors.py", line 372, in _query self._post_get_result() File "$site/MySQLdb/cursors.py", line 376, in _post_get_result self._rows = self._fetch_row(0) File "$site/MySQLdb/cursors.py", line 344, in _fetch_row return self._result.fetch_row(size, self._fetch_type) UnicodeDecodeError: 'utf-8' codec can't decode byte 0xff in position 0: invalid start bytecan you construct a standalone DBAPI test (no SQLAlchemy) that loads a row from a table using the BIT type? thanks. Post an issue to their tracker at https://github.com/PyMySQL/mysqlclient-python.
-
I haven't used BIT field type yet. What is the recommended type for conversion?
-
repo owner
@methane: isn't mysqlclient a direct C port of MySQLdb? What does MySQLdb do? Heck what does PyMySQL do?
-
They doesn't process BIT type. "doesn't process" means returns string/bytes what MySQL returns. In this case, mysqlclient can return bytes instead of str. I'll do it for now.
-
reporter
with https://bitbucket.org/zzzeek/sqlalchemy/pull-request/53/mysqldb-supports-unicode mysqlclient HEAD passes the testsuite
-
repo owner
-
repo owner
- changed status to resolved
- Log in to comment
