from flask import Flask, render_template_string, jsonify
import mysql.connector
app = Flask(__name__)
DB_CONFIG = {
"host": "mysql",
"user": "root",
"password": "0674998280tanya",
"database": "telegram_bot"
}
TEMPLATE = """
Zoznam porušovateľov
Zoznam porušovateľov
| Používateľ | Správa |
|---|
{% for row in data %}
| {{ row[0] }} | {{ row[1] }} |
{% endfor %}
"""
@app.route('/')
def index():
conn = mysql.connector.connect(**DB_CONFIG)
cursor = conn.cursor()
cursor.execute("SELECT username, message FROM violators ORDER BY id DESC")
data = cursor.fetchall()
cursor.close()
conn.close()
return render_template_string(TEMPLATE, data=data)
@app.route('/data')
def data():
conn = mysql.connector.connect(**DB_CONFIG)
cursor = conn.cursor()
cursor.execute("SELECT username, message FROM violators ORDER BY id DESC")
data = cursor.fetchall()
cursor.close()
conn.close()
return jsonify(data)
if __name__ == "__main__":
app.run(host='0.0.0.0', port=5000)