xref: /sqlite-3.40.0/test/lock_common.tcl (revision 25568441)
1e264d983Sdan# 2010 April 14
2e264d983Sdan#
3e264d983Sdan# The author disclaims copyright to this source code.  In place of
4e264d983Sdan# a legal notice, here is a blessing:
5e264d983Sdan#
6e264d983Sdan#    May you do good and not evil.
7e264d983Sdan#    May you find forgiveness for yourself and forgive others.
8e264d983Sdan#    May you share freely, never taking more than you give.
9e264d983Sdan#
10e264d983Sdan#***********************************************************************
11e264d983Sdan# This file contains code used by several different test scripts. The
12e264d983Sdan# code in this file allows testfixture to control another process (or
13e264d983Sdan# processes) to test locking.
14e264d983Sdan#
15e264d983Sdan
16a4a9095eSdanproc do_multiclient_test {varname script} {
17a4a9095eSdan
18a4a9095eSdan  foreach code [list {
19*25568441Sdan    if {[info exists ::G(valgrind)]} { db close ; continue }
20a4a9095eSdan    set ::code2_chan [launch_testfixture]
21a4a9095eSdan    set ::code3_chan [launch_testfixture]
22a4a9095eSdan    proc code2 {tcl} { testfixture $::code2_chan $tcl }
23a4a9095eSdan    proc code3 {tcl} { testfixture $::code3_chan $tcl }
24a4a9095eSdan    set tn 1
25a4a9095eSdan  } {
26a4a9095eSdan    proc code2 {tcl} { uplevel #0 $tcl }
27a4a9095eSdan    proc code3 {tcl} { uplevel #0 $tcl }
28a4a9095eSdan    set tn 2
29a4a9095eSdan  }] {
30a4a9095eSdan    faultsim_delete_and_reopen
315653e4daSdan
325653e4daSdan    proc code1 {tcl} { uplevel #0 $tcl }
33a4a9095eSdan
34a4a9095eSdan    # Open connections [db2] and [db3]. Depending on which iteration this
35a4a9095eSdan    # is, the connections may be created in this interpreter, or in
36a4a9095eSdan    # interpreters running in other OS processes. As such, the [db2] and [db3]
37a4a9095eSdan    # commands should only be accessed within [code2] and [code3] blocks,
38a4a9095eSdan    # respectively.
39a4a9095eSdan    #
40a4a9095eSdan    eval $code
41a4a9095eSdan    code2 { sqlite3 db2 test.db }
42a4a9095eSdan    code3 { sqlite3 db3 test.db }
43a4a9095eSdan
44a4a9095eSdan    # Shorthand commands. Execute SQL using database connection [db2] or
45a4a9095eSdan    # [db3]. Return the results.
46a4a9095eSdan    #
47a4a9095eSdan    proc sql1 {sql} { db eval $sql }
48a4a9095eSdan    proc sql2 {sql} { code2 [list db2 eval $sql] }
49a4a9095eSdan    proc sql3 {sql} { code3 [list db3 eval $sql] }
50a4a9095eSdan
51a4a9095eSdan    proc csql1 {sql} { list [catch { sql1 $sql } msg] $msg }
52a4a9095eSdan    proc csql2 {sql} { list [catch { sql2 $sql } msg] $msg }
53a4a9095eSdan    proc csql3 {sql} { list [catch { sql3 $sql } msg] $msg }
54a4a9095eSdan
55a4a9095eSdan    uplevel set $varname $tn
56a4a9095eSdan    uplevel $script
57a4a9095eSdan
58a4a9095eSdan    code2 { db2 close }
59a4a9095eSdan    code3 { db3 close }
60a4a9095eSdan    catch { close $::code2_chan }
61a4a9095eSdan    catch { close $::code3_chan }
622969a587Sdan    catch { db close }
63a4a9095eSdan  }
64a4a9095eSdan}
65a4a9095eSdan
66e264d983Sdan# Launch another testfixture process to be controlled by this one. A
67e264d983Sdan# channel name is returned that may be passed as the first argument to proc
68e264d983Sdan# 'testfixture' to execute a command. The child testfixture process is shut
69e264d983Sdan# down by closing the channel.
708311c47dSdanproc launch_testfixture {{prg ""}} {
7147ee386fSdan  write_main_loop
724f05e38fSdan  if {$prg eq ""} { set prg [info nameofexec] }
734f05e38fSdan  if {$prg eq ""} { set prg testfixture }
743d579059Sdan  if {[file tail $prg]==$prg} { set prg [file join . $prg] }
75e264d983Sdan  set chan [open "|$prg tf_main.tcl" r+]
76e264d983Sdan  fconfigure $chan -buffering line
778311c47dSdan  set rc [catch {
7831f98fc8Sdan    testfixture $chan "sqlite3_test_control_pending_byte $::sqlite_pending_byte"
798311c47dSdan  }]
808311c47dSdan  if {$rc} {
818311c47dSdan    testfixture $chan "set ::sqlite_pending_byte $::sqlite_pending_byte"
828311c47dSdan  }
83e264d983Sdan  return $chan
84e264d983Sdan}
85e264d983Sdan
86e264d983Sdan# Execute a command in a child testfixture process, connected by two-way
87e264d983Sdan# channel $chan. Return the result of the command, or an error message.
88e91a54e1Sdan#
89e264d983Sdanproc testfixture {chan cmd} {
90e264d983Sdan  puts $chan $cmd
91e264d983Sdan  puts $chan OVER
92e264d983Sdan  set r ""
93e264d983Sdan  while { 1 } {
94e264d983Sdan    set line [gets $chan]
95e264d983Sdan    if { $line == "OVER" } {
96e91a54e1Sdan      set res [lindex $r 1]
97e91a54e1Sdan      if { [lindex $r 0] } { error $res }
98e91a54e1Sdan      return $res
99e264d983Sdan    }
100e264d983Sdan    if {[eof $chan]} {
101e264d983Sdan      return "ERROR: Child process hung up"
102e264d983Sdan    }
103e264d983Sdan    append r $line
104e264d983Sdan  }
105e264d983Sdan}
106e264d983Sdan
1075e0ce87aSdanproc testfixture_nb_cb {varname chan} {
108f9b76710Sdan  if {[eof $chan]} {
109f9b76710Sdan    append ::tfnb($chan) "ERROR: Child process hung up"
110f9b76710Sdan    set line "OVER"
111f9b76710Sdan  } else {
1125e0ce87aSdan    set line [gets $chan]
113f9b76710Sdan  }
114f9b76710Sdan
1155e0ce87aSdan  if { $line == "OVER" } {
116e91a54e1Sdan    set $varname [lindex $::tfnb($chan) 1]
1175e0ce87aSdan    unset ::tfnb($chan)
1185e0ce87aSdan    close $chan
1195e0ce87aSdan  } else {
1205e0ce87aSdan    append ::tfnb($chan) $line
1215e0ce87aSdan  }
1225e0ce87aSdan}
1235e0ce87aSdan
1245e0ce87aSdanproc testfixture_nb {varname cmd} {
1255e0ce87aSdan  set chan [launch_testfixture]
1265e0ce87aSdan  set ::tfnb($chan) ""
1275e0ce87aSdan  fconfigure $chan -blocking 0 -buffering none
1285e0ce87aSdan  puts $chan $cmd
1295e0ce87aSdan  puts $chan OVER
1305e0ce87aSdan  fileevent $chan readable [list testfixture_nb_cb $varname $chan]
1315e0ce87aSdan  return ""
1325e0ce87aSdan}
1335e0ce87aSdan
134e264d983Sdan# Write the main loop for the child testfixture processes into file
135e264d983Sdan# tf_main.tcl. The parent (this script) interacts with the child processes
136e264d983Sdan# via a two way pipe. The parent writes a script to the stdin of the child
137e264d983Sdan# process, followed by the word "OVER" on a line of its own. The child
138e264d983Sdan# process evaluates the script and writes the results to stdout, followed
139e264d983Sdan# by an "OVER" of its own.
14047ee386fSdan#
14147ee386fSdanset main_loop_written 0
14247ee386fSdanproc write_main_loop {} {
14347ee386fSdan  if {$::main_loop_written} return
14447ee386fSdan  set wrapper ""
14547ee386fSdan  if {[sqlite3 -has-codec] && [info exists ::do_not_use_codec]==0} {
14647ee386fSdan    set wrapper "
14747ee386fSdan      rename sqlite3 sqlite_orig
14847ee386fSdan      proc sqlite3 {args} {[info body sqlite3]}
14947ee386fSdan    "
15047ee386fSdan  }
15147ee386fSdan
15247ee386fSdan  set fd [open tf_main.tcl w]
15347ee386fSdan  puts $fd [string map [list %WRAPPER% $wrapper] {
15447ee386fSdan    %WRAPPER%
155e264d983Sdan    set script ""
156e264d983Sdan    while {![eof stdin]} {
157e264d983Sdan      flush stdout
158e264d983Sdan      set line [gets stdin]
159e264d983Sdan      if { $line == "OVER" } {
1605e0ce87aSdan        set rc [catch {eval $script} result]
161e91a54e1Sdan        puts [list $rc $result]
162e264d983Sdan        puts OVER
163e264d983Sdan        flush stdout
164e264d983Sdan        set script ""
165e264d983Sdan      } else {
166e264d983Sdan        append script $line
1675e0ce87aSdan        append script "\n"
168e264d983Sdan      }
169e264d983Sdan    }
17047ee386fSdan  }]
17147ee386fSdan  close $fd
17247ee386fSdan  set main_loop_written 1
173e264d983Sdan}
17447ee386fSdan
175