got update user properties working

[openhouseparty.online/.git] / flaskr / admin.py

diff --git a/flaskr/admin.py b/flaskr/admin.py
index 8972998da0cd37c48c09c1e816a15b6c332b5214..a19e56a90e29d42c42665b522adad44ab17352a1 100644 (file)
--- a/flaskr/admin.py
+++ b/flaskr/admin.py
@@ -18,8 +18,8 @@ def index():
 def get_users():
     db = get_db()
     users = db.execute(
-        'SELECT user_id, user_name'
-        ' FROM user'
+        'SELECT xuser_id, xuser_username, xuser_firstname, xuser_lastname, xuser_email'
+        ' FROM xuser'
     ).fetchall()
 
     return render_template('admin/user_list.html', users=users)
@@ -28,13 +28,60 @@ def get_users():
 def delete_user():
     db = get_db()
     db.execute(
-        'DELETE FROM user WHERE user_id = ?', [request.form['user_to_delete']]
+        'DELETE FROM xuser WHERE xuser_id = ?', [request.form['user_to_delete']]
     )
     db.commit()
     return redirect(url_for('admin.index'))
 
 #@bp.route('/user_update/<int:user_id>', methods=['POST'])
-@bp.route('/user_update', methods=['POST'])
-def update_user():
+#@bp.route('/<int:user_id>/user_update', methods=('GET', 'POST'))
+#def update_user(user_id):
 
-    return render_template('admin/user_edit.html', user_id=request.form['user_to_edit'])
\ No newline at end of file
+#    return render_template('admin/user_edit.html', user_id=request.form['user_to_edit'])
+
+
+def get_user(user_id):
+    user = get_db().execute(
+        'SELECT xuser_id, xuser_username, xuser_firstname, xuser_lastname, xuser_email'
+        ' FROM xuser'
+        ' WHERE xuser_id = ?',
+        (user_id,)
+    ).fetchone()
+
+    return user
+
+
+@bp.route('/<int:user_id>/user_update', methods=['GET', 'POST'])
+@login_required
+def update_userInfo(user_id):
+    #user_id = request.form['user_to_edit']
+    print("AAAAA")
+    print(user_id)
+    print("AAAAA")
+    user = get_user(user_id)
+    if request.method == 'POST':
+        username = request.form['username']
+        firstname = request.form['firstname']
+        lastname = request.form['lastname']
+        email = request.form['email']
+        error = None
+
+        if not username:
+            error = 'Username is required.'
+
+        if error is not None:
+            flash(error)
+        else:
+            db = get_db()
+            db.execute(
+                'UPDATE xuser SET xuser_username = ?, xuser_firstname = ?, xuser_lastname = ?, xuser_email = ? WHERE xuser_id = ?',
+                [username,
+                 firstname,
+                 lastname,
+                 email,
+                 user_id]
+            )
+            db.commit()
+            return redirect(url_for('admin.index'))
+
+    return render_template('admin/user_edit.html', user=user)
\ No newline at end of file