Lines Matching refs:test
15 # $Id: shell5.test,v 1.7 2009/07/17 16:54:48 shaneh Exp $
26 forcedelete test.db test.db-journal test.db-wal
34 catchcmd "test.db" ".import"
37 catchcmd "test.db" ".import FOO"
41 catchcmd "test.db" ".import FOO BAR BAD"
46 catchcmd "test.db" ".separator"
49 catchcmd "test.db" ".separator ONE"
52 catchcmd "test.db" ".separator ONE TWO"
56 catchcmd "test.db" ".separator ONE TWO THREE"
61 set res [catchcmd "test.db" ".show"]
67 set res [catchcmd "test.db" ".show"]
74 set res [catchcmd "test.db" {.separator ,
82 set res [catchcmd "test.db" {CREATE TABLE t1(a, b);
91 set res [catchcmd ":memory:" {ATTACH 'test.db' AS test;
92 .import -schema test shell5.csv t1
93 SELECT COUNT(*) FROM test.t1;}]
101 set res [catchcmd ":memory:" {ATTACH 'test.db' AS test;
102 .import -schema test shell5.csv t1}]
110 set res [catchcmd ":memory:" {ATTACH 'test.db' AS test;
111 .import --schema test shell5.csv t1}]
119 set res [catchcmd "test.db" {DELETE FROM t1;
132 set res [catchcmd ":memory:" {ATTACH 'test.db' AS test;
133 .import -schema test shell5.csv t1
134 SELECT COUNT(*) FROM test.t1;}]
142 set res [catchcmd ":memory:" {ATTACH 'test.db' AS test;
144 .import --schema test shell5.csv t1
145 SELECT COUNT(*) FROM test.t1;}]
153 set res [catchcmd "test.db" {.import shell5.csv t1
158 catchcmd "test.db" {SELECT b FROM t1 WHERE a='5';}
168 set res [catchcmd "test.db" {.import shell5.csv t1
173 catchcmd "test.db" {SELECT b FROM t1 WHERE a='6';}
181 set res [catchcmd "test.db" {.import shell5.csv t1
186 catchcmd "test.db" {SELECT b FROM t1 WHERE a='7';}
197 set res [catchcmd "test.db" {CREATE TABLE t2(x INT, y INT);
212 set res [catchcmd "test.db" {DELETE FROM t2;
226 set res [catchcmd "test.db" {.import shell5.csv t1
246 set res [catchcmd "test.db" {DROP TABLE IF EXISTS t2;
260 set res [catchcmd "test.db" {.mode csv
268 forcedelete test.db
269 catchcmd test.db {.mode csv
296 forcedelete test.db
297 catchcmd test.db {.mode csv
301 sqlite3 db test.db
314 forcedelete test.db
315 catchcmd test.db {.mode csv
319 sqlite3 db test.db
333 forcedelete test.db
334 catchcmd test.db {.mode csv
337 sqlite3 db test.db
345 sqlite3 db test.db
350 catchcmd test.db [string trim {
362 catchcmd test.db [string trim {
374 catchcmd test.db [string trim {
386 catchcmd test.db [string trim {
399 catchcmd test.db [string trim {
413 puts -nonewline $fd "\"test 1\"\x1F,test 2\r\n\x1E"
414 puts -nonewline $fd "test 3\x1Ftest 4\n"
416 catchcmd test.db {
422 } "\{\"test 1\"} \{,test 2\r\n\} \{test 3\} \{test 4\n\}"
425 set x [catchcmd test.db {
432 } "0 \{\"test 1\"\x1F,test 2<EOL>\x1Etest 3\x1Ftest 4<EOL>\x1E\}"
441 catchcmd test.db [string trim {
456 catchcmd test.db [string trim {
470 catchcmd test.db [string trim {
484 catchcmd test.db [string trim {
505 forcedelete test.db
506 catchcmd test.db {.import -csv shell5.csv t1
529 forcedelete test.db
530 catchcmd test.db {.import -csv shell5.csv t1
553 forcedelete test.db
554 catchcmd test.db {.import -csv shell5.csv t1
566 forcedelete test.db
567 catchcmd test.db {.import -csv shell5.csv t1