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_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 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 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 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)
