]> git.datanom.net - liogui.git/blob - webapp/auth.py
Completed User Administration
[liogui.git] / webapp / auth.py
1 import functools
2 from flask import (
3 Blueprint, flash, g, redirect, render_template, request, session, url_for, abort
4 )
5 from werkzeug.security import check_password_hash, generate_password_hash
6
7
8 from webapp.db import get_db
9
10 bp = Blueprint('auth', __name__, url_prefix='/auth')
11
12 @bp.route('/login', methods=('GET', 'POST'))
13 def login():
14 if request.method == 'POST':
15 username = request.form['username']
16 password = request.form['password']
17 db = get_db()
18 error = None
19 user = db.execute(
20 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.username = ?', (username,)
21 ).fetchone()
22
23 if user is None:
24 error = 'Incorrect username.'
25 elif not check_password_hash(user['password'], password):
26 error = 'Incorrect password.'
27
28 if error is None:
29 session.clear()
30 session['user_id'] = user['id']
31 session['user_perm'] = user['name']
32 return redirect(url_for('index'))
33
34 flash(error)
35 """db.execute(
36 "insert into user (username,password,perm) values (?,?,?)",
37 ('mir', generate_password_hash('Dupago'), 9),)
38 db.commit()"""
39
40 return render_template('auth/login.html')
41
42 @bp.before_app_request
43 def load_logged_in_user():
44 user_id = session.get('user_id')
45
46 if user_id is None:
47 g.user = None
48 else:
49 g.user = get_db().execute(
50 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.id = ?', (user_id,)
51 ).fetchone()
52
53 @bp.route('/logout')
54 def logout():
55 session.clear()
56 return redirect(url_for('index'))
57
58 def login_required(view):
59 @functools.wraps(view)
60 def wrapped_view(**kwargs):
61 if g.user is None:
62 return redirect(url_for('auth.login'))
63
64 return view(**kwargs)
65
66 return wrapped_view
67
68 @bp.route('/register', methods=('GET', 'POST'))
69 @login_required
70 def register():
71 if request.method == 'POST':
72 if session.get('user_perm') != 'ADMIN':
73 abort(403)
74 username = request.form['username']
75 password = request.form['password']
76 confirm = request.form['confirm']
77 perm = request.form['perm']
78 db = get_db()
79 error = None
80
81 if not username:
82 error = 'Username is required.'
83 elif not password:
84 error = 'Password is required.'
85 elif password != confirm:
86 error = 'Confirmation of password failed.'
87
88 if error is None:
89 if not perm:
90 perm = 'USER'
91 else:
92 perm = perm.upper()
93 try:
94 row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone()
95 db.execute(
96 "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
97 (username, generate_password_hash(password), row[0]),
98 )
99 db.commit()
100 except db.IntegrityError:
101 error = f"User {username} is already registered."
102 except TypeError:
103 error = f"Permission '{perm}' is invalid."
104 else:
105 return redirect(url_for("dashboard.index"))
106
107 flash(error)
108
109 perms = get_db().execute('SELECT name FROM permissions').fetchall()
110
111 return render_template('auth/register.html', perms=[row[0] for row in perms])
112
113 @bp.route('/changepwd/<id>', methods=('GET', 'POST'))
114 @login_required
115 def changepwd(id):
116 if request.method == 'POST':
117 oldpwd = request.form['oldpwd']
118 password = request.form['password']
119 confirm = request.form['confirm']
120 db = get_db()
121 error = None
122 id = int(id)
123 print(f"id: {id} oldpwd: {oldpwd} password: {password} confirm: {confirm} new: {generate_password_hash(password)} perm: {session.get('user_perm')}")
124 user = db.execute(
125 "select * from user where id = ?",
126 (id, )
127 ).fetchone()
128 if session.get('user_perm') == 'ADMIN':
129 if not password:
130 error = 'Password is required.'
131 elif password != confirm:
132 error = 'Confirmation of password failed.'
133 else:
134 if not oldpwd:
135 error = 'Old Password is required.'
136 elif not password:
137 error = 'Password is required.'
138 elif password != confirm:
139 error = 'Confirmation of password failed.'
140 elif not check_password_hash(user['password'], oldpwd):
141 error = "Incorrect old Password."
142
143 if error is None:
144 try:
145 db.execute(
146 "UPDATE user SET password = ? WHERE id = ?",
147 (generate_password_hash(password), id),
148 )
149 db.commit()
150 except db.IntegrityError:
151 error = "User does not exist."
152 except TypeError:
153 error = "Permission is invalid."
154 else:
155 return redirect(url_for("dashboard.index"))
156
157 flash(error)
158
159 return render_template('auth/changepwd.html')
160
161 @bp.route('/update', methods=('GET', 'POST'))
162 @login_required
163 def update():
164 if request.method == 'POST':
165 if session.get('user_perm') != 'ADMIN':
166 abort(403)
167 username = request.form['username']
168 password = request.form['password']
169 perm = request.form['perm']
170 db = get_db()
171 error = None
172
173 if not username:
174 error = 'Username is required.'
175 elif not password:
176 error = 'Password is required.'
177
178 if error is None:
179 if not perm:
180 perm = 'USER'
181 else:
182 perm = perm.upper()
183 try:
184 row = get_db().execute('SELECT id FROM permissions where name = ?', (perm,)).fetchone()
185 db.execute(
186 "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
187 (username, generate_password_hash(password), row[0]),
188 )
189 db.commit()
190 except db.IntegrityError:
191 error = f"User {username} is already registered."
192 except TypeError:
193 error = f"Permission '{perm}' is invalid."
194 else:
195 return redirect(url_for("dashboard.index"))
196
197 flash(error)
198
199 perm = get_db().execute("""SELECT * FROM permissions""").fetchall()
200
201 user = get_db().execute("""
202 SELECT u.id, u.username, p.name FROM
203 user u join permissions p on u.perm = p.id
204 """).fetchall()
205
206 return render_template('auth/update.html', perms=perm, users=user)
207
208 @bp.route('/userupdate/<id>', methods=('POST',))
209 @login_required
210 def userupdate(id):
211 if session.get('user_perm') != 'ADMIN':
212 abort(403)
213
214 content = request.json
215 id = int(id)
216 perm_id = content['perm_id']
217 print("Updating {0} perm = {1}".format(id, perm_id))
218 db = get_db()
219 try:
220 db.execute(
221 "UPDATE user set perm = ? where id = ?",
222 (perm_id, id),
223 )
224 db.commit()
225 except db.IntegrityError:
226 error = f"User {id} does not exist."
227 except TypeError:
228 error = f"Permission '{perm_id}' is invalid."
229 else:
230 return render_template('dashboard/index.html')
231
232 # logger.error(error)
233
234 @bp.route('/userdelete/<id>', methods=('POST',))
235 @login_required
236 def userdelete(id):
237 if session.get('user_perm') != 'ADMIN':
238 abort(403)
239
240 print("Deleting {0}".format(id))
241 id = int(id)
242 db = get_db()
243 try:
244 db.execute(
245 "DELETE FROM user where id = ?",
246 (id, ),
247 )
248 db.commit()
249 except db.IntegrityError:
250 error = f"User {id} does not exist."
251 else:
252 return render_template('dashboard/index.html')
253
254 # logger.error(error)
This page took 0.841597 seconds and 6 git commands to generate.