def post_message(token, message, email):
data = query_db('SELECT * FROM Users WHERE email= ?', [email], one=True)
my_data = query_db('SELECT * FROM Users WHERE token= ?', [token], one=True)
if data is None:
return jsonify(
success=False,
message="Recipient does not exist"), 400
insert_db('INSERT INTO Messages (receiver, sender, message) \
VALUES (?, ?, ?, ?)', [data["id"], my_data["id"], message])
return jsonify(
success=True,
message="Message posted successfully"), 200
def change_password(token, old_password, new_password):
data = query_db('SELECT * FROM Users WHERE token = ?', [token], one=True)
if not check_password_hash(data["password"], password):
return jsonify(
success=False,
message="Incorect password"), 400
insert_db('UPDATE Users WHERE id=? SET password = ?', [data["id"],
new_password])
return jsonify(
success=True,
message="Password changed successfully"), 200
def sign_in(email, password):
data = query_db('SELECT * FROM Users WHERE email = ?', [email], one=True)
if data and check_password_hash(data["password"], password):
token = token_creator()
insert_db('UPDATE Users SET token = ? WHERE email = ?', [token, email])
return jsonify(
succes=True,
message="Welcome",
data=json.dumps({'token': token}),
), 200
return jsonify(
success=False,
message="Username or password invalid"), 401
def sign_up(email, password, firstname, familyname, gender, city, country):
"""
check if the email exists in the database
"""
data = query_db('SELECT * FROM Users WHERE email = ?', [email], one=True)
if data is not None:
return jsonify(
success=False,
message="Email already exists"), 400
insert_db('INSERT INTO Users (email, firstname, lastname, gender, city, country, password) \
VALUES (?, ?, ?, ?, ?, ?, ?)',
[email, firstname, familyname, gender, city,
country, generate_password_hash(password)])
return jsonify(
success=True,
message="Account created successfully"), 200
