Lines Matching refs:set
17 set testdir [file dirname $argv0]
19 set ::testprefix capi3
29 set r [encoding convertto unicode $str]
42 set str [binary format \c* [lrange $vals 0 end-2]]
45 set r [encoding convertfrom unicode $str]
60 set DB [sqlite3_connection_pointer db]
66 set STMT [sqlite3_prepare $DB {SELECT name FROM sqlite_master} -1 TAIL]
68 set TAIL
80 set sql {SELECT name FROM sqlite_master;SELECT 10}
81 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
83 set TAIL
86 set sql {SELECT name FROM sqlite_master;SELECT 10}
87 set STMT [sqlite3_prepare $DB $sql [string length $sql] TAIL]
89 set TAIL
92 set sql {SELECT name FROM sqlite_master;SELECT 10}
93 set STMT [sqlite3_prepare $DB $sql [expr [string length $sql]+1] TAIL]
95 set TAIL
99 set sql {SELECT namex FROM sqlite_master}
101 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
116 set sql16 [utf16 {SELECT name FROM sqlite_master}]
117 set STMT [sqlite3_prepare16 $DB $sql16 -1 ::TAIL]
122 set sql [utf16 {SELECT name FROM sqlite_master;SELECT 10}]
123 set STMT [sqlite3_prepare16 $DB $sql -1 TAIL]
128 set sql [utf16 {SELECT namex FROM sqlite_master}]
130 set STMT [sqlite3_prepare16 $DB $sql -1]
146 set sql16 [utf16 {PRAGMA table_info("TableName"); --excess text}]
147 set STMT [sqlite3_prepare16 $DB $sql16 -1]
164 set db2 [sqlite3_open test.db {}]
173 set db2 [sqlite3_open /bogus/path/test.db {}]
175 set ::capi3_errno [sqlite3_system_errno $db2]
199 set db2 [sqlite3_open]
211 set db2 [sqlite3_open16 [utf16 test.db] {}]
220 set db2 [sqlite3_open16 [utf16 /bogus/path/test.db] {}]
247 # set STMT [sqlite3_prepare "SELECT 1, 2, 2;" -1 DUMMY]
255 set ::idxlist [list]
256 set ::numcols [sqlite3_column_count $STMT]
257 for {set i 0} {$i < $::numcols} {incr i} {lappend ::idxlist $i}
261 set cnamelist [list]
263 set cnamelist
269 set cnamelist [list]
273 set cnamelist
279 set cnamelist [list]
281 set cnamelist
287 set cnamelist [list]
291 set cnamelist
297 set cnamelist [list]
299 set cnamelist
305 set cnamelist [list]
309 set cnamelist
346 # set STMT [sqlite3_prepare "SELECT 1, 2, 2;" -1 DUMMY]
356 set ::idxlist [list]
357 set ::numcols [sqlite3_column_count $STMT]
358 for {set i 0} {$i < $::numcols} {incr i} {lappend ::idxlist $i}
362 set cnamelist [list]
366 set cnamelist
372 set cnamelist [list]
376 set cnamelist
382 set cnamelist [list]
386 set cnamelist
392 set cnamelist [list]
396 set cnamelist
402 set cnamelist [list]
406 set cnamelist
412 set cnamelist [list]
416 set cnamelist
440 # set STMT [sqlite3_prepare "SELECT 'hello', 1.1, NULL" -1 DUMMY]
449 set ::idxlist [list]
450 set numcols [sqlite3_data_count $STMT]
451 for {set i 0} {$i < $numcols} {incr i} {lappend ::idxlist $i}
455 set types [list]
457 set x [sqlite3_column_type $STMT $i]
462 set types ERROR
468 set types
474 set ints [list]
476 set ints
480 set lens [list]
485 set bytes [list]
486 set lens [list]
490 set bytes
495 set lens [list]
500 set bytes [list]
501 set lens [list]
505 set bytes
511 set utf8 [list]
513 set utf8
518 set utf8 [list]
520 set utf8
525 set utf8 [list]
527 set utf8
533 set utf8 [list]
535 set utf8
541 set ints [list]
543 set ints
548 set utf8 [list]
550 set utf8
555 set utf8 [list]
557 set utf8
562 set types [list]
564 set types
589 set sql "SELECT * FROM t1"
590 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
629 set sql "SELECT a, sum(b), max(c) FROM t1 GROUP BY a"
630 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
641 set sql "SELECT a AS x, sum(b) AS y, max(c) AS z FROM t1 AS m GROUP BY x"
642 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
653 # was not being set correctly, due to changes in check-in
659 set STMT [sqlite3_prepare $DB {SELECT :a, :b} -1 TAIL]
665 set ::ENC [execsql {pragma encoding}]
670 set DB [sqlite3_connection_pointer db]
672 set sql {SELECT a FROM t1 order by rowid}
673 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
705 set schemacookie [hexio_get_int [hexio_read test.db 40 4]]
784 set code2english [list \
808 set test_number 1
818 set DB [sqlite3_connection_pointer db]
836 set DB [sqlite3_connection_pointer db]
858 set DB [sqlite3_connection_pointer db]
872 set STMT [sqlite3_prepare $DB "SELECT func(b, a) FROM t1" -1 TAIL]
921 set STMT [sqlite3_prepare $DB "SELECT a FROM t2" -1 TAIL]
987 set STMT [sqlite3_prepare $DB "SELECT a FROM t1" -1 TAIL]
1016 set STMT [sqlite3_prepare $DB "SELECT a FROM t2" -1 TAIL]
1062 set STMT [sqlite3_prepare $DB "INSERT INTO t1 VALUES(?, ?)" -1 TAIL]
1085 set ms [sqlite3_sleep 80]
1094 set rc [catch {sqlite3_bind_text 0 1 hello 5} msg]
1102 set sql {SELECT * FROM t2}
1103 set nbytes [string length $sql]
1105 set STMT [sqlite3_prepare $DB $sql $nbytes TAIL]
1118 set sql {SELECT 1234567890}
1119 set STMT [sqlite3_prepare $DB $sql 8 TAIL]
1121 set v1 [sqlite3_column_int $STMT 0]
1123 set v1
1127 set sql {SELECT 1234567890}
1128 set STMT [sqlite3_prepare $DB $sql 9 TAIL]
1130 set v1 [sqlite3_column_int $STMT 0]
1132 set v1
1136 set sql {SELECT 1234567890}
1137 set STMT [sqlite3_prepare $DB $sql 12 TAIL]
1139 set v1 [sqlite3_column_int $STMT 0]
1141 set v1
1145 set sql {SELECT 12.34567890}
1146 set STMT [sqlite3_prepare $DB $sql 12 TAIL]
1148 set v1 [sqlite3_column_double $STMT 0]
1150 set v1
1154 set sql {SELECT 12.34567890}
1155 set STMT [sqlite3_prepare $DB $sql 14 TAIL]
1157 set v1 [sqlite3_column_double $STMT 0]
1159 set v1
1168 set sql {DROP TABLE IF EXISTS t3}
1169 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
1174 set sql {CREATE TABLE IF NOT EXISTS t1(x,y)}
1175 set STMT [sqlite3_prepare $DB $sql -1 TAIL]
1183 set STMT [sqlite3_prepare $DB {} -1 TAIL]
1188 set STMT [sqlite3_prepare $DB {;} -1 TAIL]
1197 set STMT [sqlite3_prepare $DB {SELECT * FROM t2} -1 TAIL]
1214 set STMT [sqlite3_prepare db {SELECT * FROM t2} -1 TAIL]
1256 set stmt [sqlite3_prepare db "SELECT * FROM t4" -1 dummy]