import simplejson as json
import MySQLdb

#Better practice is to load and decrypt these values from a file
dbname = 'databaseName'
dbuser = 'username'
dbpass = 'password'
dbhost = 'host

def procedureToJSON(procedureName, inputs=''):
    dbconn=MySQLdb.connect(
         database=dbname, user=dbuser, password=dbpass, host=dbhost)
    try:
        with dbconn.cursor(MySQLdb.cursors.DictCursor) as cursor:
            if inputs == '':
                cursor.callproc(procedureName)
                data = {'data': cursor.fetchall()}
            else:
                cursor.callproc(procedureName,inputs)
                data = {'data': cursor.fetchall()}
    except Exception as e:
        error = "ERROR: " + str(e)
        return error
    return json.dumps(data,indent=4)

#Example usage
tableData = procedureToJSON('inventoryActiveInventory',[storeid_requested,])
#tableData will contain the results from the MySQL stored procedure in JSON format nested within "data"