def test_no_expire_on_commit(self): sess = sessionmaker(expire_on_commit=False)() u1 = User(name='ed') sess.add(u1) sess.commit() testing.db.execute(users.update(users.c.name=='ed').values(name='edward')) assert u1.name == 'ed' sess.expire_all() assert u1.name == 'edward'
def test_rollback_no_accounting(self): sess = sessionmaker(_enable_transaction_accounting=False)() u1 = User(name='ed') sess.add(u1) sess.commit() u1.name = 'edwardo' sess.rollback() testing.db.execute(users.update(users.c.name=='ed').values(name='edward')) assert u1.name == 'edwardo' sess.expire_all() assert u1.name == 'edward'
def test_commit_no_accounting(self): sess = sessionmaker(_enable_transaction_accounting=False)() u1 = User(name='ed') sess.add(u1) sess.commit() u1.name = 'edwardo' sess.rollback() testing.db.execute(users.update(users.c.name=='ed').values(name='edward')) assert u1.name == 'edwardo' sess.commit() assert testing.db.execute(select([users.c.name])).fetchall() == [('edwardo',)] assert u1.name == 'edwardo' sess.delete(u1) sess.commit()