dynamically generated notifs

Some of the notifications can be extracted from DB tables with SQL query. This allows us to avoid redundancy and save db space.

hive/db/schema.py

@@ -1421,20 +1421,19 @@ def setup(db):
 
     sql = """
         DROP FUNCTION IF EXISTS public.calculate_notify_vote_score(_payout hive_posts.payout%TYPE, _abs_rshares hive_posts_view.abs_rshares%TYPE, _rshares hive_votes.rshares%TYPE) CASCADE
-            ;
+        ;
         CREATE OR REPLACE FUNCTION public.calculate_notify_vote_score(_payout hive_posts.payout%TYPE, _abs_rshares hive_posts_view.abs_rshares%TYPE, _rshares hive_votes.rshares%TYPE)
-            RETURNS INT
-            LANGUAGE 'plpgsql'
-            IMMUTABLE
-            AS $BODY$
-            DECLARE contrib INT;
-            BEGIN
-            	contrib = (( _payout )/_abs_rshares) * 1000 * _rshares;
-            	IF contrib < 20 THEN RETURN -1; END iF;
-            	RETURN LEAST(100, (LENGTH(CAST( contrib as text)) - 1) * 25);
+        RETURNS INT
+        LANGUAGE 'sql'
+        IMMUTABLE
+        AS $BODY$
+            SELECT CASE
+                WHEN ((( _payout )/_abs_rshares) * 1000 * _rshares < 20 ) THEN -1
+                ELSE LEAST(100, (LENGTH(CAST( ( (( _payout )/_abs_rshares) * 1000 * _rshares ) as text)) - 1) * 25)
             END;
-            $BODY$;
-        """
+        $BODY$;
+    """
+
     db.query_no_return(sql)
 
     sql = """