OLD | NEW |
1 # 200 July 1 | 1 # 200 July 1 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 57 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
68 foreach {name f} $files { | 68 foreach {name f} $files { |
69 lappend L $name [execsql "SELECT x FROM $name.tbl"] | 69 lappend L $name [execsql "SELECT x FROM $name.tbl"] |
70 } | 70 } |
71 set L | 71 set L |
72 } $files | 72 } $files |
73 | 73 |
74 set L [list] | 74 set L [list] |
75 set S "" | 75 set S "" |
76 foreach {name f} $files { | 76 foreach {name f} $files { |
77 if {[permutation] == "journaltest"} { | 77 if {[permutation] == "journaltest"} { |
78 lappend L delete | 78 set mode delete |
79 } else { | 79 } else { |
80 lappend L wal | 80 set mode wal |
81 } | 81 } |
| 82 ifcapable !wal { set mode delete } |
| 83 lappend L $mode |
82 append S " | 84 append S " |
83 PRAGMA $name.journal_mode = WAL; | 85 PRAGMA $name.journal_mode = WAL; |
84 UPDATE $name.tbl SET x = '$name'; | 86 UPDATE $name.tbl SET x = '$name'; |
85 " | 87 " |
86 } | 88 } |
87 do_execsql_test 1.5 $S $L | 89 do_execsql_test 1.5 $S $L |
88 | 90 |
89 do_test 1.6 { | 91 do_test 1.6 { |
90 set L [list] | 92 set L [list] |
91 foreach {name f} $files { | 93 foreach {name f} $files { |
(...skipping 15 matching lines...) Expand all Loading... |
107 foreach {name f} $files { | 109 foreach {name f} $files { |
108 lappend L $name [execsql "SELECT x FROM $name.tbl"] | 110 lappend L $name [execsql "SELECT x FROM $name.tbl"] |
109 } | 111 } |
110 set L | 112 set L |
111 } $files | 113 } $files |
112 | 114 |
113 db close | 115 db close |
114 foreach {name f} $files { forcedelete $f } | 116 foreach {name f} $files { forcedelete $f } |
115 | 117 |
116 finish_test | 118 finish_test |
OLD | NEW |