PageRenderTime 23ms CodeModel.GetById 16ms app.highlight 2ms 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
 1test36 README
 2=========
 3
 4Description
 5----------
 6Compare a SpreadSheet on the LHS vs. a DB Source on the RHS, using a MagicPlan.
 7Demonstrates the use of ToleranceMap. Also highlights a bug in DiffKit data type
 8coercion. COLUMN5 has the same type (to the extent that you can clearly type SS
 9columns) in both the SS and the DB: Time. It's read from both sources a java.sql.Time,
10however there is some subtle difference in the way that the values are read that
11results in different Time (reported by getTime()) values. So COLUMN5 generates
12a diff in every row even though the values appear to be the same in the diff
13report file.
14
15Assumptions
16-----------
17- lhs is a SpreadSheet FILE table
18- rhs is DB table
19
20- MagicPlan supplies lhs spreadsheet file path
21- MagicPlan supplies rhs DB table name and ConnectionInfo
22- MagicPlan supplies file path for Sink
23- lhs and rhs tables have nearly identical structure
24- key is specified as COLUMN1, which is Type String in SS
25- MagicPlan specifies that a header row is present in the Spreadsheet.
26
27Expectations
28-----------
29- 7 ROW_DIFFs
30- 33 COLUMN_DIFFs
31