|
sl@0
|
1 |
# 2007 September 10
|
|
sl@0
|
2 |
#
|
|
sl@0
|
3 |
# The author disclaims copyright to this source code. In place of
|
|
sl@0
|
4 |
# a legal notice, here is a blessing:
|
|
sl@0
|
5 |
#
|
|
sl@0
|
6 |
# May you do good and not evil.
|
|
sl@0
|
7 |
# May you find forgiveness for yourself and forgive others.
|
|
sl@0
|
8 |
# May you share freely, never taking more than you give.
|
|
sl@0
|
9 |
#
|
|
sl@0
|
10 |
#***********************************************************************
|
|
sl@0
|
11 |
#
|
|
sl@0
|
12 |
# $Id: thread_common.tcl,v 1.2 2007/09/10 10:53:02 danielk1977 Exp $
|
|
sl@0
|
13 |
|
|
sl@0
|
14 |
set testdir [file dirname $argv0]
|
|
sl@0
|
15 |
source $testdir/tester.tcl
|
|
sl@0
|
16 |
|
|
sl@0
|
17 |
if {[info commands sqlthread] eq ""} {
|
|
sl@0
|
18 |
puts -nonewline "Skipping thread-safety tests - "
|
|
sl@0
|
19 |
puts " not running a threadsafe sqlite/tcl build"
|
|
sl@0
|
20 |
puts -nonewline "Both SQLITE_THREADSAFE and TCL_THREADS must be defined when"
|
|
sl@0
|
21 |
puts " building testfixture"
|
|
sl@0
|
22 |
finish_test
|
|
sl@0
|
23 |
return
|
|
sl@0
|
24 |
}
|
|
sl@0
|
25 |
|
|
sl@0
|
26 |
# The following script is sourced by every thread spawned using
|
|
sl@0
|
27 |
# [sqlthread spawn]:
|
|
sl@0
|
28 |
set thread_procs {
|
|
sl@0
|
29 |
|
|
sl@0
|
30 |
# Execute the supplied SQL using database handle $::DB.
|
|
sl@0
|
31 |
#
|
|
sl@0
|
32 |
proc execsql {sql} {
|
|
sl@0
|
33 |
|
|
sl@0
|
34 |
set rc SQLITE_LOCKED
|
|
sl@0
|
35 |
while {$rc eq "SQLITE_LOCKED"
|
|
sl@0
|
36 |
|| $rc eq "SQLITE_BUSY"
|
|
sl@0
|
37 |
|| $rc eq "SQLITE_SCHEMA"} {
|
|
sl@0
|
38 |
set res [list]
|
|
sl@0
|
39 |
|
|
sl@0
|
40 |
set err [catch {
|
|
sl@0
|
41 |
set ::STMT [sqlite3_prepare_v2 $::DB $sql -1 dummy_tail]
|
|
sl@0
|
42 |
} msg]
|
|
sl@0
|
43 |
|
|
sl@0
|
44 |
if {$err == 0} {
|
|
sl@0
|
45 |
while {[set rc [sqlite3_step $::STMT]] eq "SQLITE_ROW"} {
|
|
sl@0
|
46 |
for {set i 0} {$i < [sqlite3_column_count $::STMT]} {incr i} {
|
|
sl@0
|
47 |
lappend res [sqlite3_column_text $::STMT 0]
|
|
sl@0
|
48 |
}
|
|
sl@0
|
49 |
}
|
|
sl@0
|
50 |
set rc [sqlite3_finalize $::STMT]
|
|
sl@0
|
51 |
} else {
|
|
sl@0
|
52 |
if {[string first (6) $msg]} {
|
|
sl@0
|
53 |
set rc SQLITE_LOCKED
|
|
sl@0
|
54 |
} else {
|
|
sl@0
|
55 |
set rc SQLITE_ERROR
|
|
sl@0
|
56 |
}
|
|
sl@0
|
57 |
}
|
|
sl@0
|
58 |
|
|
sl@0
|
59 |
if {[string first locked [sqlite3_errmsg $::DB]]>=0} {
|
|
sl@0
|
60 |
set rc SQLITE_LOCKED
|
|
sl@0
|
61 |
}
|
|
sl@0
|
62 |
|
|
sl@0
|
63 |
if {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY"} {
|
|
sl@0
|
64 |
#puts -nonewline "([sqlthread id] $rc)"
|
|
sl@0
|
65 |
#flush stdout
|
|
sl@0
|
66 |
after 20
|
|
sl@0
|
67 |
}
|
|
sl@0
|
68 |
}
|
|
sl@0
|
69 |
|
|
sl@0
|
70 |
if {$rc ne "SQLITE_OK"} {
|
|
sl@0
|
71 |
error "$rc - [sqlite3_errmsg $::DB]"
|
|
sl@0
|
72 |
}
|
|
sl@0
|
73 |
set res
|
|
sl@0
|
74 |
}
|
|
sl@0
|
75 |
|
|
sl@0
|
76 |
proc do_test {name script result} {
|
|
sl@0
|
77 |
set res [eval $script]
|
|
sl@0
|
78 |
if {$res ne $result} {
|
|
sl@0
|
79 |
error "$name failed: expected \"$result\" got \"$res\""
|
|
sl@0
|
80 |
}
|
|
sl@0
|
81 |
}
|
|
sl@0
|
82 |
}
|
|
sl@0
|
83 |
|
|
sl@0
|
84 |
proc thread_spawn {varname args} {
|
|
sl@0
|
85 |
sqlthread spawn $varname [join $args ;]
|
|
sl@0
|
86 |
}
|
|
sl@0
|
87 |
|
|
sl@0
|
88 |
return 0
|