def test_rollback_deadlock(self):
    'test that returning connections to the pool clears any object\n        locks.'
    conn1 = testing.db.connect()
    conn2 = testing.db.connect()
    users = Table('deadlock_users', metadata, Column('user_id', INT, primary_key=True), Column('user_name', VARCHAR(20)), test_needs_acid=True)
    with conn1.begin():
        users.create(conn1)
    conn1.exec_driver_sql('select * from deadlock_users')
    conn1.close()
    with conn2.begin():
        users.drop(conn2)
    conn2.close()
test that returning connections to the pool clears any object
locks.
def test_rollback_deadlock(self):
    'test that returning connections to the pool clears any object\n        locks.'
    conn1 = testing.db.connect()
    conn2 = testing.db.connect()
    users = Table('deadlock_users', metadata, Column('user_id', INT, primary_key=True), Column('user_name', VARCHAR(20)), test_needs_acid=True)
    with conn1.begin():
        users.create(conn1)
    conn1.exec_driver_sql('select * from deadlock_users')
    conn1.close()
    with conn2.begin():
        users.drop(conn2)
    conn2.close()