# 2007 September 10 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: thread_common.tcl,v 1.5 2009/03/26 14:48:07 danielk1977 Exp $ if {[info exists ::thread_procs]} { return 0 } # The following script is sourced by every thread spawned using # [sqlthread spawn]: set thread_procs { # Execute the supplied SQL using database handle $::DB. # proc execsql {sql} { set rc SQLITE_LOCKED while {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY" || $rc eq "SQLITE_SCHEMA"} { set res [list] enter_db_mutex $::DB set err [catch { set ::STMT [sqlite3_prepare_v2 $::DB $sql -1 dummy_tail] } msg] if {$err == 0} { while {[set rc [sqlite3_step $::STMT]] eq "SQLITE_ROW"} { for {set i 0} {$i < [sqlite3_column_count $::STMT]} {incr i} { lappend res [sqlite3_column_text $::STMT 0] } } set rc [sqlite3_finalize $::STMT] } else { if {[lindex $msg 0]=="(6)"} { set rc SQLITE_LOCKED } else { set rc SQLITE_ERROR } } if {[string first locked [sqlite3_errmsg $::DB]]>=0} { set rc SQLITE_LOCKED } if {$rc ne "SQLITE_OK"} { set errtxt "$rc - [sqlite3_errmsg $::DB] (debug1)" } leave_db_mutex $::DB if {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY"} { #sqlthread parent "puts \"thread [sqlthread id] is busy. rc=$rc\"" after 200 } else { #sqlthread parent "puts \"thread [sqlthread id] ran $sql\"" } } if {$rc ne "SQLITE_OK"} { error $errtxt } set res } proc do_test {name script result} { set res [eval $script] if {$res ne $result} { error "$name failed: expected \"$result\" got \"$res\"" } } } proc thread_spawn {varname args} { sqlthread spawn $varname [join $args {;}] } # Return true if this build can run the multi-threaded tests. # proc run_thread_tests {{print_warning 0}} { ifcapable !mutex { set zProblem "SQLite build is not threadsafe" } ifcapable mutex_noop { set zProblem "SQLite build uses SQLITE_MUTEX_NOOP" } if {[info commands sqlthread] eq ""} { set zProblem "SQLite build is not threadsafe" } if {![info exists ::tcl_platform(threaded)]} { set zProblem "Linked against a non-threadsafe Tcl build" } if {[info exists zProblem]} { puts "WARNING: Multi-threaded tests skipped: $zProblem" return 0 } set ::run_thread_tests_called 1 return 1; } return 0