Skip to content
Snippets Groups Projects

issue #259 automaticly get tables to db hash computation

Merged Marcin requested to merge mi/issue#259_hash_for_hafd into develop

The old database during the update got injected hash computation algorithm from the newer version. The same algorithm is used for old and new versions of Hive Fork Manager. This way in case of a bug in the old version it is possible to repair hash computation with the new hfm version.

Hash is computed for all tables in the hafd schema (except state providers tables), not only for those included in the list forgotten by devs.

Only state providers used in db (registered in contexts) impact the whole db hash.

hash db functions without schema name parameter There is no sense to pass schema parameter to hash db computation, at the end, there was a list of tables to take into computation, and all of they belong to the hafd schema.

Remove hafd.table_schema table, the hash is used only to check if an update is possible, it is not a database hash because some elements are omitted during its computations and its value cannot be used to determine if schemas of two databases with hfm are similar. hafd.table_schema table blocked the total separation of hive_updata schema elements from the rest of the hive fork manager

Edited by Marcin

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Marcin
  • Marcin
  • Marcin added 1 commit

    added 1 commit

    • b86d63ad - use drop function if exists instead create or replace fior hash functions

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • 75619313 - verify_table_schema in update sql file

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • 2d55bbc2 - all update functions in one file in schema hive_update

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • c524e404 - all update functions in one file in schema hive_update

    Compare with previous version

  • Marcin resolved all threads

    resolved all threads

  • Marcin added 1 commit

    added 1 commit

    • a09ebdc5 - all update functions in one file in schema hive_update

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • 4110a96e - all update functions in one file in schema hive_update

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • 00b935c7 - eliminate hafd.table_schema from usage

    Compare with previous version

  • Marcin added 1 commit

    added 1 commit

    • 3298958b - remove hafd.table_schema table

    Compare with previous version

  • Marcin changed the description

    changed the description

  • Marcin
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Please register or sign in to reply
    Loading