# 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