]>
git.datanom.net - liogui.git/blob - webapp/auth.py
3 Blueprint
, flash
, g
, redirect
, render_template
, request
, session
, url_for
, abort
5 from werkzeug
.security
import check_password_hash
, generate_password_hash
8 from webapp
.db
import get_db
10 bp
= Blueprint('auth', __name__
, url_prefix
='/auth')
12 @bp.route('/login', methods
=('GET', 'POST'))
14 if request
.method
== 'POST':
15 username
= request
.form
['username']
16 password
= request
.form
['password']
20 'SELECT u.*, p.name FROM user u join permissions p on u.perm = p.id WHERE u.username = ?', (username
,)
24 error
= 'Incorrect username.'
25 elif not check_password_hash(user
['password'], password
):
26 error
= 'Incorrect password.'
30 session
['user_id'] = user
['id']
31 session
['user_perm'] = user
['name']
32 return redirect(url_for('index'))
36 "insert into user (username,password,perm) values (?,?,?)",
37 ('mir', generate_password_hash('Dupago'), 9),)
40 return render_template('auth/login.html')
42 @bp.before_app_request
43 def load_logged_in_user():
44 user_id
= session
.get('user_id')
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
,)
56 return redirect(url_for('index'))
58 def login_required(view
):
59 @functools.wraps(view
)
60 def wrapped_view(**kwargs
):
62 return redirect(url_for('auth.login'))
68 @bp.route('/register', methods
=('GET', 'POST'))
71 if request
.method
== 'POST':
72 if session
.get('user_perm') != 'ADMIN':
74 username
= request
.form
['username']
75 password
= request
.form
['password']
76 confirm
= request
.form
['confirm']
77 perm
= request
.form
['perm']
82 error
= 'Username is required.'
84 error
= 'Password is required.'
85 elif password
!= confirm
:
86 error
= 'Confirmation of password failed.'
94 row
= get_db().execute('SELECT id FROM permissions where name = ?', (perm
,)).fetchone()
96 "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
97 (username
, generate_password_hash(password
), row
[0]),
100 except db
.IntegrityError
:
101 error
= f
"User {username} is already registered."
103 error
= f
"Permission '{perm}' is invalid."
105 return redirect(url_for("dashboard.index"))
109 perms
= get_db().execute('SELECT name FROM permissions').fetchall()
111 return render_template('auth/register.html', perms
=[row
[0] for row
in perms
])
113 @bp.route('/changepwd/<id>', methods
=('GET', 'POST'))
116 if request
.method
== 'POST':
117 oldpwd
= request
.form
['oldpwd']
118 password
= request
.form
['password']
119 confirm
= request
.form
['confirm']
123 print(f
"id: {id} oldpwd: {oldpwd} password: {password} confirm: {confirm} new: {generate_password_hash(password)} perm: {session.get('user_perm')}")
125 "select * from user where id = ?",
128 if session
.get('user_perm') == 'ADMIN':
130 error
= 'Password is required.'
131 elif password
!= confirm
:
132 error
= 'Confirmation of password failed.'
135 error
= 'Old Password is required.'
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."
146 "UPDATE user SET password = ? WHERE id = ?",
147 (generate_password_hash(password
), id),
150 except db
.IntegrityError
:
151 error
= "User does not exist."
153 error
= "Permission is invalid."
155 return redirect(url_for("dashboard.index"))
159 return render_template('auth/changepwd.html')
161 @bp.route('/update', methods
=('GET', 'POST'))
164 if request
.method
== 'POST':
165 if session
.get('user_perm') != 'ADMIN':
167 username
= request
.form
['username']
168 password
= request
.form
['password']
169 perm
= request
.form
['perm']
174 error
= 'Username is required.'
176 error
= 'Password is required.'
184 row
= get_db().execute('SELECT id FROM permissions where name = ?', (perm
,)).fetchone()
186 "INSERT INTO user (username, password, perm) VALUES (?, ?, ?)",
187 (username
, generate_password_hash(password
), row
[0]),
190 except db
.IntegrityError
:
191 error
= f
"User {username} is already registered."
193 error
= f
"Permission '{perm}' is invalid."
195 return redirect(url_for("dashboard.index"))
199 perm
= get_db().execute("""SELECT * FROM permissions""").fetchall()
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
206 return render_template('auth/update.html', perms
=perm
, users
=user
)
208 @bp.route('/userupdate/<id>', methods
=('POST',))
211 if session
.get('user_perm') != 'ADMIN':
214 content
= request
.json
216 perm_id
= content
['perm_id']
217 print("Updating {0} perm = {1}".format(id, perm_id
))
221 "UPDATE user set perm = ? where id = ?",
225 except db
.IntegrityError
:
226 error
= f
"User {id} does not exist."
228 error
= f
"Permission '{perm_id}' is invalid."
230 return render_template('dashboard/index.html')
232 # logger.error(error)
234 @bp.route('/userdelete/<id>', methods
=('POST',))
237 if session
.get('user_perm') != 'ADMIN':
240 print("Deleting {0}".format(id))
245 "DELETE FROM user where id = ?",
249 except db
.IntegrityError
:
250 error
= f
"User {id} does not exist."
252 return render_template('dashboard/index.html')
254 # logger.error(error)
This page took 0.64656 seconds and 6 git commands to generate.