[JES] Add ordering to blacklists for consistency

See merge request !422

Jsalyers blacklist v2

See merge request !421

[JES] Validate observer account exists. I'm not sure if we need this. I suppose it could impact performance if the account didn't exist in the database?

[JES] Add muting functionaility back to brdige_get_ranked_post_by_created_for_observer_communities

See merge request !407

point to latest. tests should pass now

even though this was exactly the same on my other branch and it wasn't causing issues..

fix commit hash

doing a cleaner merge. found the issues in my old branch that were giving me such a headache all day. let's see how a CI does now, I'm expecting a couple of fails but all the reputation-0 fails should now be fixed

Various fixes to problems discovered by 1000_pairs test and more

See merge request !418

[ABW]: [Fix] query updating hive_posts.active no longer stops update on older active (which can come from edit) - fixes second set of problems with active value in 1000_pairs test
[Fix] delete_hive_post now properly updates active value - fixes first set of problems with it in 1000_pairs test
[Fix] order of posts in database_api.find_comments is now defined by order requested in call parameters (1000_pairs test)
[Fix] added escaping to find_comments values (escape_chars test)
[Fix] unified checks in various community related calls (in some cases it means there is check where there was none)
added find_community_id SQL function that follows other find_ routines (there is more places where it should be used, community related get_ranked_posts versions in particular)

Mock blocks with reblog operations

See merge request !400

hivemind communities tests

See merge request !415

Small fixes and mock data for observer tests in get_ranked_posts

See merge request !416

[ABW]: find_tag_id/find_category_id moved to utility_functions.sql and changed so they follow example of find_comment_id with their error handling
added extra promotion and new ignored accounts in mock data for observer tests
observer in get_ranked_posts is now validated (it was actually validated already, but only after main query, now it happens as early as possible)
fixed problem with default value of limit in get_ranked_posts (when explicit null was passed); also all string params now are empty instead of None

Corrections related to bridge.get_discussion + some cleanup

See merge request !413

[ABW]: find_account_id changed to be similar to find_comment_id (other routines like that will likely follow) - True means the check will be performed, but not when account is empty (that needs to be blocked/allowed in python code)
get_discussion SQL function renamed to bridge_get_discussion
added validation of observer in get_discussion

Benchmark time limit increased to 1.5 s

See merge request !412

more small changes, get_discussions_by_blog reusing bridge SQL function

See merge request !410

Direct hive server logging to file only

See merge request !403

vacuuming hive_posts only for massive sync

See merge request !411

fix for drop hive_post_dags without assign tags to post during upgrades

See merge request !405

- temporary eliminated DROP TABLE hive_post_tags until staging tests will finish.