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)
