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

http://diffkit.googlecode.com/ · Plain Text · 30 lines · 26 code · 4 blank · 0 comment · 0 complexity · 99606e08b7225ff1877b9888fc12beec MD5 · raw file 

    

  1. test33 README
    2. 

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

  3. 

  4. Description
    5. 

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

  6. Compare SpreadSheet tables using a MagicPlan. Sheet name is not specified, so 
    7. 

  7. that the first sheet is used by default. No key is specified in the plan, so 
    8. 

  8. ROW_NUM will be used. Demonstrates how ROW_DIFFs are reported when using ROW_NUM
    9. 

  9. as the key. Demonstrates use of header row (hasHeader -> true). 
    10. 

  10. Exercises several different data types. This test is same as test31, except that
    11. 

  11. it is specified using a MagicPlan instead of the PassthroughPlan used in test31.
    12. 

  12. 

  13. Assumptions
    14. 

  14. -----------
    15. 

  15. - lhs & rhs are SpreadSheet FILE tables
    16. 

  16. - MagicPlan supplies lhs and rhs spreadsheet file paths
    17. 

  17. - MagicPlan supplies file path for Sink
    18. 

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

  19. - No key is specified in the MagicPlan, so ROW_NUM should be used
    20. 

  20. - MagicPlan specifies that a header row is present, so will identify diffs
    21. 

  21. using column names from header, instead of default Excel column name (A,B,C....).
    22. 

  22. 

  23. Expectations
    24. 

  24. -----------
    25. 

  25. - 1 ROW_DIFF, becuase ROW_NUM is used for alignment and only ROW_NUM=7 is
    26. 

  26. different between the two side
    27. 

  27. - 32 COLUMN_DIFFs. All columns must be different in the rows where one side is blank
    28. 

  28. and the other side isn't (ROW_NUM= 2,3,6 = 3 rows * 8 columns = 24 ROW_DIFFs). 
    29. 

  29. All columns explicitly set to different values in ROW_NUM = 5 in order to exercise each column.
    30.