Draft: refactor follows and update_nofications indexing

Based on !819

Require tests_api!258

hive/db/sql_scripts/postgrest/utilities/get_profiles.sql

@@ -62,21 +62,15 @@ BEGIN
                        jsonb_set(
                                account_row,
                                '{context}',
-                               COALESCE(
-                                       (SELECT
-                                            CASE
-                                                WHEN state = 2 THEN
-                                                    jsonb_build_object('followed', false, 'muted', true)
-                                                WHEN state = 1 THEN
-                                                    jsonb_build_object('followed', true)
-                                                ELSE
-                                                    jsonb_build_object('followed', false)
-                                                END
-                                        FROM hivemind_app.hive_follows
-                                        WHERE follower = _observer_id
-                                          AND following = (account_row->>'id')::INT),
-                                       jsonb_build_object('followed', false)
-                                   )
+                               jsonb_build_object(
+                                'followed', (SELECT EXISTS (SELECT NULL
+                                  FROM hivemind_app.follows
+                                  WHERE follower = _observer_id
+                                  AND following = (account_row->>'id')::INT)),
+                                'muted', (SELECT EXISTS (SELECT NULL
+                                  FROM hivemind_app.muted
+                                  WHERE follower = _observer_id
+                                  AND following = (account_row->>'id')::INT)))
                            )
                    )
         FROM jsonb_array_elements(_result) account_row
@@ -99,4 +93,4 @@ BEGIN
     RETURN _result;
 END
 $function$
-;
\ No newline at end of file
+;