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/accounts/get_acc_op_types.sql

@@ -27,12 +27,13 @@ SET ROLE hafah_owner;
         description: |
           Operation type list
 
-          * Returns `JSONB`
+          * Returns array of `INT`
         content:
           application/json:
             schema:
-              type: string
-              x-sql-datatype: JSONB
+              type: array
+              items:
+                type: integer
             example: [
               0,
               1,
@@ -72,7 +73,7 @@ DROP FUNCTION IF EXISTS hafah_endpoints.get_acc_op_types;
 CREATE OR REPLACE FUNCTION hafah_endpoints.get_acc_op_types(
     "account-name" TEXT
 )
-RETURNS JSONB 
+RETURNS INT[] 
 -- openapi-generated-code-end
 LANGUAGE 'plpgsql' STABLE
 SET JIT = OFF
@@ -81,23 +82,16 @@ SET from_collapse_limit = 16
 AS
 $$
 DECLARE
-  __account_id INT = (SELECT av.id FROM hive.accounts_view av WHERE av.name = "account-name");
+  _account_id INT = (SELECT av.id FROM hive.accounts_view av WHERE av.name = "account-name");
 BEGIN
+  IF _account_id IS NULL THEN
+    PERFORM hafah_backend.rest_raise_missing_account("account-name");
+  END IF;
+
   PERFORM set_config('response.headers', '[{"Cache-Control": "public, max-age=2"}]', true);
 
-  RETURN (
-    WITH op_types_cte AS 
-    (
-      SELECT id
-      FROM hafd.operation_types hot
-      WHERE (
-        SELECT EXISTS (
-          SELECT 1 FROM hive.account_operations_view aov WHERE aov.account_id = __account_id AND aov.op_type_id = hot.id))
-    )
+  RETURN hafah_backend.get_acc_op_types(_account_id);
 
-    SELECT jsonb_agg(to_jsonb(cte.id::INT))
-    FROM op_types_cte cte
-  );
 END
 $$;