PageRenderTime 21ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

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

http://diffkit.googlecode.com/
Plain Text | 26 lines | 22 code | 4 blank | 0 comment | 0 complexity | fb8952265f82405a831305c70ff43fe0 MD5 | raw file
    

  1. test26 README
    2. 

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

  3. 

  4. Description
    5. 

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

  6. Demonstrates SqlPatchSink, and how it is used to generate SQL statements 
    7. 

  7. (INSERT, DELETE, UPDATE) in order to synchronize two tables. Also demonstrates
    8. 

  8. how DiffKit handles creating DML statements for Strings that contain embedded
    9. 

  9. single quotes (')
    10. 

    11. 

  11. 

  12. Assumptions
    13. 

  13. -----------
    14. 

  14. - lhs & rhs are DB tables
    15. 

  15. - plan file supplies lhs table name and rhs table name
    16. 

  16. - lhs and rhs tables have identical structure
    17. 

  17. - MagicPlan specifies the patchFileName, which configures a SqlPatchSink.
    18. 

  18. - MagicPlan reverse engineers TableModels from the database
    19. 

  19. - there is 
    20. 

  20. 

  21. Expectations
    22. 

  22. -----------
    23. 

  23. - 2 missing row diffs result in 2 INSERT statements.
    24. 

  24. - 2 extra row diffs result in 2 DELETE statements.
    25. 

  25. - column diff on row 3 result in UPDATE statement with 1 value.
    26. 

  26. - 3 column diffs on row 4 result in UPDATE statement with 3 values.
    27.