haf_block_explorer merge requestshttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests2024-02-28T23:51:37Zhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/153Draft: Replay fix2024-02-28T23:51:37ZKonrad BotorDraft: Replay fixFixes the replay process on CI so that it first checks if the replay is in progress and only then if the existing replay is valid.
Refacors the CI to run test jobs in parallel and to use common CI replay data (rather than performing a ...Fixes the replay process on CI so that it first checks if the replay is in progress and only then if the existing replay is valid.
Refacors the CI to run test jobs in parallel and to use common CI replay data (rather than performing a replay in every pipeline).
Shortens timeouts in test jobs.
Depends on haf!455 and balance_tracker!75 and probably haf_block_explorer!152 (tests seem to be failing due to incompatibility with the newest HAF version).
Block processing seems to fail with the following error:
```
btracker-backend-block-processing-1 | ERROR: procedure hive.appproc_context_attach(character varying[], integer) does not exist
btracker-backend-block-processing-1 | LINE 1: CALL hive.appproc_context_attach(ARRAY[_appContext, _appCont...
btracker-backend-block-processing-1 | ^
btracker-backend-block-processing-1 | HINT: No procedure matches the given name and argument types. You might need to add explicit type casts.
btracker-backend-block-processing-1 | QUERY: CALL hive.appproc_context_attach(ARRAY[_appContext, _appContext_btracker], __last_block)
btracker-backend-block-processing-1 | CONTEXT: PL/pgSQL function hafbe_app.main(character varying,character varying,integer) line 19 at CALL
btracker-backend-block-processing-1 | Time: 5.719 ms
```
due to incompatibility with the newest version of HAF.Konrad BotorKonrad Botorhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/148Draft: adjust for new app_next_block2024-02-23T23:08:07ZDan NotesteinDraft: adjust for new app_next_blockhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/150Draft: addjust current_block_num before entering massive sync2024-02-23T23:07:31ZDan NotesteinDraft: addjust current_block_num before entering massive synchttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/132Draft: Remove hafbe's indexes on hive tables2024-01-25T10:21:17ZMichal ZanderDraft: Remove hafbe's indexes on hive tablesRequires https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/59Requires https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/59Michal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/127Draft: Fix slow down2024-01-17T19:45:32ZMichal ZanderDraft: Fix slow downRequires https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/55Requires https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/55Michal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/116Add missing aliases, unify aliases for blocks, operations, account_operations...2024-01-11T08:44:47ZMichal ZanderAdd missing aliases, unify aliases for blocks, operations, account_operations and accounts tablesMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/67Draft: Add swagger and small fixes2023-12-19T15:22:13ZMichal ZanderDraft: Add swagger and small fixescomments and descriptions will be in next MRcomments and descriptions will be in next MRMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/42Draft: 0.(haf_block_explorer) Add state_provider keyauth to haf_block_explorer2023-12-19T15:21:08ZMichal ZanderDraft: 0.(haf_block_explorer) Add state_provider keyauth to haf_block_explorerMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/97Draft: Add endpoint allowing to calculate position of desired block with oper...2023-12-08T15:04:51ZMichal ZanderDraft: Add endpoint allowing to calculate position of desired block with operations on account page(used in account page)(used in account page)Michal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/93Update .sqlfluff2023-11-30T20:34:29ZDan NotesteinUpdate .sqlfluffhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/81Add get_operation to setup2023-11-17T20:01:57ZMichal ZanderAdd get_operation to setupMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/74Draft: CI setup2023-11-17T14:53:46ZKonrad BotorDraft: CI setupImplements #54Implements #54Konrad BotorKonrad Botorhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/63Draft: block search by operation, account, block range and specific key and v...2023-11-16T13:51:29ZMichal ZanderDraft: block search by operation, account, block range and specific key and value```
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], NULL, 'desc', 0, 2147483647, 100, 'gtg', 'value', 'author')
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], NULL, 'desc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.g...```
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], NULL, 'desc', 0, 2147483647, 100, 'gtg', 'value', 'author')
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], NULL, 'desc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], NULL, 'asc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[0,1,2,3,4,5,6,7,8,9,10,11,12,13,15], NULL, 'desc', 0, 2147483647, 1000)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], 'blocktrades', 'desc', 0, 2147483647, 100, 'gtg', 'value', 'author')
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[0,72,28,18,34,11], 'blocktrades', 'desc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[28,18,34,11], 'blocktrades', 'desc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[0,1,2,3,4,5,6,7,8,9,10,11,12,13,15], 'blocktrades', 'asc', 0, 2147483647, 100)
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1,28,34,74,23,41,83], 'gtg', 'desc', 0, 2147483647, 1000, 'gtg', 'value', 'author')
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], 'gtg', 'asc', 0, 2147483647, 1000, 'gtg', 'value', 'author')
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], 'gtg', 'desc', 0, 2147483647, 100, 'blocktrades', 'value', 'author')
exception when:
SELECT * FROM hafbe_backend.get_block_by_op(ARRAY[1], 'gtg', 'desc', 0, 2147483647, 100, 'blocktrades', 'value', 'aut23131hor')
```Michal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/69Add new endpoint for FE usage, returns latests blocks, block producer and , o...2023-10-11T13:26:37ZMichal ZanderAdd new endpoint for FE usage, returns latests blocks, block producer and , ops count per op_type_idMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/60Add endpoint get_block_by_time2023-09-08T15:46:32ZMichal ZanderAdd endpoint get_block_by_timeMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/58Add get_block_by_time endpoint2023-09-08T15:41:13ZMichal ZanderAdd get_block_by_time endpointMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/40Draft: Resolve "Reorganize SQL functions"2023-08-31T13:05:42ZimwatsiDraft: Resolve "Reorganize SQL functions"Closes #45Closes #45https://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/53Draft: 2. (haf_block_explorer) MR fixing an issue with wrong post_count and l...2023-07-27T13:45:59ZMichal ZanderDraft: 2. (haf_block_explorer) MR fixing an issue with wrong post_count and last_post when comment where deleted and posted againMichal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/50Draft: 4.(haf_block_explorer) posting, curation rewards, more optimalizations2023-07-27T13:45:26ZMichal ZanderDraft: 4.(haf_block_explorer) posting, curation rewards, more optimalizationshttps://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/23https://gitlab.syncad.com/hive/balance_tracker/-/merge_requests/23Michal ZanderMichal Zanderhttps://gitlab.syncad.com/hive/haf_block_explorer/-/merge_requests/49Draft: 3.(haf_block_explorer) Update hive.contexts to so it holds correct cur...2023-07-27T13:45:15ZMichal ZanderDraft: 3.(haf_block_explorer) Update hive.contexts to so it holds correct current_block_numMichal ZanderMichal Zander