def dash():
db = connectToMySQL('joblist')
job = db.query_db('SELECT * FROM works WHERE granted = 0;')
db = connectToMySQL('joblist')
user = db.query_db('SELECT * FROM users;')
db = connectToMySQL('joblist')
job1 = db.query_db('SELECT * FROM works WHERE granted = 1;')
return render_template('dashboard.html', job=job, job1=job1, user=user[0])
def makeWishProcess():
db = connectToMySQL('joblist')
is_valid = True
if len(request.form['job']) < 3:
is_valid = False
flash("A job must contain 3 characters!")
if len(request.form['description']) < 3:
is_valid = False
flash("A description must contain 3 characters!")
if len(request.form['location']) < 3:
is_valid = False
flash("A location must contain 3 characters!")
if not is_valid:
return redirect("/add/job")
query = "INSERT INTO works (job, description, location, category, worker, created_at, updated_at) VALUES (%(jo)s, %(ds)s, %(lo)s,%(ca)s,%(id)s, NOW(), NOW());"
data = {
"jo": request.form['job'],
"ds": request.form['description'],
"lo": request.form['location'],
"ca": request.form['category'],
"id": session['users']['id']
}
print(query)
print(db)
db.query_db(query, data)
return redirect("/dashboard")
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 WHERE id = %(id)s;"
data = {
'id': user_id
}
user = mysql.query_db(query, data)
return render_template("one_user.html", users=user)
def process():
pw_hash = bcrypt.generate_password_hash(request.form['passCon'])
print(pw_hash)
db = connectToMySQL('joblist')
query = "SELECT * FROM users WHERE email = %(email)s;"
data = {"email": request.form['email']}
emailcheck = db.query_db(query, data)
is_valid = True
if (len(emailcheck) != 0):
is_valid = False
flash("Email address already in use")
if not EMAIL_REGEX.match(request.form['email']):
is_valid = False
flash("Invalid email address!")
if len(request.form['email']) < 10:
is_valid = False
flash("please enter a valid email")
if len(request.form['fname']) < 2:
is_valid = False
flash("Please enter a valid first name")
if len(request.form['lname']) < 2:
is_valid = False
flash("Please enter a valid last name")
if len(request.form['passCon']) < 8:
is_valid = False
flash("Password is too short")
if (request.form['passCon'] != request.form['passCon2']):
is_valid = False
flash("Passwords do not match")
if not is_valid:
return redirect("/")
db = connectToMySQL('joblist')
query = 'INSERT INTO users(first_name, last_name, email,pw_hash, created_at, updated_at) VALUES (%(fn)s, %(ln)s,%(em)s, %(pwh)s, NOW(), NOW());'
data = {
"fn": request.form["fname"],
"ln": request.form["lname"],
"em": request.form["email"],
"pwh": pw_hash
}
db.query_db(query, data)
return redirect("/")
def login():
db = connectToMySQL("joblist")
query = "SELECT * FROM users WHERE email = %(em)s;"
data = {"em": request.form["email"]}
result = db.query_db(query, data)
if len(result) > 0:
if bcrypt.check_password_hash(result[0]['pw_hash'],
request.form['passCon']):
session['users'] = result[0]
return redirect('/dashboard')
flash("You could not be logged in")
return redirect("/")
def destroy_user(user_id):
print("line 27______", user_id)
mysql = connectToMySQL('users')
query = """DELETE FROM users.users WHERE
(id = %(id)s);"""
# UPDATE `users`.`users` SET `first_name` = 'Katrinahfvkjasfdh' WHERE (`id` = '4');
data = {
'id': user_id
}
mysql.query_db(query, data)
return redirect("/users")
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);"""
# UPDATE `users`.`users` SET `first_name` = 'Katrinahfvkjasfdh' WHERE (`id` = '4');
data = {
'id': user_id,
'fn': request.form['fname'],
'ln': request.form['lname'],
'em': request.form['email']
}
mysql.query_db(query, data)
print(user_id)
route_str = "/users/" + str(user_id)
return redirect(route_str)
def jobEditProcess(id):
db = connectToMySQL('joblist')
is_valid = True
if len(request.form['job']) < 3:
is_valid = False
flash("A job must contain 3 characters!")
if len(request.form['description']) < 3:
is_valid = False
flash("A description must contain 3 characters!")
if len(request.form['location']) < 3:
is_valid = False
flash("A location must contain 3 characters!")
if not is_valid:
return redirect("/jobs/<id>/edit/")
query = "UPDATE works SET job = %(jo)s , description = %(ds)s,location = %(lo)s, updated_at = NOW() WHERE id= %(id)s;"
data = {
"jo": request.form['job'],
"ds": request.form['description'],
"lo": request.form['location'],
"id": id
}
db.query_db(query, data)
return redirect("/dashboard")
def addjobh():
db = connectToMySQL('joblist')
db.query_db('SELECT * FROM works;')
return render_template("addjob.html")
def jobview(id):
db = connectToMySQL('joblist')
query = "SELECT * FROM works WHERE id = %(id)s;"
data = {"id": id}
job = db.query_db(query, data)
return render_template("viewjob.html", job=job[0])
def giveup(id):
db = connectToMySQL('joblist')
query = "UPDATE works SET granted = '0', updated_at = NOW() WHERE id = %(id)s;"
data = {'id': id}
db.query_db(query, data)
return redirect("/dashboard")
def display_new_user_form():
mysql = connectToMySQL('users')
users = mysql.query_db("SELECT * FROM users;")
return render_template("new_user_form.html", users=users)
def home():
db = connectToMySQL('joblist')
db.query_db('SELECT * FROM users;')
return render_template("loginReg.html")
def user_delete(id):
db = connectToMySQL('joblist')
query = "DELETE FROM works WHERE id = %(id)s;"
data = {'id': int(id)}
db.query_db(query, data)
return redirect("/dashboard")
def display_index():
mysql = connectToMySQL('pets')
pets = mysql.query_db("SELECT * FROM pets;")
return render_template("index.html", pets=pets)
def display_all():
mysql = connectToMySQL('users')
users = mysql.query_db("SELECT * FROM users;")
return render_template("index.html", users=users)