Imported Upstream version 3.05

[sven/mysqltcl.git] / tests / regression.tcl

diff --git a/tests/regression.tcl b/tests/regression.tcl
new file mode 100755 (executable)
index 0000000..0b29bca
--- /dev/null
+++ b/tests/regression.tcl
@@ -0,0 +1,33 @@
+#!/usr/bin/tcl
+
+if {[file exists libload.tcl]} {
+    source libload.tcl
+} else {
+    source [file join [file dirname [info script]] libload.tcl]
+}
+
+
+puts "please observe memory consumption per top (Program break after reach 2000)"
+
+set c [mysqlconnect -u root -db uni]
+set i 0
+set p 0
+while 1 {
+    set a [mysqlsel $c "select * from Student" -list]
+    set d [string trim " $c "]
+    mysqlsel $d {select * from Student}
+    while {[set row [mysqlnext $d]]!=""} {}
+    unset d
+    set q [mysqlquery $c {select * from Student}]
+    while {[set row [mysqlnext $q]]!=""} {}
+    mysqlendquery $q
+    mysqlsel $c {select MatrNr,Name,Semester from Student}
+    mysqlmap $c {MatrNr Name Semester} {
+       set all [list $MatrNr $Name $Semester]
+    }
+    if {$i>100} {puts "loop [incr p]"; set i 0}
+    incr i
+    if {$p>=2000} break
+}
+mysqlclose $c
+unset c