Implement storing binary serialized operations in the HAF database

Related issue: #92 (closed)

Merge Request related to this one on the hive-side: hive!802 (merged)

Changes to the repo:

• Fixed hive_fork_manager being built always in the mainnet configuration on the CI
• Added new type: hive.operation
• Added operator class (using btree) for the hive.operation type
• Changed hive.operations.body column type from text to hive.operation
• Made CUSTOM_LOG variadic arguments optional
• Optimized escape_raw function
• Changed tests to work with the new type
• Made colect_data_and_fill_returned_recordset truly noexcept
• Created colect_operation_data_and_fill_returned_recordset function wrapping colect_data_and_fill_returned_recordset function specifically for the hive.operation type
• Changed sql_serializer to put binary data into the hive.operations table instead of the json representation
• Added HiveOperation type class for the sqlalchemy ORM

What should be added/changed/discussed before merging (not critical):

• Fix warnings generated by the sqlalchemy ORM related to the hive.operation type
• Make update_state_provider_keyauth function work with the binary data representation instead of text one
• Search for other possibilities to optimize the SQL code execution using binary data representation instead of the text one

@gandalf Please review and test full replay + live sync

tests/integration/functional/hive_fork_manager/shared_lib/get_impacted_balances/test_false.sql

@@ -44,11 +44,11 @@ BEGIN
     FROM hive.get_impacted_balances('{}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST0 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST0 should throw exception: "invalid_text_representation"';
 
     exception 
     -- ignore exceptions in test0
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -74,11 +74,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"not_existing_type","value":{"from":"anonymtest","to":"someguy123","agent":"xtar","who":"xtar","receiver":"someguy123","escrow_id":72526562,"hbd_amount":{"amount":"5000","precision":3,"nai":"@@000000013"},"hive_amount":{"amount":"0","precision":3,"nai":"@@000000021"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST2 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST2 should throw exception: "invalid_text_representation"';
 
     exception 
     -- ignore exceptions in test2
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -119,11 +119,11 @@ BEGIN
     FROM hive.get_impacted_balances('[1,3,34,543,34]', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST5 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST5 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test5
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -134,11 +134,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"5000","precision":3,"nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST6 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST6 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test6
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -149,11 +149,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"precision":3,"nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST7 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST7 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test7
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -164,11 +164,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"5000","nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST8 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST8 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test8
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -179,11 +179,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"5000","precision":3}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST9 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST9 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test9
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -194,11 +194,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":5000,"precision":3,"nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST10 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST10 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test10
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -209,11 +209,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"5000","precision":"some_string","nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST11 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST11 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test11
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -224,11 +224,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"5000","precision":3,"nai":"@@000000099"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST12 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST12 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test12
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;
 
@@ -239,11 +239,11 @@ BEGIN
     FROM hive.get_impacted_balances('{"type":"convert_operation","value":{"owner":"summon","requestid":1467592156,"amount":{"amount":"some_string","precision":3,"nai":"@@000000013"}}}', FALSE) f
     ;
 
-    ASSERT FALSE, 'TEST13 should throw exception: "feature_not_supported"';
+    ASSERT FALSE, 'TEST13 should throw exception: "invalid_text_representation"';
 
     exception
     -- ignore exceptions in test13
-        when feature_not_supported then
+        when invalid_text_representation then
             NULL;
     END;