import functools from flask import ( Blueprint, flash, g, redirect, render_template, request, session, url_for, abort ) from werkzeug.security import check_password_hash, generate_password_hash from webapp.db import get_db bp = Blueprint('auth', __name__, url_prefix='/auth') @bp.route('/login', methods=('GET', 'POST')) def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] db = get_db() error = None user = db.execute( 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.username = ?', (username,) ).fetchone() if user is None: error = 'Incorrect username.' elif not check_password_hash(user['password'], password): error = 'Incorrect password.' if error is None: session.clear() session['user_id'] = user['id'] session['user_perm'] = user['name'] return redirect(url_for('index')) flash(error) """db.execute( "insert into user (username,password,perm) values (?,?,?)", ('mir', generate_password_hash('Dupago'), 9),) db.commit()""" return render_template('auth/login.html') @bp.before_app_request def load_logged_in_user(): user_id = session.get('user_id') if user_id is None: g.user = None else: g.user = get_db().execute( 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.id = ?', (user_id,) ).fetchone() @bp.route('/logout') def logout(): session.clear() return redirect(url_for('index')) def login_required(view): @functools.wraps(view) def wrapped_view(**kwargs): if g.user is None: return redirect(url_for('auth.login')) return view(**kwargs) return wrapped_view @bp.route('/register', methods=('GET', 'POST')) @login_required def register(): if request.method == 'POST': if session.get('user_perm') != 'ADMIN': abort(403) username = request.form['username'] password = request.form['password'] confirm = request.form['confirm'] perm = request.form['perm'] db = get_db() error = None if not username: error = 'Username is required.' elif not password: error = 'Password is required.' elif password != confirm: error = 'Confirmation of password failed.' if error is None: if not perm: perm = 'USER' else: perm = perm.upper() try: row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone() db.execute( "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)", (username, generate_password_hash(password), row[0]), ) db.commit() except db.IntegrityError: error = f"User {username} is already registered." except TypeError: error = f"Permission '{perm}' is invalid." else: return redirect(url_for("dashboard.index")) flash(error) perms = get_db().execute('SELECT name FROM permissions').fetchall() return render_template('auth/register.html', perms=[row[0] for row in perms]) @bp.route('/changepwd/', methods=('GET', 'POST')) @login_required def changepwd(id): if request.method == 'POST': oldpwd = request.form['oldpwd'] password = request.form['password'] confirm = request.form['confirm'] db = get_db() error = None id = int(id) print(f"id: {id} oldpwd: {oldpwd} password: {password} confirm: {confirm} new: {generate_password_hash(password)} perm: {session.get('user_perm')}") user = db.execute( "select * from user where id = ?", (id, ) ).fetchone() if session.get('user_perm') == 'ADMIN': if not password: error = 'Password is required.' elif password != confirm: error = 'Confirmation of password failed.' else: if not oldpwd: error = 'Old Password is required.' elif not password: error = 'Password is required.' elif password != confirm: error = 'Confirmation of password failed.' elif not check_password_hash(user['password'], oldpwd): error = "Incorrect old Password." if error is None: try: db.execute( "UPDATE user SET password = ? WHERE id = ?", (generate_password_hash(password), id), ) db.commit() except db.IntegrityError: error = "User does not exist." except TypeError: error = "Permission is invalid." else: return redirect(url_for("dashboard.index")) flash(error) return render_template('auth/changepwd.html') @bp.route('/update', methods=('GET', 'POST')) @login_required def update(): if request.method == 'POST': if session.get('user_perm') != 'ADMIN': abort(403) username = request.form['username'] password = request.form['password'] perm = request.form['perm'] db = get_db() error = None if not username: error = 'Username is required.' elif not password: error = 'Password is required.' if error is None: if not perm: perm = 'USER' else: perm = perm.upper() try: row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone() db.execute( "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)", (username, generate_password_hash(password), row[0]), ) db.commit() except db.IntegrityError: error = f"User {username} is already registered." except TypeError: error = f"Permission '{perm}' is invalid." else: return redirect(url_for("dashboard.index")) flash(error) perm = get_db().execute("""SELECT * FROM permissions""").fetchall() user = get_db().execute(""" SELECT u.id, u.username, p.name FROM user u join permissions p on u.perm = p.id """).fetchall() return render_template('auth/update.html', perms=perm, users=user) @bp.route('/userupdate/', methods=('POST',)) @login_required def userupdate(id): if session.get('user_perm') != 'ADMIN': abort(403) content = request.json id = int(id) perm_id = content['perm_id'] print("Updating {0} perm = {1}".format(id, perm_id)) db = get_db() try: db.execute( "UPDATE user set perm = ? where id = ?", (perm_id, id), ) db.commit() except db.IntegrityError: error = f"User {id} does not exist." except TypeError: error = f"Permission '{perm_id}' is invalid." else: return render_template('dashboard/index.html') # logger.error(error) @bp.route('/userdelete/', methods=('POST',)) @login_required def userdelete(id): if session.get('user_perm') != 'ADMIN': abort(403) print("Deleting {0}".format(id)) id = int(id) db = get_db() try: db.execute( "DELETE FROM user where id = ?", (id, ), ) db.commit() except db.IntegrityError: error = f"User {id} does not exist." else: return render_template('dashboard/index.html') # logger.error(error)