xref: /sqlite-3.40.0/test/lock_common.tcl (revision 363fc9e7)
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 {
1925568441Sdan    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
584edc6bf3Sdan    catch { code2 { db2 close } }
594edc6bf3Sdan    catch { 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#
89*363fc9e7Sdanproc testfixture {chan cmd args} {
90*363fc9e7Sdan
91*363fc9e7Sdan  if {[llength $args] == 0} {
92*363fc9e7Sdan    fconfigure $chan -blocking 1
93e264d983Sdan    puts $chan $cmd
94e264d983Sdan    puts $chan OVER
95*363fc9e7Sdan
96e264d983Sdan    set r ""
97e264d983Sdan    while { 1 } {
98e264d983Sdan      set line [gets $chan]
99e264d983Sdan      if { $line == "OVER" } {
100e91a54e1Sdan        set res [lindex $r 1]
101e91a54e1Sdan        if { [lindex $r 0] } { error $res }
102e91a54e1Sdan        return $res
103e264d983Sdan      }
104e264d983Sdan      if {[eof $chan]} {
105e264d983Sdan        return "ERROR: Child process hung up"
106e264d983Sdan      }
107e264d983Sdan      append r $line
108e264d983Sdan    }
109*363fc9e7Sdan    return $r
110*363fc9e7Sdan  } else {
111*363fc9e7Sdan    set ::tfnb($chan) ""
112*363fc9e7Sdan    fconfigure $chan -blocking 0 -buffering none
113*363fc9e7Sdan    puts $chan $cmd
114*363fc9e7Sdan    puts $chan OVER
115*363fc9e7Sdan    fileevent $chan readable [list testfixture_script_cb $chan [lindex $args 0]]
116*363fc9e7Sdan    return ""
117*363fc9e7Sdan  }
118*363fc9e7Sdan}
119*363fc9e7Sdan
120*363fc9e7Sdanproc testfixture_script_cb {chan script} {
121*363fc9e7Sdan  if {[eof $chan]} {
122*363fc9e7Sdan    append ::tfnb($chan) "ERROR: Child process hung up"
123*363fc9e7Sdan    set line "OVER"
124*363fc9e7Sdan  } else {
125*363fc9e7Sdan    set line [gets $chan]
126*363fc9e7Sdan  }
127*363fc9e7Sdan
128*363fc9e7Sdan  if { $line == "OVER" } {
129*363fc9e7Sdan    uplevel #0 $script [list [lindex $::tfnb($chan) 1]]
130*363fc9e7Sdan    unset ::tfnb($chan)
131*363fc9e7Sdan    fileevent $chan readable ""
132*363fc9e7Sdan  } else {
133*363fc9e7Sdan    append ::tfnb($chan) $line
134*363fc9e7Sdan  }
135e264d983Sdan}
136e264d983Sdan
1375e0ce87aSdanproc testfixture_nb_cb {varname chan} {
138f9b76710Sdan  if {[eof $chan]} {
139f9b76710Sdan    append ::tfnb($chan) "ERROR: Child process hung up"
140f9b76710Sdan    set line "OVER"
141f9b76710Sdan  } else {
1425e0ce87aSdan    set line [gets $chan]
143f9b76710Sdan  }
144f9b76710Sdan
1455e0ce87aSdan  if { $line == "OVER" } {
146e91a54e1Sdan    set $varname [lindex $::tfnb($chan) 1]
1475e0ce87aSdan    unset ::tfnb($chan)
1485e0ce87aSdan    close $chan
1495e0ce87aSdan  } else {
1505e0ce87aSdan    append ::tfnb($chan) $line
1515e0ce87aSdan  }
1525e0ce87aSdan}
1535e0ce87aSdan
1545e0ce87aSdanproc testfixture_nb {varname cmd} {
1555e0ce87aSdan  set chan [launch_testfixture]
1565e0ce87aSdan  set ::tfnb($chan) ""
1575e0ce87aSdan  fconfigure $chan -blocking 0 -buffering none
1585e0ce87aSdan  puts $chan $cmd
1595e0ce87aSdan  puts $chan OVER
1605e0ce87aSdan  fileevent $chan readable [list testfixture_nb_cb $varname $chan]
1615e0ce87aSdan  return ""
1625e0ce87aSdan}
1635e0ce87aSdan
164e264d983Sdan# Write the main loop for the child testfixture processes into file
165e264d983Sdan# tf_main.tcl. The parent (this script) interacts with the child processes
166e264d983Sdan# via a two way pipe. The parent writes a script to the stdin of the child
167e264d983Sdan# process, followed by the word "OVER" on a line of its own. The child
168e264d983Sdan# process evaluates the script and writes the results to stdout, followed
169e264d983Sdan# by an "OVER" of its own.
17047ee386fSdan#
17147ee386fSdanset main_loop_written 0
17247ee386fSdanproc write_main_loop {} {
17347ee386fSdan  if {$::main_loop_written} return
17447ee386fSdan  set wrapper ""
17547ee386fSdan  if {[sqlite3 -has-codec] && [info exists ::do_not_use_codec]==0} {
17647ee386fSdan    set wrapper "
17747ee386fSdan      rename sqlite3 sqlite_orig
17847ee386fSdan      proc sqlite3 {args} {[info body sqlite3]}
17947ee386fSdan    "
18047ee386fSdan  }
18147ee386fSdan
18247ee386fSdan  set fd [open tf_main.tcl w]
18347ee386fSdan  puts $fd [string map [list %WRAPPER% $wrapper] {
18447ee386fSdan    %WRAPPER%
185e264d983Sdan    set script ""
186e264d983Sdan    while {![eof stdin]} {
187e264d983Sdan      flush stdout
188e264d983Sdan      set line [gets stdin]
189e264d983Sdan      if { $line == "OVER" } {
1905e0ce87aSdan        set rc [catch {eval $script} result]
191e91a54e1Sdan        puts [list $rc $result]
192e264d983Sdan        puts OVER
193e264d983Sdan        flush stdout
194e264d983Sdan        set script ""
195e264d983Sdan      } else {
196e264d983Sdan        append script $line
1975e0ce87aSdan        append script "\n"
198e264d983Sdan      }
199e264d983Sdan    }
20047ee386fSdan  }]
20147ee386fSdan  close $fd
20247ee386fSdan  set main_loop_written 1
203e264d983Sdan}
20447ee386fSdan
205