from flask import Flask, render_template
import pymysql

app = Flask(__name__)


def get_connection():
  return pymysql.connect(
    host="bnadwttldj2i5cq9aymp-mysql.services.clever-cloud.com",
    user="uvfqvcypihhznd2u",
    port=3306,
    password="CX6TBadRQYFqprozqDTo",
    database="bnadwttldj2i5cq9aymp"
  )


@app.route("/")
def index():
    
  db = get_connection()
  cursor = db.cursor()
  

  cursor.execute("SELECT * FROM users")
  data = cursor.fetchall()

  cursor.close()
  db.close()

  return render_template("index.html", data=data)

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