def register(username, password): hashed_password = generate_password_hash(password) # Query database for username new_user_id = db.execute( "INSERT INTO users (username, hash) VALUES (?, ?)", username, hashed_password) return new_user_id
def verify_username(username): usernamess = [] usernames = db.execute("SELECT username FROM users") for name in usernames: usernamess.append(name["username"]) if username in usernamess: return True else: return False
def update_password(id, current_password, password): user = get_user_by_user_id(id) if not check_password_hash(user["hash"], current_password): return None hashed_password = generate_password_hash(password) # Query database for username new_user_id = db.execute("UPDATE users SET hash = ? WHERE id = ?", hashed_password, id) return True
def get_user_by_user_id(id): users = db.execute("SELECT * FROM users WHERE id = ?", id) if len(users) > 0: return users[0] else: return None
def _fk_pragma_on_connect(db, conn_record): # noqa db.execute('pragma foreign_keys=ON')