PageRenderTime 19ms CodeModel.GetById 14ms RepoModel.GetById 1ms app.codeStats 0ms

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

http://diffkit.googlecode.com/
Plain Text | 31 lines | 26 code | 5 blank | 0 comment | 0 complexity | c8eca01402ef920e53f2e198efe601f1 MD5 | raw file
    

  1. test36 README
    2. 

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

  3. 

  4. Description
    5. 

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

  6. Compare a SpreadSheet on the LHS vs. a DB Source on the RHS, using a MagicPlan.
    7. 

  7. Demonstrates the use of ToleranceMap. Also highlights a bug in DiffKit data type
    8. 

  8. coercion. COLUMN5 has the same type (to the extent that you can clearly type SS
    9. 

  9. columns) in both the SS and the DB: Time. It's read from both sources a java.sql.Time,
    10. 

  10. however there is some subtle difference in the way that the values are read that
    11. 

  11. results in different Time (reported by getTime()) values. So COLUMN5 generates
    12. 

  12. a diff in every row even though the values appear to be the same in the diff
    13. 

  13. report file.
    14. 

  14. 

  15. Assumptions
    16. 

  16. -----------
    17. 

  17. - lhs is a SpreadSheet FILE table
    18. 

  18. - rhs is DB table
    19. 

  19. 

  20. - MagicPlan supplies lhs spreadsheet file path
    21. 

  21. - MagicPlan supplies rhs DB table name and ConnectionInfo
    22. 

  22. - MagicPlan supplies file path for Sink
    23. 

  23. - lhs and rhs tables have nearly identical structure
    24. 

  24. - key is specified as COLUMN1, which is Type String in SS
    25. 

  25. - MagicPlan specifies that a header row is present in the Spreadsheet.
    26. 

  26. 

  27. Expectations
    28. 

  28. -----------
    29. 

  29. - 7 ROW_DIFFs
    30. 

  30. - 33 COLUMN_DIFFs
    31. 

  31. 

  32.