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

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.

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

When we need to mock more blocks than HAf databse already have,
we need to push these blocks to the hive.blocks table.