[JES] One more test, but I think this is what I was needing to keep the query from slowing down while checking mutes

[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