# 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.2 2007/09/10 10:53:02 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

 }

 # 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]

       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 {[string first (6) $msg]} {

           set rc SQLITE_LOCKED

         } else {

           set rc SQLITE_ERROR

         }

       }

       if {[string first locked [sqlite3_errmsg $::DB]]>=0} {

         set rc SQLITE_LOCKED

       }

       if {$rc eq "SQLITE_LOCKED" || $rc eq "SQLITE_BUSY"} {

  #puts -nonewline "([sqlthread id] $rc)"

  #flush stdout

         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