PageRenderTime 18ms CodeModel.GetById 16ms app.highlight 0ms 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
 1test26 README
 2=========
 3
 4Description
 5----------
 6Demonstrates SqlPatchSink, and how it is used to generate SQL statements 
 7(INSERT, DELETE, UPDATE) in order to synchronize two tables. Also demonstrates
 8how DiffKit handles creating DML statements for Strings that contain embedded
 9single quotes (')
10
11
12Assumptions
13-----------
14- lhs & rhs are DB tables
15- plan file supplies lhs table name and rhs table name
16- lhs and rhs tables have identical structure
17- MagicPlan specifies the patchFileName, which configures a SqlPatchSink.
18- MagicPlan reverse engineers TableModels from the database
19- there is 
20
21Expectations
22-----------
23- 2 missing row diffs result in 2 INSERT statements.
24- 2 extra row diffs result in 2 DELETE statements.
25- column diff on row 3 result in UPDATE statement with 1 value.
26- 3 column diffs on row 4 result in UPDATE statement with 3 values.