# 示例：Flask 接口 (Python)
from flask import Flask, jsonify
import pymysql

app = Flask(__name__)

@app.route('/check-error-report')
def check_maq_report():
    try:
        conn = pymysql.connect(host='47.99.65.48', user='RemoteUser', password='TAI#wzp@2020', database='ots-sand')
        cursor = conn.cursor()
        cursor.execute("""
            SELECT COUNT(*) FROM `t_exam_report`
            WHERE finish = 1
              AND product_name LIKE '%MAQ%'
              AND question_report LIKE '[{"questionOrder":0,%'
        """)
        count = cursor.fetchone()[0]
        conn.close()

        if count > 1:
            # 返回错误状态让 Uptime Kuma 告警
            return jsonify({"status": "error", "count": count}), 500
        else:
            return jsonify({"status": "ok", "count": count}), 200
    except Exception as e:
        return jsonify({"error": str(e)}), 500


if __name__ == '__main__':
    app.run(host='0.0.0.0', port=5000)