First 10 failures when running tests of SQLAlchemy-Continuum 1.2.0

sa-continnum.test failures.txt

(env)[piotr@demon sqlalchemy-continuum]$ py.test --maxfail=10 tests
==================================================================================== test session starts ====================================================================================
platform linux2 -- Python 2.7.10 -- py-1.4.30 -- pytest-2.7.2
rootdir: /home/piotr/projects/sqlalchemy-continuum, inifile: 
collected 627 items 

tests/test_accessors.py ................................................................................................................
tests/test_changeset.py .........
tests/test_column_aliases.py ........................s
tests/test_column_inclusion_and_exclusion.py ......
tests/test_composite_primary_key.py ...
tests/test_configuration.py .....s.
tests/test_custom_schema.py E
tests/test_custom_version_base_class.py .
tests/test_delete.py FFF
tests/test_exotic_listener_chaining.py E
tests/test_exotic_operation_combos.py FFFFF

========================================================================================== ERRORS ===========================================================================================
_________________________________________________________________ ERROR at setup of TestCustomSchema.test_version_relations _________________________________________________________________

self = <tests.test_custom_schema.TestCustomSchema object at 0x7f0209069d90>

    def create_tables(self):
>       self.connection.execute('DROP SCHEMA IF EXISTS continuum')

tests/test_custom_schema.py:59: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:906: in execute
    return self._execute_text(object, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1054: in _execute_text
    statement, parameters
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1139: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f0209069210>, cursor = <sqlite3.Cursor object at 0x7f0208fce340>
statement = 'DROP SCHEMA IF EXISTS continuum', parameters = (), context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208fd1a10>

    def do_execute(self, cursor, statement, parameters, context=None):
>       cursor.execute(statement, parameters)
E       OperationalError: (sqlite3.OperationalError) near "SCHEMA": syntax error [SQL: 'DROP SCHEMA IF EXISTS continuum']

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:450: OperationalError
_________________________________________________ ERROR at setup of TestBeforeFlushListener.test_manual_tx_creation_with_no_actual_changes __________________________________________________

self = <tests.test_exotic_listener_chaining.TestBeforeFlushListener object at 0x7f0208bc59d0>
method = <bound method TestBeforeFlushListener.test_manual_tx_creation_with_no_actual_c...est_exotic_listener_chaining.TestBeforeFlushListener object at 0x7f0208bc59d0>>

    def setup_method(self, method):
        @sa.event.listens_for(sa.orm.Session, 'before_flush')
        def before_flush(session, ctx, instances):
            for obj in session.dirty:
                obj.name = u'Updated article'
    
        self.before_flush = before_flush
    
        TestCase.setup_method(self, method)
        self.article = self.Article()
        self.article.name = u'Some article'
        self.article.content = u'Some content'
        self.session.add(self.article)
>       self.session.commit()

tests/test_exotic_listener_chaining.py:20: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f0208bc5510>, cursor = <sqlite3.Cursor object at 0x7f0208e2eb90>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208d143d0>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
========================================================================================= FAILURES ==========================================================================================
___________________________________________________________________________ TestDelete.test_stores_operation_type ___________________________________________________________________________

self = <tests.test_delete.TestDelete object at 0x7f0209b9b4d0>

    def test_stores_operation_type(self):
>       self._delete()

tests/test_delete.py:17: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
tests/test_delete.py:11: in _delete
    self.session.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f020cbce310>, cursor = <sqlite3.Cursor object at 0x7f0208e978f0>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208d82510>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
________________________________________________________________________ TestDelete.test_creates_versions_on_delete _________________________________________________________________________

self = <tests.test_delete.TestDelete object at 0x7f0208d878d0>

    def test_creates_versions_on_delete(self):
>       self._delete()

tests/test_delete.py:22: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
tests/test_delete.py:11: in _delete
    self.session.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f0208d879d0>, cursor = <sqlite3.Cursor object at 0x7f02089515e0>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208973ad0>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
____________________________________________________________________ TestDeleteWithDeferredColumn.test_insert_and_delete ____________________________________________________________________

self = <tests.test_delete.TestDeleteWithDeferredColumn object at 0x7f020873ec90>

    def test_insert_and_delete(self):
        item = self.TextItem()
        self.session.add(item)
>       self.session.commit()

tests/test_delete.py:42: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f020873ed90>, cursor = <sqlite3.Cursor object at 0x7f020874ca40>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'TextItem'), (1, 'TextItem'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208bd6450>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'TextItem'), (1, u'TextItem'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
___________________________________________________________________ TestExoticOperationCombos2.test_insert_deleted_object ___________________________________________________________________

self = <tests.TestExoticOperationCombos2 object at 0x7f0208d148d0>

    def test_insert_deleted_object(self):
        article = self.Article()
        article.name = u'Some article'
        article.content = u'Some content'
        self.session.add(article)
        self.session.flush()
>       self.session.commit()

tests/test_exotic_operation_combos.py:11: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f0208d14810>, cursor = <sqlite3.Cursor object at 0x7f0208310ce0>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f02083cc390>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
_____________________________________________________________ TestExoticOperationCombos2.test_insert_deleted_and_flushed_object _____________________________________________________________

self = <tests.TestExoticOperationCombos2 object at 0x7f02083bbe50>

    def test_insert_deleted_and_flushed_object(self):
        article = self.Article()
        article.name = u'Some article'
        article.content = u'Some content'
        self.session.add(article)
>       self.session.commit()

tests/test_exotic_operation_combos.py:26: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f02083bbd10>, cursor = <sqlite3.Cursor object at 0x7f02085209d0>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f02082a2f90>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
____________________________________________________________ TestExoticOperationCombos2.test_replace_deleted_object_with_update _____________________________________________________________

self = <tests.TestExoticOperationCombos2 object at 0x7f02082a9410>

    def test_replace_deleted_object_with_update(self):
        article = self.Article()
        article.name = u'Some article'
        article.content = u'Some content'
        article2 = self.Article()
        article2.name = u'Another article'
        article2.content = u'Some other content'
        self.session.add(article)
        self.session.add(article2)
>       self.session.commit()

tests/test_exotic_operation_combos.py:48: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f02082a9690>, cursor = <sqlite3.Cursor object at 0x7f02089bca40>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f02085c7810>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
___________________________________________________________________ TestExoticOperationCombos2.test_insert_flushed_object ___________________________________________________________________

self = <tests.TestExoticOperationCombos2 object at 0x7f02089d4190>

    def test_insert_flushed_object(self):
        article = self.Article()
        article.name = u'Some article'
        article.content = u'Some content'
        self.session.add(article)
        self.session.flush()
>       self.session.commit()

tests/test_exotic_operation_combos.py:65: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f020b765890>, cursor = <sqlite3.Cursor object at 0x7f02080fa730>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f0208982550>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
___________________________________________________________________ TestExoticOperationCombos5.test_insert_deleted_object ___________________________________________________________________

self = <tests.TestExoticOperationCombos5 object at 0x7f02089756d0>

    def test_insert_deleted_object(self):
        article = self.Article()
        article.name = u'Some article'
        article.content = u'Some content'
        self.session.add(article)
        self.session.flush()
>       self.session.commit()

tests/test_exotic_operation_combos.py:11:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:790: in commit
    self.transaction.commit()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:392: in commit
    self._prepare_impl()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:372: in _prepare_impl
    self.session.flush()
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2004: in flush
    self._flush(objects)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2122: in _flush
    transaction.rollback(_capture_exception=True)
env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py:60: in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/orm/session.py:2086: in _flush
    flush_context.execute()
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:373: in execute
    rec.execute(self)
env/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py:532: in execute
    uow
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:174: in save_obj
    mapper, table, insert)
env/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py:748: in _emit_insert_statements
    execute(statement, multiparams)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:914: in execute
    return meth(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:323: in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1010: in _execute_clauseelement
    compiled_sql, distilled_params
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1146: in _execute_context
    context)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1341: in _handle_dbapi_exception
    exc_info
env/lib/python2.7/site-packages/sqlalchemy/util/compat.py:199: in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
env/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1116: in _execute_context
    context)
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x7f0208975390>, cursor = <sqlite3.Cursor object at 0x7f0208630880>
statement = 'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)', parameters = ((1, 'Article'), (1, 'Article'), (1, 'Article'))
context = <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x7f02081decd0>

    def do_executemany(self, cursor, statement, parameters, context=None):
>       cursor.executemany(statement, parameters)
E       IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: transaction_changes.transaction_id, transaction_changes.entity_name [SQL: u'INSERT INTO transaction_changes (transaction_id, entity_name) VALUES (?, ?)'] [parameters: ((1, u'Article'), (1, u'Article'), (1, u'Article'))]

env/lib/python2.7/site-packages/sqlalchemy/engine/default.py:447: IntegrityError
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Interrupted: stopping after 10 failures !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
================================================================= 8 failed, 161 passed, 2 skipped, 2 error in 18.19 seconds =================================================================
(env)[piotr@demon sqlalchemy-continuum]$