tests/tests_api submodule changed to introduce get_discussions_by_blog testcases.

See merge request !111

Eliminated obsolete columns from hive_posts: author_rep, url, root_title

See merge request !109

Simplified hive_votes definition: PK changed to triple [author_id, permlink_id, voter_id], eliminated id column since votes are not referenced
Removed some indexes from hive_votes (redundant)

- Indexes are rebuilt only when resumed sync process imported enough number of blocks.

See merge request !108

- After-initial-sync updates are constrained to the number of blocks currently processed.

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