/tst/org/diffkit/diff/testcase/test15.README.txt

http://diffkit.googlecode.com/ · Plain Text · 27 lines · 22 code · 5 blank · 0 comment · 0 complexity · 4f2056522224acaf64eb09374b05f560 MD5 · raw file 

    

  1. test15 README
    2. 

  2. =========
    3. 

  3. 

  4. Description
    5. 

  5. ----------
    6. 

  6. Test global numberTolerance and toleranceMap. MagicPlan will ensure that no numeric diffs of magnitude
    7. 

  7. less than 3 will be considered (numberTolerance =2), and that any diffs in COLUMN3 and COLUMN4 that 
    8. 

  8. are not greater than 4 (toleranceMap; 4=COLUMN3,COLUMN4) will be ignored.
    9. 

  9. 

  10. 

  11. Assumptions
    12. 

  12. -----------
    13. 

  13. - lhs & rhs are DB tables
    14. 

  14. - lhs vs. rhs has column and row diffs
    15. 

  15. - plan file supplies lhs table name and rhs table name
    16. 

  16. - plan file supplies ConnectionInfo to H2 DB
    17. 

  17. - lhs and rhs tables have identical structure
    18. 

  18. - MagicPlan reverse engineers TableModels from the database
    19. 

  19. - MagicPlan generates default TableComparison by aligning lhs column to rhs column based on name
    20. 

  20. - MagicPlan builds TableComparison to globally tolerate diffs of 2 or less in any numeric columns
    21. 

  21. - MagicPlan overrides the global tolerance for COLUMN3 and COLUMN4, setting it to 4 instead of 2
    22. 

  22. 

  23. 

  24. Expectations
    25. 

  25. -----------
    26. 

  26. - 2 row diffs
    27. 

  27. - 4 column diffs, all in COLUMN4, because all other diffs (in COLUMN2 and COLUMN3) are within tolerance.
    28.