[JES] Missed an irredeemables check. Those are no longer needed since that was part of the old muting code

[JES] More updates to muting. Adding is_muted to the raw posts returned from the database to make it easier to determine which posts were muted by mods/admins

Merge branch 'jsalyers-muting-at-sql-level' of gitlab.syncad.com:hive/hivemind into jsalyers-muting-at-sql-level

Dariusz Kędzierski authored 4 years ago and Jason Salyers committed 4 years ago

Removed delta calculations from follow.py. Follower/following calculation moved to dedicated SQL function.

Dariusz Kędzierski authored 4 years ago and Jason Salyers committed 4 years ago

Cast all follow name data to string. Should protect against setting non string data types as names in follower and following

Andrzej Lisak authored 4 years ago and Jason Salyers committed 4 years ago

[Fix] get_account_reputations no longer fails with error when account_lower_bound is skipped; also added real default value for limit (1000)
[Fix] bridge_get_ranked_post_by_trends_for_observer_communities now validates observer like other functions of the same family
[Fix] all VOLATILE get_ranked_post related SQL functions turned into STABLE

[JES] Revert the is_muted carryover for now. We will need that though unless someone has a different idea of how to fetch posts muted in communities by admins/mods

[JES] Create a view for getting the muted accounts. Not In/Not Exists/Left Join all have extremely similar processing times. Went with Not In for readibility

[JES] Try to apply muting at the SQL level instead for more efficiency. This only covers the bridge methods at the moment

[JES] Revert the is_muted carryover for now. We will need that though unless someone has a different idea of how to fetch posts muted in communities by admins/mods

[JES] Create a view for getting the muted accounts. Not In/Not Exists/Left Join all have extremely similar processing times. Went with Not In for readibility

[JES] Try to apply muting at the SQL level instead for more efficiency. This only covers the bridge methods at the moment

New tests for `condenser_api.get_state`

See merge request !351

issue #91: incorrect results when initial sync started not from scratch

See merge request !354

fix incorrect volatile sql function type

See merge request !366

condenser get trending tags opt

See merge request !365

Changes in index definitions, to significantly speedup 'condenser_api.get_trending_tags' call. Dedicated index created: hive_posts_category_id_payout_plus_pending_payout_depth_idx
Other indexes (mostly used by bridge_api.get_ranked_posts) has been extended by WHERE condition to eliminate rows does not matching conditions. This way indexes size has been significantly reduced.

Recreate table deps_saved_ddl when doing db upgrade

See merge request !360

This reverts commit 4a9e1e14.

get account posts by feed fix

See merge request !362