# 2011 Jan 21 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. # # This file implements tests for the "sqlite3_trace()" API. Specifically, # it tests the special handling of nested SQL statements (those executed # by virtual table or user function callbacks). These statements are treated # differently in two respects: # # 1. Each line of the statement is prefixed with "-- " to turn it into # an SQL comment. # # 2. Parameter expansion is not performed. # set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !trace { finish_test ; return } set ::testprefix trace2 proc sql {zSql} { db one $zSql } proc trace {zSql} { lappend ::trace $zSql } db func sql sql db trace trace proc do_trace_test {tn sql expected} { # Test that the list of string passed to the trace callback when $sql # is executed is equivalent to the list of strings in $expected. # set ::trace [list] execsql $sql uplevel do_test $tn [list {set ::trace}] [list [list {*}$expected]] } proc do_trace_select_test {tn sql expected} { uplevel [list do_trace_test ${tn}.a $sql $expected] # Now execute each SQL statement passed to the trace callback in the # block above. Check that this causes the same set of strings to be # passed to the trace callback again. i.e. that executing the output # of the trace callback is equivalent to the SQL script in $sql. # set sqllist $::trace set ::trace [list] foreach item $sqllist { execsql $item } uplevel do_test $tn.b [list {set ::trace}] [list $sqllist] } do_trace_select_test 1.1 { SELECT 1, 2, 3; } { "SELECT 1, 2, 3;" } do_trace_select_test 1.2 { SELECT sql('SELECT 1, 2, 3'); } { "SELECT sql('SELECT 1, 2, 3');" "-- SELECT 1, 2, 3" } do_trace_select_test 1.3 { SELECT sql('SELECT 1, 2, 3' ); } { "SELECT sql('SELECT 1, 2, 3' );" "-- SELECT 1, -- 2, -- 3" } do_trace_select_test 1.4 { SELECT sql('SELECT 1, 3' ); } { "SELECT sql('SELECT 1, 3' );" "-- SELECT 1, -- -- -- 3" } do_trace_select_test 1.5 { SELECT $var, sql('SELECT 1, $var, 3' ); } { "SELECT NULL, sql('SELECT 1, $var, 3' );" "-- SELECT 1, -- $var, -- 3" } ifcapable fts3 { do_execsql_test 2.1 { CREATE VIRTUAL TABLE x1 USING fts4; INSERT INTO x1 VALUES('Cloudy, with a high near 16'); INSERT INTO x1 VALUES('Wind chill values as low as -13'); } do_trace_test 2.2 { INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph'); } { "INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');" "-- INSERT INTO 'main'.'x1_content' VALUES(?,(?))" "-- REPLACE INTO 'main'.'x1_docsize' VALUES(?,?)" "-- SELECT value FROM 'main'.'x1_stat' WHERE id=?" "-- REPLACE INTO 'main'.'x1_stat' VALUES(?,?)" "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1" "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)" "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)" } do_trace_test 2.3 { INSERT INTO x1(x1) VALUES('optimize'); } { "INSERT INTO x1(x1) VALUES('optimize');" "-- SELECT DISTINCT level / (1024 * ?) FROM 'main'.'x1_segdir'" "-- SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?ORDER BY level DESC, idx ASC" "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?" "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)" "-- DELETE FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?" "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)" } } finish_test