exception handling during sync

See merge request !399

GIN index uses to find posts by tag

See merge request !377

-remove hive_post_tags table
-extend hive_posts for a column with an arrays of tags id
-tags are added next after a post, not in paralles as it was previously
-fix bug with not removing tags for a post whose author removed tags
during edition

random order of communities admins

See merge request !401

vaccum at sync final

See merge request !395

Resolve "CI pipeline should exit with error, when script cannot recreate existing database"

See merge request !397

Mock tests for communities

See merge request !389

Compact all CI jobs to one

See merge request !390

Wojciech Barcik authored 4 years ago and Bartek Wrona committed 4 years ago

Fix path to test script

Some sql functions called in method _after_initial_sync heavy updates
tables (espacialy hive_posts) and produce dead tuples what slowed down db operations.
This behavior sometimes also introduced problems with autovacuum which
cannot clean up fast after this hughe number of updates

faster by created for observer communitites

See merge request !394

[DLN/EMF] faster get_ranked_posts_by_created_for_observer_communities by first getting limit number of posts in each of the observer's communities, then sorting those by created (post_id)

Reputation calc enabled at LIVE SYNC again

See merge request !393

Jsalyers more community muting changes

See merge request !392

changes in various places to clean the code and fix small problems

See merge request !387

[Change] blacklisted accounts and blacklists ordered by name to make sure order is always the same
[Ign] removed nonimplemented methods from follow_api/tags_api
[Ign] mock data slightly extended