from flask import Flask, session, redirect, url_for, render_template, request, flash, session
from manages import LoginForm, RegisterForm
from flask_bcrypt import Bcrypt
from sqlalchemy import *

app = Flask(__name__)
bcrypt = Bcrypt(app)

@app.route("/login", methods=["GET", "POST"])
def login():
    form = LoginForm(request.form)
    if request.method == "POST" and form.validate():
        email = form.email.data
        c = create_engine("mysql://user:password@localhost/databases")
        con = c.connect()
        res = con.execute("SELECT * FROM user WHERE email = ('"+email+"')")
        for row in res:
            if res is not None and bcrypt.check_password_hash(row['password'], request.form['password']):
                return redirect(url_for('home.index'))
                session['logged_in'] = True
                con.close()
            else:
                flash("Password atau email anda salah silahkan coba lagi!")
                return render_template("user.html", form=form)
    return render_template("user.html", form=form)
@app.route("/register", methods=["GET", "POST"])
def register():
    form = RegisterForm(request.form)
    if request.method == "POST" and form.validate():
        name = form.name.data
        email = form.email.data
        password = bcrypt.generate_password_hash(form.password.data)
        c = create_engine("mysql://user:password@localhost/databases")
        con = c.connect()
        res = con.execute("SELECT * FROM user WHERE email = ('"+email+"')")
        if res is not None:
            flash("Email sudah digunakan silahkan gunakan email lainnya atau Login")
            return render_template("register.html", form=form)
        else:
            con.execute("INSERT INTO user(name, email, password) VALUES('"+name+"', '"+email+"', '"+password+"')")
            session['logged_in'] = True
            return redirect(url_for('home.index'))
            con.close()

    return render_template('register.html')

if __name__ == "__main__":
        app.run()