def desplay_edit_page(user_id):
mysql = connectToMySQL('users')
query = "SELECT * FROM users WHERE id = %(id)s;"
data = {'id': user_id}
users = mysql.query_db(query, data)
user = users[0]
return render_template("edit_user.html", user=user)
def display_one_user(user_id):
print("line 27______", user_id)
mysql = connectToMySQL('users')
query = "SELECT * FROM users.users WHERE id = %(id)s;"
data = {'id': user_id}
user = mysql.query_db(query, data)
return render_template("one_user.html", users=user)
def add_user():
mysql = connectToMySQL('users')
query = """INSERT INTO users.users
(first_name, last_name, email, created_at, updated_at)
VALUES (%(fn)s, %(ln)s, %(em)s, NOW(), NOW());"""
data = {
'fn': request.form['fname'],
'ln': request.form['lname'],
'em': request.form['email']
}
user_id = mysql.query_db(query, data)
route_str = "/users/" + str(user_id)
return redirect(route_str)
def edit_user(user_id):
print("line 27______", user_id)
mysql = connectToMySQL('users')
query = """UPDATE users.users
SET first_name=%(fn)s, last_name=%(ln)s, email=%(em)s, updated_at = NOW(),
WHERE id = %(id)s;"""
data = {
'id': user_id,
'fn': request.form['fname'],
'ln': request.form['lname'],
'em': request.form['email']
}
user_id = mysql.query_db(query, data)
print(user_id)
route_str = "/users/" + str(user_id)
return redirect(route_str)
def display_new_user_form():
mysql = connectToMySQL('users')
users = mysql.query_db("SELECT * FROM users.users;")
return render_template("new_user_form.html", users=users)
def display_all():
mysql = connectToMySQL('users')
users = mysql.query_db("SELECT * FROM users.users;")
return render_template("index.html", users=users)