xref: /sqlite-3.40.0/test/lock_common.tcl (revision 2969a587)
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 {
19a4a9095eSdan    set ::code2_chan [launch_testfixture]
20a4a9095eSdan    set ::code3_chan [launch_testfixture]
21a4a9095eSdan    proc code2 {tcl} { testfixture $::code2_chan $tcl }
22a4a9095eSdan    proc code3 {tcl} { testfixture $::code3_chan $tcl }
23a4a9095eSdan    set tn 1
24a4a9095eSdan  } {
25a4a9095eSdan    proc code2 {tcl} { uplevel #0 $tcl }
26a4a9095eSdan    proc code3 {tcl} { uplevel #0 $tcl }
27a4a9095eSdan    set tn 2
28a4a9095eSdan  }] {
29a4a9095eSdan    faultsim_delete_and_reopen
305653e4daSdan
315653e4daSdan    proc code1 {tcl} { uplevel #0 $tcl }
32a4a9095eSdan
33a4a9095eSdan    # Open connections [db2] and [db3]. Depending on which iteration this
34a4a9095eSdan    # is, the connections may be created in this interpreter, or in
35a4a9095eSdan    # interpreters running in other OS processes. As such, the [db2] and [db3]
36a4a9095eSdan    # commands should only be accessed within [code2] and [code3] blocks,
37a4a9095eSdan    # respectively.
38a4a9095eSdan    #
39a4a9095eSdan    eval $code
40a4a9095eSdan    code2 { sqlite3 db2 test.db }
41a4a9095eSdan    code3 { sqlite3 db3 test.db }
42a4a9095eSdan
43a4a9095eSdan    # Shorthand commands. Execute SQL using database connection [db2] or
44a4a9095eSdan    # [db3]. Return the results.
45a4a9095eSdan    #
46a4a9095eSdan    proc sql1 {sql} { db eval $sql }
47a4a9095eSdan    proc sql2 {sql} { code2 [list db2 eval $sql] }
48a4a9095eSdan    proc sql3 {sql} { code3 [list db3 eval $sql] }
49a4a9095eSdan
50a4a9095eSdan    proc csql1 {sql} { list [catch { sql1 $sql } msg] $msg }
51a4a9095eSdan    proc csql2 {sql} { list [catch { sql2 $sql } msg] $msg }
52a4a9095eSdan    proc csql3 {sql} { list [catch { sql3 $sql } msg] $msg }
53a4a9095eSdan
54a4a9095eSdan    uplevel set $varname $tn
55a4a9095eSdan    uplevel $script
56a4a9095eSdan
57a4a9095eSdan    code2 { db2 close }
58a4a9095eSdan    code3 { db3 close }
59a4a9095eSdan    catch { close $::code2_chan }
60a4a9095eSdan    catch { close $::code3_chan }
61*2969a587Sdan    catch { db close }
62a4a9095eSdan  }
63a4a9095eSdan}
64a4a9095eSdan
65e264d983Sdan# Launch another testfixture process to be controlled by this one. A
66e264d983Sdan# channel name is returned that may be passed as the first argument to proc
67e264d983Sdan# 'testfixture' to execute a command. The child testfixture process is shut
68e264d983Sdan# down by closing the channel.
698311c47dSdanproc launch_testfixture {{prg ""}} {
7047ee386fSdan  write_main_loop
714f05e38fSdan  if {$prg eq ""} { set prg [info nameofexec] }
724f05e38fSdan  if {$prg eq ""} { set prg testfixture }
733d579059Sdan  if {[file tail $prg]==$prg} { set prg [file join . $prg] }
74e264d983Sdan  set chan [open "|$prg tf_main.tcl" r+]
75e264d983Sdan  fconfigure $chan -buffering line
768311c47dSdan  set rc [catch {
7731f98fc8Sdan    testfixture $chan "sqlite3_test_control_pending_byte $::sqlite_pending_byte"
788311c47dSdan  }]
798311c47dSdan  if {$rc} {
808311c47dSdan    testfixture $chan "set ::sqlite_pending_byte $::sqlite_pending_byte"
818311c47dSdan  }
82e264d983Sdan  return $chan
83e264d983Sdan}
84e264d983Sdan
85e264d983Sdan# Execute a command in a child testfixture process, connected by two-way
86e264d983Sdan# channel $chan. Return the result of the command, or an error message.
87e91a54e1Sdan#
88e264d983Sdanproc testfixture {chan cmd} {
89e264d983Sdan  puts $chan $cmd
90e264d983Sdan  puts $chan OVER
91e264d983Sdan  set r ""
92e264d983Sdan  while { 1 } {
93e264d983Sdan    set line [gets $chan]
94e264d983Sdan    if { $line == "OVER" } {
95e91a54e1Sdan      set res [lindex $r 1]
96e91a54e1Sdan      if { [lindex $r 0] } { error $res }
97e91a54e1Sdan      return $res
98e264d983Sdan    }
99e264d983Sdan    if {[eof $chan]} {
100e264d983Sdan      return "ERROR: Child process hung up"
101e264d983Sdan    }
102e264d983Sdan    append r $line
103e264d983Sdan  }
104e264d983Sdan}
105e264d983Sdan
1065e0ce87aSdanproc testfixture_nb_cb {varname chan} {
107f9b76710Sdan  if {[eof $chan]} {
108f9b76710Sdan    append ::tfnb($chan) "ERROR: Child process hung up"
109f9b76710Sdan    set line "OVER"
110f9b76710Sdan  } else {
1115e0ce87aSdan    set line [gets $chan]
112f9b76710Sdan  }
113f9b76710Sdan
1145e0ce87aSdan  if { $line == "OVER" } {
115e91a54e1Sdan    set $varname [lindex $::tfnb($chan) 1]
1165e0ce87aSdan    unset ::tfnb($chan)
1175e0ce87aSdan    close $chan
1185e0ce87aSdan  } else {
1195e0ce87aSdan    append ::tfnb($chan) $line
1205e0ce87aSdan  }
1215e0ce87aSdan}
1225e0ce87aSdan
1235e0ce87aSdanproc testfixture_nb {varname cmd} {
1245e0ce87aSdan  set chan [launch_testfixture]
1255e0ce87aSdan  set ::tfnb($chan) ""
1265e0ce87aSdan  fconfigure $chan -blocking 0 -buffering none
1275e0ce87aSdan  puts $chan $cmd
1285e0ce87aSdan  puts $chan OVER
1295e0ce87aSdan  fileevent $chan readable [list testfixture_nb_cb $varname $chan]
1305e0ce87aSdan  return ""
1315e0ce87aSdan}
1325e0ce87aSdan
133e264d983Sdan# Write the main loop for the child testfixture processes into file
134e264d983Sdan# tf_main.tcl. The parent (this script) interacts with the child processes
135e264d983Sdan# via a two way pipe. The parent writes a script to the stdin of the child
136e264d983Sdan# process, followed by the word "OVER" on a line of its own. The child
137e264d983Sdan# process evaluates the script and writes the results to stdout, followed
138e264d983Sdan# by an "OVER" of its own.
13947ee386fSdan#
14047ee386fSdanset main_loop_written 0
14147ee386fSdanproc write_main_loop {} {
14247ee386fSdan  if {$::main_loop_written} return
14347ee386fSdan  set wrapper ""
14447ee386fSdan  if {[sqlite3 -has-codec] && [info exists ::do_not_use_codec]==0} {
14547ee386fSdan    set wrapper "
14647ee386fSdan      rename sqlite3 sqlite_orig
14747ee386fSdan      proc sqlite3 {args} {[info body sqlite3]}
14847ee386fSdan    "
14947ee386fSdan  }
15047ee386fSdan
15147ee386fSdan  set fd [open tf_main.tcl w]
15247ee386fSdan  puts $fd [string map [list %WRAPPER% $wrapper] {
15347ee386fSdan    %WRAPPER%
154e264d983Sdan    set script ""
155e264d983Sdan    while {![eof stdin]} {
156e264d983Sdan      flush stdout
157e264d983Sdan      set line [gets stdin]
158e264d983Sdan      if { $line == "OVER" } {
1595e0ce87aSdan        set rc [catch {eval $script} result]
160e91a54e1Sdan        puts [list $rc $result]
161e264d983Sdan        puts OVER
162e264d983Sdan        flush stdout
163e264d983Sdan        set script ""
164e264d983Sdan      } else {
165e264d983Sdan        append script $line
1665e0ce87aSdan        append script "\n"
167e264d983Sdan      }
168e264d983Sdan    }
16947ee386fSdan  }]
17047ee386fSdan  close $fd
17147ee386fSdan  set main_loop_written 1
172e264d983Sdan}
17347ee386fSdan
174