Small fixes and mock data for observer tests in get_ranked_posts

find_tag_id/find_category_id moved to utility_functions.sql and changed so they follow example of find_comment_id with their error handling

added extra promotion and new ignored accounts in mock data for observer tests

observer in get_ranked_posts is now validated (it was actually validated already, but only after main query, now it happens as early as possible)

fixed problem with default value of limit in get_ranked_posts (when explicit null was passed); also all string params now are empty instead of None

hive/db/sql_scripts/bridge_get_ranked_post_for_all.sql

@@ -8,7 +8,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   RETURN QUERY SELECT
       hp.id,
       hp.author,
@@ -76,7 +76,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   IF __post_id <> 0 THEN
       SELECT hp.sc_hot INTO __hot_limit FROM hive_posts hp WHERE hp.id = __post_id;
   END IF;
@@ -220,7 +220,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   IF __post_id <> 0 THEN
       SELECT ( hp.payout + hp.pending_payout ) INTO __payout_limit FROM hive_posts hp WHERE hp.id = __post_id;
   END IF;
@@ -294,7 +294,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   IF __post_id <> 0 THEN
       SELECT ( hp.payout + hp.pending_payout ) INTO __payout_limit FROM hive_posts hp WHERE hp.id = __post_id;
   END IF;
@@ -369,7 +369,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   IF __post_id <> 0 THEN
       SELECT hp.promoted INTO __promoted_limit FROM hive_posts hp WHERE hp.id = __post_id;
   END IF;
@@ -442,7 +442,7 @@ DECLARE
   __observer_id INT;
 BEGIN
   __post_id = find_comment_id( _author, _permlink, True );
-  __observer_id = find_account_id(_observer, False);
+  __observer_id = find_account_id( _observer, True );
   IF __post_id <> 0 THEN
       SELECT hp.sc_trend INTO __trending_limit FROM hive_posts hp WHERE hp.id = __post_id;
   END IF;