| OLD | NEW |
| 1 # 2009 February 4 | 1 # 2009 February 4 |
| 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 43 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 54 | 54 |
| 55 # Remember a check-sum on the database file. | 55 # Remember a check-sum on the database file. |
| 56 # | 56 # |
| 57 unset -nocomplain cksum | 57 unset -nocomplain cksum |
| 58 set cksum [dbcksum db main] | 58 set cksum [dbcksum db main] |
| 59 | 59 |
| 60 # Make a backup of the test data. Verify that the backup copy | 60 # Make a backup of the test data. Verify that the backup copy |
| 61 # is identical to the original. | 61 # is identical to the original. |
| 62 # | 62 # |
| 63 do_test backup2-2 { | 63 do_test backup2-2 { |
| 64 file delete -force bu1.db | 64 forcedelete bu1.db |
| 65 db backup bu1.db | 65 db backup bu1.db |
| 66 sqlite3 db2 bu1.db | 66 sqlite3 db2 bu1.db |
| 67 dbcksum db2 main | 67 dbcksum db2 main |
| 68 } $cksum | 68 } $cksum |
| 69 | 69 |
| 70 # Delete the original. Restore from backup. Verify the content is | 70 # Delete the original. Restore from backup. Verify the content is |
| 71 # unchanged. | 71 # unchanged. |
| 72 # | 72 # |
| 73 do_test backup2-3.1 { | 73 do_test backup2-3.1 { |
| 74 db close | 74 db close |
| 75 file delete -force test.db test.db-journal | 75 forcedelete test.db test.db-journal |
| 76 sqlite3 db test.db | 76 sqlite3 db test.db |
| 77 db2 eval {BEGIN EXCLUSIVE} | 77 db2 eval {BEGIN EXCLUSIVE} |
| 78 set rc [catch {db restore bu1.db} res] | 78 set rc [catch {db restore bu1.db} res] |
| 79 lappend rc $res | 79 lappend rc $res |
| 80 db2 eval {ROLLBACK} | 80 db2 eval {ROLLBACK} |
| 81 set rc | 81 set rc |
| 82 } {1 {restore failed: source database busy}} | 82 } {1 {restore failed: source database busy}} |
| 83 do_test backup2-3.2 { | 83 do_test backup2-3.2 { |
| 84 db close | 84 db close |
| 85 file delete -force test.db test.db-journal | 85 forcedelete test.db test.db-journal |
| 86 sqlite3 db test.db | 86 sqlite3 db test.db |
| 87 db restore bu1.db | 87 db restore bu1.db |
| 88 dbcksum db main | 88 dbcksum db main |
| 89 } $cksum | 89 } $cksum |
| 90 | 90 |
| 91 # Use alternative databases - other than "main". | 91 # Use alternative databases - other than "main". |
| 92 # | 92 # |
| 93 do_test backup2-4 { | 93 do_test backup2-4 { |
| 94 db restore temp bu1.db | 94 db restore temp bu1.db |
| 95 dbcksum db temp | 95 dbcksum db temp |
| 96 } $cksum | 96 } $cksum |
| 97 do_test backup2-5 { | 97 do_test backup2-5 { |
| 98 db2 close | 98 db2 close |
| 99 file delete -force bu1.db bu2.db | 99 forcedelete bu1.db bu2.db |
| 100 db backup temp bu2.db | 100 db backup temp bu2.db |
| 101 sqlite3 db2 bu2.db | 101 sqlite3 db2 bu2.db |
| 102 dbcksum db2 main | 102 dbcksum db2 main |
| 103 } $cksum | 103 } $cksum |
| 104 | 104 |
| 105 # Try to backup to a readonly file. | 105 # Try to backup to a readonly file. |
| 106 # | 106 # |
| 107 do_test backup2-6 { | 107 do_test backup2-6 { |
| 108 db2 close | 108 db2 close |
| 109 catch {file attributes bu2.db -permissions r--------} | 109 catch {file attributes bu2.db -permissions r--------} |
| (...skipping 10 matching lines...) Expand all Loading... |
| 120 set out [open bu2.db w] | 120 set out [open bu2.db w] |
| 121 puts $out "This is not a valid database file" | 121 puts $out "This is not a valid database file" |
| 122 close $out | 122 close $out |
| 123 set rc [catch {db backup temp bu2.db} res] | 123 set rc [catch {db backup temp bu2.db} res] |
| 124 lappend rc $res | 124 lappend rc $res |
| 125 } {1 {backup failed: file is encrypted or is not a database}} | 125 } {1 {backup failed: file is encrypted or is not a database}} |
| 126 | 126 |
| 127 # Try to backup database that does not exist | 127 # Try to backup database that does not exist |
| 128 # | 128 # |
| 129 do_test backup2-8 { | 129 do_test backup2-8 { |
| 130 file delete -force bu1.db | 130 forcedelete bu1.db |
| 131 set rc [catch {db backup aux1 bu1.db} res] | 131 set rc [catch {db backup aux1 bu1.db} res] |
| 132 lappend rc $res | 132 lappend rc $res |
| 133 } {1 {backup failed: unknown database aux1}} | 133 } {1 {backup failed: unknown database aux1}} |
| 134 | 134 |
| 135 # Invalid syntax on the backup method | 135 # Invalid syntax on the backup method |
| 136 # | 136 # |
| 137 do_test backup2-9 { | 137 do_test backup2-9 { |
| 138 set rc [catch {db backup} res] | 138 set rc [catch {db backup} res] |
| 139 lappend rc $res | 139 lappend rc $res |
| 140 } {1 {wrong # args: should be "db backup ?DATABASE? FILENAME"}} | 140 } {1 {wrong # args: should be "db backup ?DATABASE? FILENAME"}} |
| 141 | 141 |
| 142 # Try to restore from an unreadable file. | 142 # Try to restore from an unreadable file. |
| 143 # | 143 # |
| 144 if {$tcl_platform(platform)=="windows"} { | 144 if {$tcl_platform(platform)=="windows"} { |
| 145 do_test backup2-10 { | 145 set msg {cannot open source database: unable to open database file} |
| 146 file delete -force bu3.db | 146 } elseif {$tcl_platform(os)=="OpenBSD"} { |
| 147 file mkdir bu3.db | 147 set msg {restore failed: file is encrypted or is not a database} |
| 148 set rc [catch {db restore temp bu3.db} res] | 148 } else { |
| 149 lappend rc $res | 149 set msg {cannot open source database: disk I/O error} |
| 150 } {1 {cannot open source database: unable to open database file}} | |
| 151 } | 150 } |
| 152 if {$tcl_platform(platform)!="windows"} { | 151 do_test backup2-10 { |
| 153 do_test backup2-10 { | 152 forcedelete bu3.db |
| 154 file delete -force bu3.db | 153 file mkdir bu3.db |
| 155 file mkdir bu3.db | 154 set rc [catch {db restore temp bu3.db} res] |
| 156 set rc [catch {db restore temp bu3.db} res] | 155 lappend rc $res |
| 157 lappend rc $res | 156 } [list 1 $msg] |
| 158 } {1 {cannot open source database: disk I/O error}} | |
| 159 } | |
| 160 | 157 |
| 161 # Try to restore from something that is not a database file. | 158 # Try to restore from something that is not a database file. |
| 162 # | 159 # |
| 163 do_test backup2-11 { | 160 do_test backup2-11 { |
| 164 set rc [catch {db restore temp bu2.db} res] | 161 set rc [catch {db restore temp bu2.db} res] |
| 165 lappend rc $res | 162 lappend rc $res |
| 166 } {1 {restore failed: file is encrypted or is not a database}} | 163 } {1 {restore failed: file is encrypted or is not a database}} |
| 167 | 164 |
| 168 # Try to restore a database that does not exist | 165 # Try to restore a database that does not exist |
| 169 # | 166 # |
| 170 do_test backup2-12 { | 167 do_test backup2-12 { |
| 171 set rc [catch {db restore aux1 bu2.db} res] | 168 set rc [catch {db restore aux1 bu2.db} res] |
| 172 lappend rc $res | 169 lappend rc $res |
| 173 } {1 {restore failed: unknown database aux1}} | 170 } {1 {restore failed: unknown database aux1}} |
| 174 do_test backup2-13 { | 171 do_test backup2-13 { |
| 175 file delete -force bu4.db | 172 forcedelete bu4.db |
| 176 set rc [catch {db restore bu4.db} res] | 173 set rc [catch {db restore bu4.db} res] |
| 177 lappend rc $res | 174 lappend rc $res |
| 178 } {1 {cannot open source database: unable to open database file}} | 175 } {1 {cannot open source database: unable to open database file}} |
| 179 | 176 |
| 180 # Invalid syntax on the restore method | 177 # Invalid syntax on the restore method |
| 181 # | 178 # |
| 182 do_test backup2-14 { | 179 do_test backup2-14 { |
| 183 set rc [catch {db restore} res] | 180 set rc [catch {db restore} res] |
| 184 lappend rc $res | 181 lappend rc $res |
| 185 } {1 {wrong # args: should be "db restore ?DATABASE? FILENAME"}} | 182 } {1 {wrong # args: should be "db restore ?DATABASE? FILENAME"}} |
| 186 | 183 |
| 187 file delete -force bu1.db bu2.db bu3.db bu4.db | 184 forcedelete bu1.db bu2.db bu3.db bu4.db |
| 188 | 185 |
| 189 finish_test | 186 finish_test |
| OLD | NEW |