Location: PHPKode > projects > deltasql > deltasql-1.0.8/docs/Tests_To_Verify_deltasql_correctness.txt
MANUAL TESTS TO VERIFY deltasql INTEGRITY

You can run these tests manually, if you install deltasql with the option "Test System (with Test Data)" in http://localhost/install.php.
You then have a set of 14 scripts included in the module "deltasql-test-module" and two branches which are named DELTA_1 and DELTA_2. You should verify that exactly the scripts depicted below
 are present in the synchronization script generated by deltasql, if you use the "Synchronize database schema option". 
The rows below are in the form "from version -> scripts contained in output script".
The project used in these tests is named "deltasql-test-project".
 
1. Test: HEAD -> HEAD

12 -> 13, 14, 15, 17, 18, 19, 21, 22, 24
13 -> 14, 15, 17, 18, 19, 21, 22, 24
14 -> 15, 17, 18, 19, 21, 22, 24
15 -> 17, 18, 19, 21, 22, 24
16 -> 17, 18, 19, 21, 22, 24
17 -> 18, 19, 21, 22, 24
18 -> 19, 21, 22, 24
19 -> 21, 22, 24
20 -> 21, 22, 24
21 -> 22, 24
22 -> 24
23 -> 24
24 ->



2. Test: DELTA_1 -> DELTA_1
13 -> 15, 16, 21, 22, 23
14 -> 15, 16, 21, 22, 23
15 -> 16, 21, 22, 23
16 -> 21, 22, 23
17 -> 21, 22, 23
18 -> 21, 22, 23
19 -> 21, 22, 23
20 -> 21, 22, 23
21 -> 22, 23
22 -> 23
23 ->



3. Test: DELTA_2 -> DELTA_2

17 -> 19, 20, 21
18 -> 19, 20, 21
19 -> 20, 21
20 -> 21
21 ->



4. Test: DELTA_1 -> HEAD

13 -> 14, 15, 16, 17, 18, 19, 21, 22, 23, 24
14 -> 14, 15, 16, 17, 18, 19, 21, 22, 23, 24
15 -> 14, 16, 17, 18, 19, 21, 22, 23, 24
16 -> 14, 17, 18, 19, 21, 22, 23, 24
17 -> 14, 17, 18, 19, 21, 22, 23, 24
18 -> 14, 17, 18, 19, 21, 22, 23, 24
19 -> 14, 17, 18, 19, 21, 22, 23, 24
20 -> 14, 17, 18, 19, 21, 22, 23, 24
21 -> 14, 17, 18, 19, 22, 23, 24
22 -> 14, 17, 18, 19, 23, 24
23 -> 14, 17, 18, 19, 24
24 -> 14, 17, 18, 19, 24



5. Test: DELTA_2 -> HEAD

17 -> 17, 18, 19, 20, 21, 22, 24
18 -> 17, 18, 19, 20, 21, 22, 24
19 -> 17, 18, 21, 20, 22, 24
20 -> 17, 18, 21, 22, 24
21 -> 17, 18, 22, 24
22 -> 17, 18, 22, 24
23 -> 17, 18, 22, 24
24 -> 17, 18, 22, 24



6. Test: HEAD -> DELTA_1
not possible for any version


7. Test: HEAD -> DELTA_2
not possible for any version


8. Test: HEAD -> DELTA_1
11 -> 12, 13, 15, 16, 21, 22, 23
12 -> 13, 15, 16, 21, 22, 23
13 -> 15, 16, 21, 22, 23
14 -> cannot downgrade a project


9. Test: HEAD -> DELTA_2

11 -> 12, 13, 14, 15, 17, 19, 20 ,21
12 -> 13, 14, 15, 17, 19, 20, 21
13 -> 14, 15, 17, 19, 20, 21
14 -> 15, 17, 19, 20, 21
15 -> 17, 19, 20, 21
16 -> 17, 19, 20, 21
17 -> 19, 20, 21
18 -> 19, 20, 21
19 -> 20, 21
20 -> 21
21 ->

Return current item: deltasql