modernc.org/cc@v1.0.1/v2/testdata/_sqlite/ext/session/session8.test (about)

     1  # 2011 July 13
     2  #
     3  # The author disclaims copyright to this source code.  In place of
     4  # a legal notice, here is a blessing:
     5  #
     6  #    May you do good and not evil.
     7  #    May you find forgiveness for yourself and forgive others.
     8  #    May you share freely, never taking more than you give.
     9  #
    10  #***********************************************************************
    11  # This file implements regression tests for SQLite library.
    12  #
    13  
    14  if {![info exists testdir]} {
    15    set testdir [file join [file dirname [info script]] .. .. test]
    16  } 
    17  source [file join [file dirname [info script]] session_common.tcl]
    18  source $testdir/tester.tcl
    19  ifcapable !session {finish_test; return}
    20  
    21  set testprefix session8
    22  
    23  proc noop {args} {}
    24  
    25  # Like [dbcksum] in tester.tcl. Except this version is not sensitive
    26  # to changes in the value of implicit IPK columns.
    27  #
    28  proc udbcksum {db dbname} {
    29    if {$dbname=="temp"} {
    30      set master sqlite_temp_master
    31    } else {
    32      set master $dbname.sqlite_master
    33    }
    34    set alltab [$db eval "SELECT name FROM $master WHERE type='table'"]
    35    set txt [$db eval "SELECT * FROM $master"]\n
    36    foreach tab $alltab {
    37      append txt [lsort [$db eval "SELECT * FROM $dbname.$tab"]]\n
    38    }
    39    return [md5 $txt]
    40  }
    41  
    42  proc do_then_undo {tn sql} {
    43    set ck1 [udbcksum db main]
    44  
    45    sqlite3session S db main
    46    S attach *
    47    db eval $sql
    48  
    49    set ck2 [udbcksum db main]
    50    
    51    set invert [sqlite3changeset_invert [S changeset]]
    52    S delete
    53    sqlite3changeset_apply db $invert noop
    54  
    55    set ck3 [udbcksum db main]
    56  
    57    set a [expr {$ck1==$ck2}]
    58    set b [expr {$ck1==$ck3}]
    59    uplevel [list do_test $tn.1 "set {} $a" 0]
    60    uplevel [list do_test $tn.2 "set {} $b" 1]
    61  }
    62  
    63  do_execsql_test 1.1 {
    64    CREATE TABLE t1(a PRIMARY KEY, b);
    65    INSERT INTO t1 VALUES(1, 2);
    66    INSERT INTO t1 VALUES("abc", "xyz");
    67  }
    68  do_then_undo 1.2 { INSERT INTO t1 VALUES(3, 4); }
    69  do_then_undo 1.3 { DELETE FROM t1 WHERE b=2; }
    70  do_then_undo 1.4 { UPDATE t1 SET b = 3 WHERE a = 1; }
    71  
    72  do_execsql_test 2.1 {
    73    CREATE TABLE t2(a, b PRIMARY KEY);
    74    INSERT INTO t2 VALUES(1, 2);
    75    INSERT INTO t2 VALUES('abc', 'xyz');
    76  }
    77  do_then_undo 1.2 { INSERT INTO t2 VALUES(3, 4); }
    78  do_then_undo 1.3 { DELETE FROM t2 WHERE b=2; }
    79  do_then_undo 1.4 { UPDATE t1 SET a = '123' WHERE b = 'xyz'; }
    80  
    81  do_execsql_test 3.1 {
    82    CREATE TABLE t3(a, b, c, d, e, PRIMARY KEY(c, e));
    83    INSERT INTO t3 VALUES('x', 45, 0.0, 'abcdef', 12);
    84    INSERT INTO t3 VALUES(45, 0.0, 'abcdef', 12, 'x');
    85    INSERT INTO t3 VALUES(0.0, 'abcdef', 12, 'x', 45);
    86  }
    87  
    88  do_then_undo 3.2 { UPDATE t3 SET b=b||b WHERE e!='x' }
    89  do_then_undo 3.3 { UPDATE t3 SET a = 46 }
    90  
    91  finish_test