Script for validating data return for explain plan.

gistfile1.txt

import MySQLdb

def doit(database, query):
    connection = MySQLdb.connect(db=database)
    try:
        cursor = connection.cursor()
        try:
            cursor.execute(query)
            columns = []
            if cursor.description:
                for column in cursor.description:
                    columns.append(column[0])
            rows = cursor.fetchall()
            if not columns and not rows:
                return None
            return (columns, rows)
        except:
            pass
        finally:
            cursor.close()
    finally:
        connection.close()

print doit("mydbname", "EXPLAIN SELECT * FROM UERequest")