def set_fb_access_token(uid, access_token): cache.remove(_get_user_cache_key(uid)) return db.execute("UPDATE users SET fb_access_token=%s WHERE id=%s", access_token, uid)
def create_user(fbid, fb_access_token): return db.execute("INSERT INTO users (fbid, fb_access_token) VALUES (%s, %s)", fbid, fb_access_token)
def clear_fb_access_token(uid): return db.execute("UPDATE users SET fb_access_token=null WHERE id=%s", uid)
def create_exercise_type(name, description): cache.remove(_get_all_exercise_types_cache_key()) return db.execute("INSERT INTO exercise_types " "(name, description) VALUES " "(%s, %s)", name, description)
def create_data_point(entry_id, measure_id, value): cache.remove(_get_data_points_for_entry_cache_key(entry_id)) return db.execute("INSERT INTO data_points " "(entry_id, measure_id, `value`) VALUES " "(%s, %s, %s)", entry_id, measure_id, value)
def delete_entry(entry_id): cache.remove(_get_data_points_for_entry_cache_key(entry_id)) return db.execute("DELETE FROM entries WHERE id=%s", entry_id)
def set_entry_shared(entry_id, fbshare_id): return db.execute("UPDATE entries " "SET fbshare_id=%s WHERE id=%s", fbshare_id, entry_id)
def create_entry(uid, date, exercise_type_id, comment): cache.remove(_get_entries_for_user_cache_key(uid)) return db.execute("INSERT INTO entries " "(user_id, date, exercise_type, comment) VALUES " "(%s, %s, %s, %s)", uid, date, exercise_type_id, comment)