Lines Matching refs:execsql

58   set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
65   set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
72   execsql {CREATE TABLE test1(one int, two int, three int)}
73   execsql {COPY test1 FROM 'data1.txt'}
74   execsql {SELECT * FROM test1 ORDER BY one}
80   execsql {DELETE FROM test1}
81   execsql {COPY test1 FROM 'data2.txt'}
82   execsql {SELECT * FROM test1 ORDER BY one}
88   execsql {DELETE FROM test1}
89   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
90   execsql {SELECT * FROM test1 ORDER BY one}
93   execsql {DELETE FROM test1}
94   execsql {COPY test1 FROM 'data5.txt' USING DELIMITERS '|'}
95   execsql {SELECT * FROM test1 ORDER BY one}
98   execsql {DELETE FROM test1}
99   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS '|'}
100   execsql {SELECT * FROM test1 ORDER BY one}
106   execsql {DELETE FROM test1}
107   execsql {CREATE INDEX index1 ON test1(one)}
108   execsql {CREATE INDEX index2 ON test1(two)}
109   execsql {CREATE INDEX index3 ON test1(three)}
110   execsql {COPY test1 from 'data1.txt'}
111   execsql {SELECT * FROM test1 WHERE one=11}
114   execsql {SELECT * FROM test1 WHERE one=22}
117   execsql {SELECT * FROM test1 WHERE two=22}
120   execsql {SELECT * FROM test1 WHERE three=11}
131   execsql {CREATE TABLE test2(a int, x text)}
135   execsql {COPY test2 FROM 'data21.txt'}
136   execsql {SELECT x from test2}
147   execsql {
158   execsql {
170   execsql {
184   execsql {
191   execsql {
199   execsql {
235   execsql {
242   execsql {
247   execsql {
253   execsql {