PageRenderTime 23ms CodeModel.GetById 17ms app.highlight 1ms RepoModel.GetById 2ms app.codeStats 0ms

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

http://diffkit.googlecode.com/
Plain Text | 28 lines | 24 code | 4 blank | 0 comment | 0 complexity | 9bf7b0fae7bb621685f8ce50422ec308 MD5 | raw file
 1test12 README
 2=========
 3
 4Description
 5----------
 6Compare heterogenous sources, lhs is DB rhs is FILE, using MagicPlan. Differences in table structure are
 7silently ignored by AutomaticTableComparison. Column3 is a BIGINT in the DB, but a STRING in the FILE, 
 8because the FILE is only auto modelled. So the Diffor has to perform conversion.
 9
10
11Assumptions
12-----------
13- lhs is DB table
14- rhs is FILE table
15- lhs vs. rhs has both row and column diffs
16- table structures are different. AutomaticTableComparison ensures that only matching column names are used
17- plan file supplies lhs table name and rhs file name
18- plan file supplies ConnectionInfo to H2 DB
19- MagicPlan reverse engineers lhs TableModel from the database
20- MagicPlan reverse engineers rhs TableModel from the file
21- MagicPlan generates default TableComparison by aligning lhs column to rhs column based on name
22- Column3 comparison converts the FILE value from STRING to LONG before diffing
23
24Expectations
25-----------
26- 2 column diffs
27- 3 row diffs
28- diff in row COLUMN1=3333 is not found because it occurs in COLUMN4, which was not in diffColumnNames list.