login2

app.py

from flask import Flask, render_template, redirect, url_for, request

app = Flask(__name__)


def verify_login(email, password):
    stored_password = get_password(email)
    if len(stored_passsword):
        if password == stored_passsword:
            return redirect("/")
        else:
            print("wrong password")
    else:
        insert_user(email, password)
        return redirect("/")


@app.route("/login", methods=["GET", "POST"])
def login():
    if request.method == "GET":
        return render_template('login.html')
    elif request.method == "POST":
        email = request.form["email"]
        password = request.form["password"]
        verify_login(email, password)
        return redirect(url_for('index'))


@app.route("/")
def index():
    return render_template('welcome.html')


if __name__ == '__main__':
    app.run(debug=True)

create_db.py

import sqlite3

sql_query = """
    CREATE TABLE IF NOT EXISTS users(
        email TEXT PRIMARY KEY,
        password TEXT NOT NULL
    );
"""

def execute_query(sql_query):
    with sqlite3.connect("login.db") as conn:
        cur = conn.cursor()
        result = cur.execute(sql_query)
        conn.commit()
    return result

if __name__ == '__main__':
    execute_query(sql_query)

db_functions.py

import sqlite3

def execute_query(sql_query):
    with sqlite3.connect("login.db") as conn:
        cur = conn.cursor()
        result = cur.execute(sql_query)
        conn.commit()
    return result


def insert_user(email, password):
    sql_query = "INSERT INTO users(email, password) VALUES('%s', '%s') " % (email, password)
    execute_query(sql_query)


def get_password(email):
    sql_query = "SELECT password FROM users WHERE email='%s' " % (email)
    password = execute_query(sql_query).fetchall()
    return password[0][0]



if __name__ == '__main__':
    #insert_user('[email protected]', '1111')
    get_password('[email protected]')