# 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.1 2007/09/10 07:35:47 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl if {[info commands sqlthread] eq ""} { puts -nonewline "Skipping thread-safety tests - " puts " not running a threadsafe sqlite/tcl build" puts -nonewline "Both SQLITE_THREADSAFE and TCL_THREADS must be defined when" puts " building testfixture" finish_test return } set ::NTHREAD 10 # 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"} { set res [list] set ::STMT [sqlite3_prepare $::DB $sql -1 dummy_tail] 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] if {$rc eq "SQLITE_LOCKED"} { after 20 } } if {$rc ne "SQLITE_OK"} { error "$rc - [sqlite3_errmsg $::DB]" } 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 0