Temporary table hack for SQLAlchemy unit tests

gistfile1.py

def create_temporary_tables(conn, cursor, statement, parameters, context, executemany):
    if statement.startswith('CREATE TABLE '):
        statement = 'CREATE TEMPORARY TABLE ' + statement[13:]
    return statement, parameters


def setup_module():
    global connection, engine

    # Connect to the database and create the schema within a transaction
    engine = create_engine('mysql:///user:pass@yourdb')
    connection = engine.connect()
    listen(connection, "before_cursor_execute", create_temporary_tables, retval=True)
    Base.metadata.create_all(connection)


def teardown_module():
    # Disconnect from the database
    connection.close()
    engine.dispose()