Handler for mysql queries, intended for data dashboards. (Not data management)

USE THIS SCRIPT WITH CAUTION. IF YOU DO NOT HAVE ANY EXPERIENCE WITH SQL INJECTION THEN DO NOT USE WITH USER INPUT. THE SCRIPT REQUIRES SOME EXPERIENCE WITH SQL SYNTAX.

Setup config.py.

Use your MySQL credentials. Update directly in file

Perform QUERY.

Example:

query = mysqlQuery().select('something').table('someTable').where('something', 'islogical', 'toSomething').where('someOtherThing', 'isLogical', 'TosomeOtherThing').execute()

Extract data.

data = query.data