sqlcipher-3.4.2/test/shell5.test

34   catchcmd "test.db" ".import"
37   catchcmd "test.db" ".import FOO"
40 #  catchcmd "test.db" ".import FOO BAR"
44   catchcmd "test.db" ".import FOO BAR BAD"
49   catchcmd "test.db" ".separator"
52   catchcmd "test.db" ".separator ONE"
55   catchcmd "test.db" ".separator ONE TWO"
59   catchcmd "test.db" ".separator ONE TWO THREE"
64   set res [catchcmd "test.db" ".show"]
70   set res [catchcmd "test.db" ".show"]
77   set res [catchcmd "test.db" {.separator ,
85   set res [catchcmd "test.db" {CREATE TABLE t1(a, b);
94   set res [catchcmd "test.db" {.import shell5.csv t1
103   set res [catchcmd "test.db" {.import shell5.csv t1}]
111   set res [catchcmd "test.db" {.import shell5.csv t1}]
119   set res [catchcmd "test.db" {DELETE FROM t1;
132   set res [catchcmd "test.db" {.import shell5.csv t1
141   set res [catchcmd "test.db" {.separator ,
151   set res [catchcmd "test.db" {.import shell5.csv t1
156   catchcmd "test.db" {SELECT b FROM t1 WHERE a='5';}
166   set res [catchcmd "test.db" {.import shell5.csv t1
171   catchcmd "test.db" {SELECT b FROM t1 WHERE a='6';}
179   set res [catchcmd "test.db" {.import shell5.csv t1
184   catchcmd "test.db" {SELECT b FROM t1 WHERE a='7';}
195   set res [catchcmd "test.db" {CREATE TABLE t2(x INT, y INT);
210   set res [catchcmd "test.db" {DELETE FROM t2;
224   set res [catchcmd "test.db" {.import shell5.csv t1
244   set res [catchcmd "test.db" {DROP TABLE IF EXISTS t2;
258   set res [catchcmd "test.db" {.mode csv
267     catchcmd test.db {.mode csv
295   catchcmd test.db {.mode csv
313   catchcmd test.db {.mode csv
332   catchcmd test.db {.mode csv
348   catchcmd test.db [string trim {
360   catchcmd test.db [string trim {
372   catchcmd test.db [string trim {
384   catchcmd test.db [string trim {
397   catchcmd test.db [string trim {
414   catchcmd test.db {
423   set x [catchcmd test.db {
439   catchcmd test.db [string trim {
454   catchcmd test.db [string trim {