Fixes on deleted posts and beneficiaries

See merge request !105

[ABW]: Deleted posts filtered out from hive_posts_view, no longer need filtering everywhere outside (also fixes some places where check on deleted post was missing).
sqlalchemy has problem with passing JSON to query parameter - changed to passing as string (fixes problem of {} where [] should be).

List comments by parent opts

See merge request !104

Various small fixes in bridge and condenser api

See merge request !102

Fixed code that reads beneficiaries from operation
Changed error response from None to proper error in bridge.get_profile and bridge.get_post_header
Empty raw_json in hive_accounts no longer crashes API calls
condenser_api uses sum of payout and pending_payout for correct order by payout
When selecting blog posts with special start_index value (0 or -1) limit is shortened when there is not enough posts (was error which made no sense)
[Ign] changed order in hive_posts_view so all vote related fields are near each other

Eliminated NULL from hive_posts::root_id column. Since actual ID is not...

See merge request !101

NULL-post (having id 0) shall be eliminated from resultset to make place for real one when query results are limited.

Mi wrong active when root post was updated

See merge request !100

When parent post was updated later then the last its comment,
then post active time was incorrectly overwritten by its child
active time

Small bridge api fix

See merge request !99

Eliminated NULL from hive_posts::root_id column. Since actual ID is not available yet during inserting root post, this column is updated at the end of initial-sync or processed block.
Simplified hive_posts_root_id index, to speedup list_comments_by_root queries
Optimized query used to access posts inside list_comments_by_root.
Deleted obsolete file scripts/update_hivemind_db.sql

[ABW]: two small fixes for bridge_api (crash on incorrect dict key, wrong vote format in one of calls)

set fillfactor for tables intesively updated

See merge request !97

Fixes related to time in database_api and some more

See merge request !95

[ABW]: final payout no longer overwrites previous payout values with zeros when it was with no actual payout

Merge branch 'database_api_by_time_order' of gitlab.syncad.com:hive/hivemind into database_api_by_time_order

Mi fix for slowdown

See merge request !96

Added generation of completion file for hivemind (hive)

See merge request !83

Added auto-http-server-port command line option

See merge request !91

Dariusz Kędzierski authored 4 years ago and Bartek Wrona committed 4 years ago

- program option allowing hivemind to bind to first available port
- port is chosen from range defined in option
- additionally port number is written to a hivemind.port file
- removed version.py from repo. gitignore now ignore this file as
  expected
- added hivemind.port to gitignore

Merge branch 'database_api_by_time_order' of gitlab.syncad.com:hive/hivemind into database_api_by_time_order

Mi posts active computed and block num column hive posts

See merge request !94

[ABW]: curator_payout_value/total_payout_value now have '0.000 HBD' default to always have asset in value (ultimately they should be changed to numeric columns)
removed columns that we don't intend to update as they would hold irrelevant data: children_abs_rshares, reward_weight; also removed from queries
hive_posts_view no longer has parent_permlink - replaced with parent_permlink_or_category as that's what was in original comment data and what is expected
fixed order by time in list_comments_by_last_update, list_comments_by_author_last_update (newer first)
fixed payout update date - each operation that is part of payout has its own date as (at least some) can be from different blocks
fixed author_rewards - it is a sum of partial rewards for the comment
when payout operations are processed they no longer incorrectly overwrite each other's data
1969 year in date recognized as timestamp::max and replaced by infinity (and the other way when producing results) - fixes corner case of time ordering in by_cashout_time
commented out checks in run_tests.sh as they fail when address contains '-' like in 'hive-3.pl.syncad.com'

Changes related to how posts relate to each other plus fixes in database_api

See merge request !93