commit 3eb72984
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Mon Aug 22 00:18:09 2022 -0400

    Fix pattern tests following changes in mocks

commit e0ed25f8
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Aug 21 20:35:51 2022 -0400

    Added test cases in the mocks + pattern tests

commit 1144c265
Merge: 2a80d650 066762c7
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Aug 21 20:35:21 2022 -0400

    Merge branch 'feature/role-only-if-subscribed' of gitlab.syncad.com:hive/hivemind into feature/role-only-if-subscribed

commit 066762c7
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun May 8 23:13:17 2022 -0400

    Added flow.txt where it's missed

commit 6acdb300
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 24 10:46:38 2022 -0400

    fix all tests

commit 566a71ab
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 23 22:35:34 2022 -0400

    attempt at fixing most tests

commit ec803921
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 23 21:25:23 2022 -0400

    first fix try

commit cbb74d37
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:26:00 2022 -0400

    small fix

commit 9dc83b3b
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:23:55 2022 -0400

    Allows setting the muted role even if you're not subscribed

commit 446a4c1b
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:11:00 2022 -0400

    added communtiy_helpers to base schema

commit e710b92c
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 19:52:29 2022 -0400

    Update SetRole/SetUserTitle so that you have to be subscribed to get it, also added a script to generate flow.txt and cleaned up communtiy_flow

commit 2a80d650
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun May 8 23:13:17 2022 -0400

    Added flow.txt where it's missed

commit 555d03c6
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 24 10:46:38 2022 -0400

    fix all tests

commit 0b705204
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 23 22:35:34 2022 -0400

    attempt at fixing most tests

commit 4e2946f7
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 23 21:25:23 2022 -0400

    first fix try

commit 7c467c37
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:26:00 2022 -0400

    small fix

commit 3ecaf640
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:23:55 2022 -0400

    Allows setting the muted role even if you're not subscribed

commit 2e9081e5
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 23:11:00 2022 -0400

    added communtiy_helpers to base schema

commit 7f0cc6d5
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Apr 3 19:52:29 2022 -0400

    Update SetRole/SetUserTitle so that you have to be subscribed to get it, also added a script to generate flow.txt and cleaned up communtiy_flow

fix plsql function to accomodate the new haf bindings

fixed block_data_community to match new haf design

fixed json again

fix keys again

fixes for hive_roles

update tests + flows

fix pattern tests to account for new mocked community

Cleaned branch

Squashed commit of the following:

commit f6824e05
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 2 13:53:06 2022 -0400

    try other idea

commit 58779761
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sat Apr 2 13:51:27 2022 -0400

    test wihout php.author_id

commit 4a0c9dda
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Wed Mar 23 01:13:30 2022 -0400

    test

commit 1147b6c1
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Wed Mar 23 01:04:26 2022 -0400

    try to return a NULL::integer

commit 5163b179
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Wed Mar 23 01:03:24 2022 -0400

    test

commit 8e737f13
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Wed Mar 23 00:46:54 2022 -0400

    fix query

commit 1f3f40d5
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Wed Mar 23 00:41:36 2022 -0400

    overhaul of the query

commit a0c08b48
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Tue Mar 22 22:23:32 2022 -0400

    test

commit 41288813
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Tue Mar 22 21:35:40 2022 -0400

    typo

commit 924dd89e
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Tue Mar 22 21:31:19 2022 -0400

    Decorated sql to fix conflict

commit ebcda2cc
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Tue Mar 22 21:16:39 2022 -0400

    code style

commit df102d8e
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Mar 13 23:27:53 2022 -0400

    fix query

commit 77dc4fb2
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Mar 13 17:10:09 2022 -0400

    Fix format

commit 46add4ed
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Mar 13 17:04:05 2022 -0400

    fix typo

commit d1d08f62
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Sun Mar 13 17:01:55 2022 -0400

    added the flow + mocked ops

commit 5a90840d
Author: Martin Lees <drov0@users.noreply.github.com>
Date:   Tue Jan 25 23:56:05 2022 -0500

    update community type feature

communities type 1 tests + updated sql to work with haf

Fix broken mock

Issue #200 - run_instance script extended to simplify starting separate containers for hive sync and server processes.

Replaced scripts/ci-helpers/build_and_publish_instance.sh with a symbolic link to haf/hive/scripts/ci-helpers/build_and_publish_instance.sh - ref. hive#434

Including of scripts/ci-helpers/prepare_data_image_job.yml references this file from exact commit (instead of branch) to avoid ambiguous behavior on subsequent runs of pipeline at Hivemind side (where each time HAF develop would be updated to different HEAD commit)

Restored benchmark collector job spawn after fixes done in MR: benchmark-results-collector!7

build.sh script additionally immediately uses atomic package to enforce its final build on builder image. Then runtime image can be smaller due to eliminated compiler.

Old upgrade code (specific to previous releases) removed and new upgrade procedure adjusted to HAF requirements.

hivemind_app_block_view switched to hive.blocks_view due to peformance reasons. Postgres again is ignoring index, while perfoming order by query over indexed column, in case of complex view.

Updated haf submodule to the version containing required indexes and functions to wait until HAF instance will be ready for processing.

Mateusz Żebrak authored 2 years ago and Bartek Wrona committed 2 years ago

Due to performance issues when querying
for last num of `app_name.blocks_view`,
additional function get_head_state()
was created.

hive.hivemind_app_blocks_view data are provided by simple subquery instead of JOIN, since at least PostgreSQL 12 planner misbehaves and uses table scan instead of index scan to select row(s) from hive.blocks table, what kills performance.