Skip to content
Snippets Groups Projects

refactor follows and update_nofications indexing

Merged Dan Notestein requested to merge 267-update-notification-cache into develop
1 file
+ 1
5
Compare changes
  • Side-by-side
  • Inline
@@ -16,11 +16,7 @@ BEGIN
hivemind_postgrest_utilities.parse_argument_from_json(_params, 'observer', True), True),
True);
IF NOT EXISTS (SELECT ha.name FROM hivemind_app.follow_blacklisted fb JOIN hivemind_app.hive_accounts ha ON ha.id = fb.following WHERE fb.follower = _observer_id LIMIT 1) THEN
RETURN 'false'::jsonb;
ELSE
RETURN 'true'::jsonb;
END IF;
RETURN (SELECT EXISTS (SELECT ha.name FROM hivemind_app.follow_blacklisted fb JOIN hivemind_app.hive_accounts ha ON ha.id = fb.following WHERE fb.follower = _observer_id LIMIT 1))::TEXT::jsonb;
END
$$
;
Loading