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.