So I'm aware of what this problem is. I'd like to know how to catch this Exception in my Flask program. I'm using the Flask extension for MySQL.
from flask import Flask, jsonify, render_template, request, json
from flaskext.mysql import MySQL
mysql = MySQL()
mysql.init_app(app)
conn = mysql.connect()
cursor = conn.cursor()
@app.route("/authenticate")
def authenticate():
try:
cursor.execute("SELECT * from User")
data = cursor.fetchone()
return jsonify(result={"status":"ok")
except SQL_TIME_OUT_EXCEPTION? #<---- HOW TO CATCH (2006, 'MySQL server has gone away') EXCEPTION
except Exception as e:
return jsonify(result={"status":"failed"})
glenn
|
9498
posts
|
PythonAnywhere staff
|
