Home
last modified time | relevance | path

Searched refs:stmt (Results 1 – 25 of 68) sorted by relevance

123

/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-api-oo1.js349 return stmt;
413 case 'array': out.cbArg = (stmt)=>stmt.get([]); break;
420 out.cbArg = (stmt)=>stmt; argument
424 out.cbArg = (stmt)=>stmt.get(opt.rowMode);
451 let stmt, rc;
454 if(stmt.step()) rc = stmt.get(getArg);
456 if(stmt) stmt.finalize();
771 let stmt;
1045 if(stmt.step()) rc = stmt.get(0,asType);
1047 if(stmt) stmt.finalize();
[all …]
/sqlite-3.40.0/test/
H A Dbind2.test32 set stmt [sqlite3_prepare db "SELECT ?" -1 tail]
34 sqlite3_step $stmt
35 sqlite3_column_text $stmt 0
37 sqlite3_finalize $stmt
46 sqlite3_bind_value_from_preupdate $stmt 1 old 0
47 sqlite3_step $stmt
48 lappend ::reslist [sqlite3_column_text $stmt 0]
49 sqlite3_reset $stmt
50 sqlite3_bind_value_from_preupdate $stmt 1 new 0
51 sqlite3_step $stmt
[all …]
H A Dchanges2.test24 set ::stmt [sqlite3_prepare_v2 db {
29 list [sqlite3_step $::stmt] [db changes]
33 list [sqlite3_step $::stmt] [db changes]
36 sqlite3_reset $::stmt
47 list [sqlite3_step $::stmt] [db changes]
51 list [sqlite3_step $::stmt] [db changes]
54 sqlite3_finalize $::stmt
64 set ::stmt [sqlite3_prepare_v2 db {
73 list [sqlite3_step $::stmt] [sqlite3_reset $::stmt]
85 list [sqlite3_step $::stmt] [sqlite3_reset $::stmt]
[all …]
H A Dstmt.test24 do_test stmt-1.1 {
38 do_test stmt-1.2 {
41 do_test stmt-1.3 {
49 do_test stmt-1.4 {
56 do_test stmt-1.5 {
60 do_test stmt-1.6.1 {
67 do_test stmt-1.6.2 {
72 do_test stmt-1.7 {
91 filecount stmt-2.4 {
96 do_test stmt-2.5 {
[all …]
H A Dinstrfault.test57 set ::stmt [sqlite3_prepare_v2 db "SELECT instr(?, ?)" -1 dummy]
58 sqlite3_bind_text $::stmt 1 $::HAYSTACK [string length $::HAYSTACK]
59 sqlite3_bind_text $::stmt 2 $::NEEDLE [string length $::NEEDLE]
61 set rc [sqlite3_step $::stmt]
63 sqlite3_column_int $::stmt 0
66 sqlite3_finalize $::stmt
70 set ::stmt [sqlite3_prepare_v2 db "SELECT instr(?, ?)" -1 dummy]
72 sqlite3_bind_blob $::stmt 2 $::NEEDLE [string length $::NEEDLE]
74 set rc [sqlite3_step $::stmt]
76 sqlite3_column_int $::stmt 0
[all …]
H A Dincrcorrupt.test49 set stmt [sqlite3_prepare_v2 db "PRAGMA incremental_vacuum" -1 dummy]
50 sqlite3_step $stmt
54 do_test 1.6 { sqlite3_finalize $stmt } {SQLITE_CORRUPT}
59 set stmt [sqlite3_prepare_v2 db "PRAGMA incremental_vacuum" -1 dummy]
60 sqlite3_step $stmt
72 do_test 1.15 { sqlite3_finalize $stmt } {SQLITE_CORRUPT}
99 set stmt [sqlite3_prepare_v2 db "PRAGMA auto_vacuum = INCREMENTAL" -1 dummy]
100 sqlite3_step $stmt
104 do_test 2.6 { sqlite3_finalize $stmt } {SQLITE_CORRUPT}
110 sqlite3_step $stmt
[all …]
H A Dzeroblob.test306 proc bind_and_run {stmt nZero} {
307 sqlite3_bind_zeroblob64 $stmt 1 $nZero
308 sqlite3_step $stmt
309 set ret [sqlite3_column_int $stmt 0]
310 sqlite3_reset $stmt
315 do_test 12.1 { bind_and_run $stmt 40 } 40
316 do_test 12.2 { bind_and_run $stmt 0 } 0
323 sqlite3_step $stmt
324 set ret [sqlite3_column_int $stmt 0]
325 sqlite3_reset $stmt
[all …]
H A Dcarray01.test25 # Parameter $stmt must be a prepared statement created using
30 # If the optional second argument is true, then the stmt is finalized
33 proc run_stmt {stmt {finalizeFlag 0}} {
35 while {[sqlite3_step $stmt]=="SQLITE_ROW"} {
36 for {set i 0} {$i<[sqlite3_data_count $stmt]} {incr i} {
37 lappend r [sqlite3_column_text $stmt $i]
41 sqlite3_finalize $stmt
43 sqlite3_reset $stmt
H A Dmisc4.test35 set stmt [sqlite3_prepare $DB $sql -1 TAIL]
45 # was rolled back, statement $stmt was marked as expired. Executing it
48 list [sqlite3_step $stmt] [sqlite3_finalize $stmt]
51 set stmt [sqlite3_prepare $DB $sql -1 TAIL]
56 sqlite3_step $stmt
69 sqlite3_reset $stmt
70 sqlite3_step $stmt
73 sqlite3_finalize $stmt
82 set stmt [sqlite3_prepare $DB {CREATE TABLE t3(x);} -1 TAIL]
88 sqlite3_step $stmt
[all …]
H A Dcolumncount.test28 set stmt [sqlite3_prepare_v2 db {$sql} -1 dummy]
29 set res [sqlite3_column_count [set stmt]]
30 while {[sqlite3_step [set stmt]]=="SQLITE_ROW"} {
31 for {set i 0} {[set i] < [sqlite3_data_count [set stmt]]} {incr i} {
32 lappend res [sqlite3_column_text [set stmt] [set i]]
36 set rc [sqlite3_finalize [set stmt]]
H A Dbindxfer.test20 proc sqlite_step {stmt VALS COLS} {
26 set rc [sqlite3_step $stmt]
27 for {set i 0} {$i < [sqlite3_column_count $stmt]} {incr i} {
28 lappend cols [sqlite3_column_name $stmt $i]
30 for {set i 0} {$i < [sqlite3_data_count $stmt]} {incr i} {
31 lappend vals [sqlite3_column_text $stmt $i]
H A Dspeed4p.test110 execsql $stmt
136 speed_trial_tcl speed4p-view1 10000 stmt $script
150 speed_trial_tcl speed4p-table1 10000 stmt $script
164 speed_trial_tcl speed4p-subselect1 10000 stmt $script
175 speed_trial_tcl speed4p-rowid-update 10000 stmt $script
221 speed_trial_tcl speed4p-trigger1 10000 stmt $script
235 speed_trial_tcl speed4p-trigger2 10000 stmt $script
242 speed_trial_tcl speed4p-trigger3 10000 stmt $script
266 speed_trial_tcl speed4p-notrigger1 10000 stmt $script
280 speed_trial_tcl speed4p-notrigger2 10000 stmt $script
[all …]
H A Dbackup5.test38 set stmt [sqlite3_prepare_v2 db2 "SELECT * FROM t2" -1 dummy]
39 sqlite3_step $stmt
51 sqlite3_reset $stmt
58 list [sqlite3_step $stmt] [sqlite3_finalize $stmt]
H A Dspeed4.test103 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
107 execsql $stmt
136 speed_trial speed4-view1 10000 stmt $sql
147 speed_trial speed4-table1 10000 stmt $sql
159 speed_trial speed4-subselect1 10000 stmt $sql
182 speed_trial speed4-trigger1 10000 stmt $sql
190 speed_trial speed4-trigger2 10000 stmt $sql
195 speed_trial speed4-trigger3 10000 stmt $sql
214 speed_trial speed4-notrigger1 10000 stmt $sql
222 speed_trial speed4-notrigger2 10000 stmt $sql
[all …]
H A Dspeed4p.explain106 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
110 execsql $stmt
145 speed_trial_tcl speed4p-view1 10000 stmt $script
160 speed_trial_tcl speed4p-table1 10000 stmt $script
179 speed_trial_tcl speed4p-subselect1 10000 stmt $script
208 speed_trial_tcl speed4p-trigger1 10000 stmt $script
223 speed_trial_tcl speed4p-trigger2 10000 stmt $script
231 speed_trial_tcl speed4p-trigger3 10000 stmt $script
256 speed_trial_tcl speed4p-notrigger1 10000 stmt $script
271 speed_trial_tcl speed4p-notrigger2 10000 stmt $script
[all …]
H A Ddbstatus.test429 set ::stmt [sqlite3_prepare db "SELECT * FROM t1" -1 dummy]
430 sqlite3_step $::stmt
431 sqlite3_step $::stmt
432 sqlite3_step $::stmt
433 sqlite3_reset $::stmt
437 do_test 5.2 { sqlite3_stmt_status $::stmt -1 0 } 0
439 do_test 5.3 { sqlite3_stmt_status $::stmt 0 0 } 0
441 expr [sqlite3_stmt_status $::stmt 99 0]>0
453 do_test 5.5.$tn { expr [sqlite3_stmt_status $::stmt $id 0]>0 } $res
456 sqlite3_finalize $::stmt
H A Dfkey7.test64 set stmt [sqlite3_prepare_v2 db "INSERT INTO cX VALUES(11, ?)" -1]
65 sqlite3_bind_zeroblob $stmt 1 45
66 sqlite3_step $stmt
67 sqlite3_finalize $stmt
H A Dioerr5.test44 set stmt [sqlite3_prepare16 $db $sql -1 {}]
45 sqlite3_step $stmt
46 set rc [sqlite3_finalize $stmt]
52 set stmt [sqlite3_prepare16 $db $sql -1 {}]
53 set rc [sqlite3_finalize $stmt]
H A Derrmsg.test32 set stmt [$prepare db $sql -1 dummy]
34 lappend ret [sqlite3_step $stmt]
36 lappend ret [sqlite3_finalize $stmt]
H A Dpragma4.test19 set ::stmt 0
20 set ::stmt [sqlite3_prepare_v2 db $sql -1 dummy]
21 uplevel [list do_test $tn { sqlite3_column_count $::stmt } $nCol]
22 sqlite3_finalize $::stmt
H A Dpg_common.tcl46 foreach stmt $lSql {
47 set res [pg_exec $::db $stmt]
H A Dtrace3.test130 set stmt [lindex [lindex $::stmtlist(record) 0] 0]
132 list $stmt [expr {$ns >= 0 && $ns <= 9999999}]; # less than 0.010 seconds
140 set stmt [lindex [lindex $::stmtlist(record) 0] 0]
142 list $stmt [expr {$ns >= 0 && $ns <= 9999999}]; # less than 0.010 seconds
/sqlite-3.40.0/tool/
H A Dvdbe_profile.tcl18 set stmt {}
24 set stmt [lindex $line 1]
25 if {[info exists cnt($stmt)]} {
26 incr cnt($stmt)
29 set cnt($stmt) 1
30 set sql($stmt) {}
32 lappend allstmt $stmt
38 append sql($stmt) [string range $line 3 end]\n
65 foreach stmt $allstmt {
67 puts [string trim $sql($stmt)]
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree8.test83 set stmt [sqlite3_prepare db "SELECT * FROM t1 WHERE id = $row" -1 tail]
84 sqlite3_step $stmt
85 lappend res_list [sqlite3_column_int $stmt 0]
86 lappend stmt_list $stmt
92 foreach stmt $stmt_list { sqlite3_finalize $stmt }
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5columnsize.test28 foreach {tn outcome stmt} {
43 do_catchsql_test 1.$tn.1 $stmt {1 {malformed columnsize=... directive}}
45 do_execsql_test 1.$tn.2 $stmt

123