wasCSharpSQLite – Blame information for rev 4
?pathlinks?
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | office | 1 | # 2007 September 10
|
| 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 | #
|
||
| 12 | # $Id: thread_common.tcl,v 1.5 2009/03/26 14:48:07 danielk1977 Exp $
|
||
| 13 | |||
| 14 | if {[info exists ::thread_procs]} { |
||
| 15 | return 0 |
||
| 16 | } |
||
| 17 | |||
| 18 | # The following script is sourced by every thread spawned using
|
||
| 19 | # [sqlthread spawn]:
|
||
| 20 | set thread_procs { |
||
| 21 | |||
| 22 | # Execute the supplied SQL using database handle $::DB.
|
||
| 23 | #
|
||
| 24 | proc execsql {sql} { |
||
| 25 | |||
| 26 | set rc SQLITE_LOCKED |
||
| 27 | while {$rc eq "SQLITE_LOCKED" |
||
| 28 | || $rc eq "SQLITE_BUSY" |
||
| 29 | || $rc eq "SQLITE_SCHEMA"} { |
||
| 30 | set res [list] |
||
| 31 | |||
| 32 | enter_db_mutex $::DB |
||
| 33 | set err [catch { |
||
| 34 | set ::STMT [sqlite3_prepare_v2 $::DB $sql -1 dummy_tail] |
||
| 35 | } msg] |
||
| 36 | |||
| 37 | if {$err == 0} { |
||
| 38 | while {[set rc [sqlite3_step $::STMT]] eq "SQLITE_ROW"} { |
||
| 39 | for {set i 0} {$i < [sqlite3_column_count $::STMT]} {incr i} { |
||
| 40 | lappend res [sqlite3_column_text $::STMT 0] |
||
| 41 | } |
||
| 42 | } |
||
| 43 | set rc [sqlite3_finalize $::STMT] |
||
| 44 | } else { |
||
| 45 | if {[lindex $msg 0]=="(6)"} { |
||
| 46 | set rc SQLITE_LOCKED |
||
| 47 | } else { |
||
| 48 | set rc SQLITE_ERROR |
||
| 49 | } |
||
| 50 | } |
||
| 51 | |||
| 52 | if {[string first locked [sqlite3_errmsg $::DB]]>=0} { |
||
| 53 | set rc SQLITE_LOCKED |
||
| 54 | } |
||
| 55 | if {$rc ne "SQLITE_OK"} { |
||
| 56 | set errtxt "$rc - [sqlite3_errmsg $::DB] (debug1)" |
||
| 57 | } |
||
| 58 | leave_db_mutex $::DB |
||
| 59 | |||
| 60 | if {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY"} { |
||
| 61 | #sqlthread parent "puts \"thread [sqlthread id] is busy. rc=$rc\""
|
||
| 62 | after 200 |
||
| 63 | } else { |
||
| 64 | #sqlthread parent "puts \"thread [sqlthread id] ran $sql\""
|
||
| 65 | } |
||
| 66 | } |
||
| 67 | |||
| 68 | if {$rc ne "SQLITE_OK"} { |
||
| 69 | error $errtxt |
||
| 70 | } |
||
| 71 | set res |
||
| 72 | } |
||
| 73 | |||
| 74 | proc do_test {name script result} { |
||
| 75 | set res [eval $script] |
||
| 76 | if {$res ne $result} { |
||
| 77 | error "$name failed: expected \"$result\" got \"$res\"" |
||
| 78 | } |
||
| 79 | } |
||
| 80 | } |
||
| 81 | |||
| 82 | proc thread_spawn {varname args} { |
||
| 83 | sqlthread spawn $varname [join $args {;}] |
||
| 84 | } |
||
| 85 | |||
| 86 | # Return true if this build can run the multi-threaded tests.
|
||
| 87 | #
|
||
| 88 | proc run_thread_tests {{print_warning 0}} { |
||
| 89 | ifcapable !mutex { |
||
| 90 | set zProblem "SQLite build is not threadsafe" |
||
| 91 | } |
||
| 92 | ifcapable mutex_noop { |
||
| 93 | set zProblem "SQLite build uses SQLITE_MUTEX_NOOP" |
||
| 94 | } |
||
| 95 | if {[info commands sqlthread] eq ""} { |
||
| 96 | set zProblem "SQLite build is not threadsafe" |
||
| 97 | } |
||
| 98 | if {![info exists ::tcl_platform(threaded)]} { |
||
| 99 | set zProblem "Linked against a non-threadsafe Tcl build" |
||
| 100 | } |
||
| 101 | if {[info exists zProblem]} { |
||
| 102 | puts "WARNING: Multi-threaded tests skipped: $zProblem" |
||
| 103 | return 0 |
||
| 104 | } |
||
| 105 | set ::run_thread_tests_called 1 |
||
| 106 | return 1; |
||
| 107 | } |
||
| 108 | |||
| 109 | return 0 |
||
| 110 |