[ABW]: some characters apparently need long 8-byte encoding (problem actually caused by use of ujson)

added new test groups to CI with at least single test to make it easier to move tests accourding to new scheme (only follow/tags have no negative tests so no such groups were added)

[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).

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

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

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

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

[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'

[Fix] no == operator in SQL
[Ign] renamed inefficient_deleted_ops to ineffective_deleted_ops

added total_vote_weight column and code filling it with data from updated hived (removed last subquery execution from database_api responses)
added dynamic calculation of abs_shares in hive_posts_view over use of unfilled column of hive_posts (might be changed if we start filling the column)
incoming reward values are no longer cast to INT8, but BIGINT instead
last_payout is no longer passed as not set when post was not yet fully paid
abs_rshares is properly 0 after final payout, vote_rshares are properly sum of all positive rshares

[ABW]: Replaced unused total_votes, up_votes, net_votes in hive_posts with dynamic calculations in view (that change might be reverted in next iteration)
Also removed separate queries to calculate above values - all is now part of hive_posts_view
Reintroduced last_payout_at column updated at every payout (used in database_api)
Added is_effective field to hive_votes (allowed filtering out votes cast after payout and simplification of hive_votes updates)
[Fix] database_api response for posts after payout (payout related values are zeroed)
[Note] total_vote_weight value cannot be properly recreated with data HiveMind currently has - hived change required

[ABW]: [Fix] fixed payouts in bridge_api (still there are differences but they are in DB data, not in how the data is presented)
[Fix] fixed discussion tree building and ordering in bridge_api
[Fix] children needs to be INT in database_api_post
[Fix] fixed condition in database_api::list_comments_by_permlink
[WIP] marked deviations from original fat node behaviour in various database_api::list_comments_by_... functions and in list_votes
[Fix] response from database_api calls is properly a dictionary with array instead of raw array
[Fix] fixed database_api::find_comments arguments and how the query is built (single query with JOIN instead of list of separate same queries with UNION ALL)

[ABW]: [Fix] payout_at/cashout_time changes with hardcoded 7 day cashout (compatible with current rules but not old - see issue #54)
[Fix] basic fixes for bridge_api - added missing votes, removed extra selected fields, changed some field types etc.

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

- fixed sql queries,
- removed matrialized view in sql query,
- fixed imports in manual tests

[ABW]: [Fix] payout related vops are handled with current block timestamp instead of head block time (also commented why it most likely worked like that in 0.23)
[Fix] typo in fork rewind code
[Fix] replaced 1990-01-01 with 1970-01-01 (minimum timestamp) as default in various places where it indicates 'not set' state
[Ign] removed unused last_payout column from hive_posts (the related data was taken from payout_at)

[ABW]: it turns out old code actually did track ineffective (post-payout) votes - changed upsert query to reflect that