AryaWu/sqlite

1# 2007 September 102#3# The author disclaims copyright to this source code.  In place of4# 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 14if {[info exists ::thread_procs]} {15  return 016}17 18# The following script is sourced by every thread spawned using 19# [sqlthread spawn]:20set thread_procs {21 22  # Execute the supplied SQL using database handle $::DB.23  #24  proc execsql {sql} {25 26    set rc SQLITE_LOCKED27    while {$rc eq "SQLITE_LOCKED" 28        || $rc eq "SQLITE_BUSY" 29        || $rc eq "SQLITE_SCHEMA"} {30      set res [list]31 32      enter_db_mutex $::DB33      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_LOCKED47        } else {48          set rc SQLITE_ERROR49        }50      }51 52      if {[string first locked [sqlite3_errmsg $::DB]]>=0} {53        set rc SQLITE_LOCKED54      }55      if {$rc ne "SQLITE_OK"} {56        set errtxt "$rc - [sqlite3_errmsg $::DB] (debug1)"57      }58      leave_db_mutex $::DB59 60      if {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY"} {61        #sqlthread parent "puts \"thread [sqlthread id] is busy.  rc=$rc\""62        after 20063      } else {64        #sqlthread parent "puts \"thread [sqlthread id] ran $sql\""65      }66    }67 68    if {$rc ne "SQLITE_OK"} {69      error $errtxt70    }71    set res72  }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 82proc 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#88proc 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 {![tcl::pkgconfig get 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 0104  }105  set ::run_thread_tests_called 1106  return 1;107}108 109return 0110