1gTKC2pg

1def create_temp_table():
2    cnx = connect_mysql('username', 'password', 'host', 'db')
3    cursor = cnx.cursor()
4    try:
5        create_table_query = "CREATE TEMPORARY TABLE IF NOT EXISTS temptable (id INT UNSIGNED NOT NULL, val1 VARCHAR(64), val2 VARCHAR(128), val3 VARCHAR(128), PRIMARY KEY (id))"
6        cursor.execute(create_table_query)
7        cnx.commit()
8        cursor.close()
9        cnx.close()
10    except:
11        cnx.close()
12        raise