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

http://diffkit.googlecode.com/ · Plain Text · 30 lines · 25 code · 5 blank · 0 comment · 0 complexity · 2bdcaf74738aa032d637f6effcbce7c0 MD5 · raw file

  1. test20 README
  2. =========
  3. Description
  4. ----------
  5. Demos issue 5. The target DB tables do not have PK defined at the SQL level. User
  6. has specified keyColumnNames in the plan file. DKDBSource must reorder the rows
  7. appropriately for the key definition in the plan file to assure that there is only
  8. 1 row diff.
  9. Assumptions
  10. -----------
  11. - lhs & rhs are DB tables
  12. - DB tables do not have PK defined
  13. - plan file supplies lhs table name and rhs table name
  14. - plan file supplies ConnectionInfo to H2 DB
  15. - lhs and rhs tables have identical structure
  16. - plan file supplies key for ordering the rows
  17. - MagicPlan reverse engineers TableModels from the database
  18. - MagicPlan generates default TableComparison by aligning lhs column to rhs column based on name
  19. - MagicPlan generates SQL SELECT using plan supplied keyColumnNames for the ORDER BY clause
  20. - MagicPlan uses EqualsDiffor across the board
  21. - MagicPlan defaults to looking for ROW and COLUMN type Diffs
  22. - MagicPlan sets max diffs to Long.MAX
  23. Expectations
  24. -----------
  25. - 1 row diff