Unify API returns to sql composite types, add pattern tests for REST API

Requires haf!634 (merged)

Related with balance_tracker!171 (merged)

• Unifies API responses - adds exception handling instead of null values in composite types
• every api returns sql type instead of json
• fix for /global-state values were shortened by json
• adds patten tests for REST API

postgrest/hafah_REST/other/get_block.sql

@@ -53,12 +53,12 @@ SET ROLE hafah_owner;
               "witness_signature": "1f6aa1c6311c768b5225b115eaf5798e5f1d8338af3970d90899cd5ccbe38f6d1f7676c5649bcca18150cbf8f07c0cc7ec3ae40d5936cfc6d5a650e582ba0f8002",
               "signing_key": "STM8aUs6SGoEmNYMd3bYjE1UBr6NQPxGWmTqTdBaxJYSx244edSB2",
               "hbd_interest_rate": 1000,
-              "total_vesting_fund_hive": 149190428013,
-              "total_vesting_shares": 448144916705468350,
-              "total_reward_fund_hive": 66003975,
-              "virtual_supply": 161253662237,
-              "current_supply": 157464400971,
-              "current_hbd_supply": 2413759427,
+              "total_vesting_fund_hive": "149190428013",
+              "total_vesting_shares": "448144916705468350",
+              "total_reward_fund_hive": "66003975",
+              "virtual_supply": "161253662237",
+              "current_supply": "157464400971",
+              "current_hbd_supply": "2413759427",
               "dhf_interval_ledger": 0,
               "created_at": "2016-09-15T19:47:21"
             }
@@ -99,12 +99,12 @@ BEGIN
       encode(bv.witness_signature, 'hex') AS witness_signature,
       bv.signing_key AS signing_key,
       bv.hbd_interest_rate::numeric AS hbd_interest_rate,
-      bv.total_vesting_fund_hive::numeric AS total_vesting_fund_hive,
-      bv.total_vesting_shares::numeric AS total_vesting_shares,
-      bv.total_reward_fund_hive::numeric AS total_reward_fund_hive,
-      bv.virtual_supply::numeric AS virtual_supply,
-      bv.current_supply::numeric AS current_supply,
-      bv.current_hbd_supply::numeric AS current_hbd_supply,
+      bv.total_vesting_fund_hive::TEXT AS total_vesting_fund_hive,
+      bv.total_vesting_shares::TEXT AS total_vesting_shares,
+      bv.total_reward_fund_hive::TEXT AS total_reward_fund_hive,
+      bv.virtual_supply::TEXT AS virtual_supply,
+      bv.current_supply::TEXT AS current_supply,
+      bv.current_hbd_supply::TEXT AS current_hbd_supply,
       bv.dhf_interval_ledger::numeric AS dhf_interval_ledger,
       bv.created_at AS created_at
     FROM hive.blocks_view bv