def remove_log(user, id): log = session.query(Log) \ .filter(Log.user_id == user.id, Log.id == id) \ .first() if log is not None: session.delete(log) session.commit() return True else: return False
def update_user_settings(user, daily_activity_minutes, body_weight_grams): user_settings_in_db = session.query(UserSettings) \ .filter(UserSettings.user_id == user.id) \ .first() if user_settings_in_db is not None: user_settings_in_db.daily_activity_minutes = daily_activity_minutes user_settings_in_db.body_weight_grams = body_weight_grams session.commit() return user_settings_in_db else: settings = UserSettings(user.id, daily_activity_minutes, body_weight_grams) session.add(settings) session.commit() return settings
def add_log(user, grams): log = Log(user.id, grams) session.add(log) session.commit() return log
def remove_user_auth(auth_token): session.query(UserAuth) \ .filter(UserAuth.token == auth_token) \ .delete() session.commit() return True
def create_user_auth(user): auth = UserAuth(user.id, token_urlsafe(30)) session.add(auth) session.commit() return auth
def save_user_to_database(first_name, last_name, email, password): user = User(first_name, last_name, email, pwd_context.encrypt(password)) session.add(user) session.commit() return user