1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sqlite3api/TEST/TclScript/trace.test	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,169 @@
     1.4 +# 2004 Jun 29
     1.5 +#
     1.6 +# The author disclaims copyright to this source code.  In place of
     1.7 +# a legal notice, here is a blessing:
     1.8 +#
     1.9 +#    May you do good and not evil.
    1.10 +#    May you find forgiveness for yourself and forgive others.
    1.11 +#    May you share freely, never taking more than you give.
    1.12 +#
    1.13 +#***********************************************************************
    1.14 +# This file implements regression tests for SQLite library.
    1.15 +#
    1.16 +# This file implements tests for the "sqlite3_trace()" API.
    1.17 +#
    1.18 +# $Id: trace.test,v 1.7 2008/01/12 21:35:57 drh Exp $
    1.19 +
    1.20 +set testdir [file dirname $argv0]
    1.21 +source $testdir/tester.tcl
    1.22 +
    1.23 +ifcapable !trace {
    1.24 +  finish_test
    1.25 +  return
    1.26 +}
    1.27 +
    1.28 +set ::stmtlist {}
    1.29 +do_test trace-1.1 {
    1.30 +  set rc [catch {db trace 1 2 3} msg]
    1.31 +  lappend rc $msg
    1.32 +} {1 {wrong # args: should be "db trace ?CALLBACK?"}}
    1.33 +proc trace_proc cmd {
    1.34 +  lappend ::stmtlist [string trim $cmd]
    1.35 +}
    1.36 +do_test trace-1.2 {
    1.37 +  db trace trace_proc
    1.38 +  db trace
    1.39 +} {trace_proc}
    1.40 +do_test trace-1.3 {
    1.41 +  execsql {
    1.42 +    CREATE TABLE t1(a,b);
    1.43 +    INSERT INTO t1 VALUES(1,2);
    1.44 +    SELECT * FROM t1;
    1.45 +  }
    1.46 +} {1 2}
    1.47 +do_test trace-1.4 {
    1.48 +  set ::stmtlist
    1.49 +} {{CREATE TABLE t1(a,b);} {INSERT INTO t1 VALUES(1,2);} {SELECT * FROM t1;}}
    1.50 +do_test trace-1.5 {
    1.51 +  db trace {}
    1.52 +  db trace
    1.53 +} {}
    1.54 +
    1.55 +# If we prepare a statement and execute it multiple times, the trace
    1.56 +# happens on each execution.
    1.57 +#
    1.58 +db close
    1.59 +sqlite3 db test.db; set DB [sqlite3_connection_pointer db]
    1.60 +do_test trace-2.1 {
    1.61 +  set STMT [sqlite3_prepare $DB {INSERT INTO t1 VALUES(2,3)} -1 TAIL]
    1.62 +  db trace trace_proc
    1.63 +  proc trace_proc sql {
    1.64 +    global TRACE_OUT
    1.65 +    set TRACE_OUT $sql
    1.66 +  }
    1.67 +  set TRACE_OUT {}
    1.68 +  sqlite3_step $STMT
    1.69 +  set TRACE_OUT
    1.70 +} {INSERT INTO t1 VALUES(2,3)}
    1.71 +do_test trace-2.2 {
    1.72 +  set TRACE_OUT {}
    1.73 +  sqlite3_reset $STMT
    1.74 +  set TRACE_OUT 
    1.75 +} {}
    1.76 +do_test trace-2.3 {
    1.77 +  sqlite3_step $STMT
    1.78 +  set TRACE_OUT
    1.79 +} {INSERT INTO t1 VALUES(2,3)}
    1.80 +do_test trace-2.4 {
    1.81 +  execsql {SELECT * FROM t1}
    1.82 +} {1 2 2 3 2 3}
    1.83 +do_test trace-2.5 {
    1.84 +  set TRACE_OUT
    1.85 +} {SELECT * FROM t1}
    1.86 +catch {sqlite3_finalize $STMT}
    1.87 +
    1.88 +# Similar tests, but this time for profiling.
    1.89 +# 
    1.90 +do_test trace-3.1 {
    1.91 +  set rc [catch {db profile 1 2 3} msg]
    1.92 +  lappend rc $msg
    1.93 +} {1 {wrong # args: should be "db profile ?CALLBACK?"}}
    1.94 +set ::stmtlist {}
    1.95 +proc profile_proc {cmd tm} {
    1.96 +  lappend ::stmtlist [string trim $cmd]
    1.97 +}
    1.98 +do_test trace-3.2 {
    1.99 +  db trace {}
   1.100 +  db profile profile_proc
   1.101 +  db profile
   1.102 +} {profile_proc}
   1.103 +do_test trace-3.3 {
   1.104 +  execsql {
   1.105 +    CREATE TABLE t2(a,b);
   1.106 +    INSERT INTO t2 VALUES(1,2);
   1.107 +    SELECT * FROM t2;
   1.108 +  }
   1.109 +} {1 2}
   1.110 +do_test trace-3.4 {
   1.111 +  set ::stmtlist
   1.112 +} {{CREATE TABLE t2(a,b);} {INSERT INTO t2 VALUES(1,2);} {SELECT * FROM t2;}}
   1.113 +do_test trace-3.5 {
   1.114 +  db profile {}
   1.115 +  db profile
   1.116 +} {}
   1.117 +
   1.118 +# If we prepare a statement and execute it multiple times, the profile
   1.119 +# happens on each execution.
   1.120 +#
   1.121 +db close
   1.122 +sqlite3 db test.db; set DB [sqlite3_connection_pointer db]
   1.123 +do_test trace-4.1 {
   1.124 +  set STMT [sqlite3_prepare $DB {INSERT INTO t2 VALUES(2,3)} -1 TAIL]
   1.125 +  db trace trace_proc
   1.126 +  proc profile_proc {sql tm} {
   1.127 +    global TRACE_OUT
   1.128 +    set TRACE_OUT $sql
   1.129 +  }
   1.130 +  set TRACE_OUT {}
   1.131 +  sqlite3_step $STMT
   1.132 +  set TRACE_OUT
   1.133 +} {INSERT INTO t2 VALUES(2,3)}
   1.134 +do_test trace-4.2 {
   1.135 +  set TRACE_OUT {}
   1.136 +  sqlite3_reset $STMT
   1.137 +  set TRACE_OUT 
   1.138 +} {}
   1.139 +do_test trace-4.3 {
   1.140 +  sqlite3_step $STMT
   1.141 +  set TRACE_OUT
   1.142 +} {INSERT INTO t2 VALUES(2,3)}
   1.143 +do_test trace-4.4 {
   1.144 +  execsql {SELECT * FROM t1}
   1.145 +} {1 2 2 3 2 3}
   1.146 +do_test trace-4.5 {
   1.147 +  set TRACE_OUT
   1.148 +} {SELECT * FROM t1}
   1.149 +catch {sqlite3_finalize $STMT}
   1.150 +
   1.151 +# Trigger tracing.
   1.152 +#
   1.153 +do_test trace-5.1 {
   1.154 +  db eval {
   1.155 +    CREATE TRIGGER r1t1 AFTER UPDATE ON t1 BEGIN
   1.156 +      UPDATE t2 SET a=new.a WHERE rowid=new.rowid;
   1.157 +    END;
   1.158 +    CREATE TRIGGER r1t2 AFTER UPDATE ON t2 BEGIN
   1.159 +      SELECT 'hello';
   1.160 +    END;
   1.161 +  }
   1.162 +  set TRACE_OUT {}
   1.163 +  proc trace_proc cmd {
   1.164 +    lappend ::TRACE_OUT [string trim $cmd]
   1.165 +  }
   1.166 +  db eval {
   1.167 +    UPDATE t1 SET a=a+1;
   1.168 +  }
   1.169 +  set TRACE_OUT
   1.170 +} {{UPDATE t1 SET a=a+1;} {-- TRIGGER r1t1} {-- TRIGGER r1t2} {-- TRIGGER r1t1} {-- TRIGGER r1t2} {-- TRIGGER r1t1} {-- TRIGGER r1t2}}
   1.171 +
   1.172 +finish_test