MemSQL healthcheck server

healthcheck.py

from flask import Flask
import torndb

## NB: this default query does not exercise leaf connectivity or
## partition health. For best results, use a query that selects
## a record from an actual data table.
SQL = "select count(1) from information_schema.processlist"
## SQL = "select * from dashboard.analytics limit 1"
## SQL = "show databases extended"

app = Flask(__name__)

@app.route("/memsql-healthcheck")
def ping():
    try:
        conn = torndb.Connection(host="127.0.0.1:3306", user = "root", database = 'information_schema')
        rows = conn.query(SQL)
        return str(rows)
        if rows:
            return "OK"
        else:
            return ":("
    except:
        return ":("

if __name__ == "__main__":
    app.run(port=6033, host="0.0.0.0")