main.py

from flask import Flask, render_template, request, jsonify
import sqlite3

app = Flask(__name__)

@app.route("/", methods = ["POST", "GET"])
def home():
    if request.method == "POST":
        name = request.form.get("name")
        email = request.form.get("email")

        conn = sqlite3.connect("users.db")
        cur = conn.cursor()

        cur.execute("INSERT INTO USERS (name, email) VALUES (?, ?)",(name, email))
        conn.commit()
        conn.close()

        return render_template("index.html")
    else:
        return render_template("index.html")

@app.route("/api/users/<username>")
def user_api(username):
    data = {
        "name": None,
        "email": None,
        "code": None
    }

    conn = sqlite3.connect("users.db")
    cur = conn.cursor()

    cur.execute("SELECT name, email FROM USERS WHERE name = ?",(username, ))
    dbinfo = cur.fetchone()
    conn.close()

    if dbinfo != None:
        data["name"] = dbinfo[0]
        data["email"] = dbinfo[1]
        data["code"] = "Success"
    else:
        data["name"] = "N/A"
        data["email"] = "N/A"
        data["code"] = "Failure: User does not exist"
    return jsonify(data)

app.run(debug=True)