from flask import Flask

app = Flask(__name__)

@app.route("/")
def index():
    return "Hej från Python!"

@app.route("/test")
def test():
    return "Det här är en Python-backend."

@app.route("/personer")
def personer():
    import mariadb

    conn = mariadb.connect(
        host="localhost",
        user="python_test",
        password="uffe",
        database="python_test"
    )

    cursor = conn.cursor()
    cursor.execute("SELECT id, namn FROM personer")

    rows = cursor.fetchall()

    cursor.close()
    conn.close()

    html = "<h1>Personer</h1>"

    for id, namn in rows:
        html += f"<p>{id} - {namn}</p>"

    return html

app.run(host="127.0.0.1", port=8080)