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