Lines Matching refs:test
20 # shell1-3.*: Basic test that "dot" command can be called.
22 # shell1-9.*: Basic test that "dot" commands and SQL intermix ok.
28 forcedelete test.db test.db-journal test.db-wal
29 sqlite3 db test.db
37 set res [catchcmd "-bad test.db" ""]
43 set res [catchcmd "test.db -bad" ""]
50 catchcmd "test.db \"select+3\" \"select+4\"" ""
55 catchcmd "test.db FOO test.db BAD" ".quit"
60 set res [catchcmd "-help test.db" ""]
74 catchcmd "-init FOO test.db" ""
77 catchcmd "-init FOO test.db .quit BAD" ""
80 catchcmd "-init FOO test.db BAD .quit" ""
85 catchcmd "-echo test.db" ""
90 catchcmd "-header test.db" ""
93 catchcmd "-noheader test.db" ""
98 catchcmd "-bail test.db" ""
103 set res [catchcmd "-interactive test.db" ".quit"]
112 catchcmd "-batch test.db" ""
117 catchcmd "-column test.db" ""
122 catchcmd "-csv test.db" ""
127 catchcmd "-html test.db" ""
132 catchcmd "-line test.db" ""
137 catchcmd "-list test.db" ""
142 catchcmd "-separator 'x' test.db" ""
145 catchcmd "-separator x test.db" ""
156 catchcmd "-stats test.db" ""
161 catchcmd "-nullvalue 'x' test.db" ""
164 catchcmd "-nullvalue x test.db" ""
175 set x [catchcmd "-version test.db" ""]
184 catchcmd "test.db" ".foo"
187 catchcmd "test.db" ".\"foo OFF\""
190 catchcmd "test.db" ".\'foo OFF\'"
195 catchcmd "test.db" ".\"foo OFF"
198 catchcmd "test.db" ".\'foo OFF"
201 catchcmd "test.db" ".explain \"OFF"
204 catchcmd "test.db" ".explain \'OFF"
207 catchcmd "test.db" ".mode \"insert FOO"
210 catchcmd "test.db" ".mode \'insert FOO"
215 catchcmd "test.db" ".explain 1"
218 catchcmd "test.db" ".explain on"
221 catchcmd "test.db" ".explain \"1 2 3\""
224 catchcmd "test.db" ".explain \"OFF\""
227 catchcmd "test.db" ".\'explain\' \'OFF\'"
230 catchcmd "test.db" ".explain \'OFF\'"
233 catchcmd "test.db" ".\'explain\' \'OFF\'"
238 catchcmd "test.db" ".mode FOO"
241 catchcmd "test.db" ".mode csv"
244 catchcmd "test.db" ".mode \"csv\""
249 # Test cases shell1-3.*: Basic test that "dot" command can be called.
254 catchcmd "test.db" ".backup"
258 catchcmd "test.db" ".backup FOO"
261 catchcmd "test.db" ".backup FOO BAR"
265 catchcmd "test.db" ".backup FOO BAR BAD"
270 catchcmd "test.db" ".bail"
273 catchcmd "test.db" ".bail ON"
276 catchcmd "test.db" ".bail OFF"
280 catchcmd "test.db" ".bail OFF BAD"
286 catchcmd "-csv test.db" ".databases"
290 catchcmd "test.db" ".databases BAD"
298 set res [catchcmd "test.db" ".dump"]
303 set res [catchcmd "test.db" ".dump FOO"]
310 # catchcmd "test.db" ".dump FOO BAD"
315 catchcmd "test.db" ".echo"
318 catchcmd "test.db" ".echo ON"
321 catchcmd "test.db" ".echo OFF"
325 catchcmd "test.db" ".echo OFF BAD"
330 catchcmd "test.db" ".exit"
335 catchcmd "test.db" ".explain"
339 catchcmd "test.db" ".explain ON"
342 catchcmd "test.db" ".explain OFF"
346 catchcmd "test.db" ".explain OFF BAD"
352 catchcmd "test.db" ".header"
355 catchcmd "test.db" ".header ON"
358 catchcmd "test.db" ".header OFF"
362 catchcmd "test.db" ".header OFF BAD"
366 catchcmd "test.db" ".headers"
369 catchcmd "test.db" ".headers ON"
372 catchcmd "test.db" ".headers OFF"
376 catchcmd "test.db" ".headers OFF BAD"
381 set res [catchcmd "test.db" ".help"]
389 set res [catchcmd "test.db" ".help *"]
398 catchcmd "test.db" ".import"
401 catchcmd "test.db" ".import FOO"
405 catchcmd "test.db" ".import FOO BAR BAD"
412 catchcmd "test.db" ".indexes"
415 catchcmd "test.db" ".indexes FOO"
418 catchcmd "test.db" ".indices FOO"
422 catchcmd "test.db" ".indexes FOO BAD"
436 catchcmd "test.db" ".mode"
439 catchcmd "test.db" ".mode FOO"
442 catchcmd "test.db" ".mode csv"
445 catchcmd "test.db" ".mode column"
448 catchcmd "test.db" ".mode html"
451 catchcmd "test.db" ".mode insert"
454 catchcmd "test.db" ".mode line"
457 catchcmd "test.db" ".mode list"
460 catchcmd "test.db" ".mode tabs"
463 catchcmd "test.db" ".mode tcl"
467 catchcmd "test.db" ".mode tcl BAD"
472 catchcmd "test.db" ".nullvalue"
475 catchcmd "test.db" ".nullvalue FOO"
479 catchcmd "test.db" ".nullvalue FOO BAD"
484 catchcmd "test.db" ".output"
487 catchcmd "test.db" ".output FOO"
491 catchcmd "test.db" ".output FOO BAD"
503 catchcmd "test.db" ".output stdout"
507 catchcmd "test.db" ".output stdout BAD"
519 catchcmd "test.db" ".prompt"
522 catchcmd "test.db" ".prompt FOO"
525 catchcmd "test.db" ".prompt FOO BAR"
529 catchcmd "test.db" ".prompt FOO BAR BAD"
534 catchcmd "test.db" ".quit"
538 catchcmd "test.db" ".quit BAD"
543 catchcmd "test.db" ".read"
547 catchcmd "test.db" ".read FOO"
551 catchcmd "test.db" ".read FOO BAD"
556 catchcmd "test.db" ".restore"
559 catchcmd "test.db" ".restore FOO"
562 catchcmd "test.db" ".restore FOO BAR"
566 catchcmd "test.db" ".restore FOO BAR BAD"
574 catchcmd "test.db" ".schema"
577 catchcmd "test.db" ".schema FOO"
581 catchcmd "test.db" ".schema FOO BAD"
585 catchcmd "test.db" {
590 catchcmd "test.db" ".schema"
602 catchcmd "test.db" ".separator"
605 catchcmd "test.db" ".separator FOO"
608 catchcmd "test.db" ".separator ABC XYZ"
612 catchcmd "test.db" ".separator FOO BAD BAD2"
617 set res [catchcmd "test.db" ".show"]
631 catchcmd "test.db" ".show BAD"
636 # catchcmd "test.db" ".stats"
639 catchcmd "test.db" ".stats ON"
642 catchcmd "test.db" ".stats OFF"
646 catchcmd "test.db" ".stats OFF BAD"
653 catchcmd "test.db" [string map {"\n " "\n"} {
666 catchcmd "test.db" ".tables"
669 catchcmd "test.db" ".tables FOO"
673 catchcmd "test.db" ".tables FOO BAD"
678 catchcmd "test.db" ".timeout"
681 catchcmd "test.db" ".timeout zzz"
685 catchcmd "test.db" ".timeout 1"
689 catchcmd "test.db" ".timeout 1 BAD"
694 catchcmd "test.db" ".width"
697 catchcmd "test.db" ".width xxx"
701 catchcmd "test.db" ".width xxx yyy"
705 catchcmd "test.db" ".width 1 1"
709 catchcmd "test.db" ".mode column\n.header off\n.width 10 -10\nSELECT 'abcdefg', 123456;"
713 catchcmd "test.db" ".mode column\n.header off\n.width -10 10\nSELECT 'abcdefg', 123456;"
720 catchcmd "test.db" ".timer"
723 catchcmd "test.db" ".timer ON"
726 catchcmd "test.db" ".timer OFF"
730 catchcmd "test.db" ".timer OFF BAD"
734 catchcmd test.db \
739 catchcmd "test.db" ".print this is a test"
740 } {0 {this is a test}}
744 catchcmd {test.db} {.print "this\"is'a\055test" 'this\"is\\a\055test'}
745 } {0 {this"is'a-test this\"is\\a\055test}}
747 catchcmd {test.db} {.print "this\nis\ta\\test" 'this\nis\ta\\test'}
748 } [list 0 "this\nis\ta\\test this\\nis\\ta\\\\test"]
755 forcedelete test.db
756 sqlite3 db test.db
765 catchcmd test.db {.dump}
790 catchcmd test.db {.dump --preserve-rowids}
920 catchcmd test.db ".mode insert t1\nselect * from t1;"
931 catchcmd test.db ".mode insert t1\n.headers on\nselect * from t1;"
942 catchcmd test.db ".mode insert t3\nselect * from t3;"
953 catchcmd test.db ".mode insert t3\n.headers on\nselect * from t3;"
965 forcedelete test.db
966 sqlite3 db test.db
972 catchcmd test.db ".mode tcl\nselect * from t1;"
987 catchcmd test.db ".mode tcl\nselect * from t2;"
995 catchcmd test.db ".mode tcl\n.nullvalue NULL\nselect * from t2;"
1007 foreach {x y} [catchcmd test.db ".mode tcl\nselect * from tcl1;"] break
1020 catchcmd test.db ".mode quote\nselect x'0123456789ABCDEF';"
1072 set x [catchcmdex test.db ".print $char\n"]
1089 # These test cases do not work on MinGW
1092 # The string used here is the word "test" in Chinese.
1094 set test \u6D4B\u8BD5
1097 set fileName $test; append fileName .db
1117 "CREATE TABLE [encoding convertto utf-8 $test](x);\n.schema\n"]
1123 if {$res ne "CREATE TABLE ${test}(x);"} {
1131 forcedelete test.db test.db-journal test.db-wal
1132 sqlite3 db test.db
1149 catchcmd "test.db" ".schema _"
1153 catchcmd "test.db" ".schema \\\\_"
1156 catchcmd "test.db" ".schema __"
1160 catchcmd "test.db" ".schema \\\\_\\\\_"
1163 catchcmd "test.db" ".schema ___"
1167 catchcmd "test.db" ".schema \\\\_\\\\_\\\\_"
1243 # Test cases shell1-9.*: Basic test that "dot" commands and SQL intermix ok.