Lines Matching refs:execsql

56   set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
63   set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
70   execsql {CREATE TABLE test1(one int, two int, three int)}
71   execsql {COPY test1 FROM 'data1.txt'}
72   execsql {SELECT * FROM test1 ORDER BY one}
78   execsql {DELETE FROM test1}
79   execsql {COPY test1 FROM 'data2.txt'}
80   execsql {SELECT * FROM test1 ORDER BY one}
86   execsql {DELETE FROM test1}
87   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
88   execsql {SELECT * FROM test1 ORDER BY one}
91   execsql {DELETE FROM test1}
92   execsql {COPY test1 FROM 'data5.txt' USING DELIMITERS '|'}
93   execsql {SELECT * FROM test1 ORDER BY one}
96   execsql {DELETE FROM test1}
97   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS '|'}
98   execsql {SELECT * FROM test1 ORDER BY one}
104   execsql {DELETE FROM test1}
105   execsql {CREATE INDEX index1 ON test1(one)}
106   execsql {CREATE INDEX index2 ON test1(two)}
107   execsql {CREATE INDEX index3 ON test1(three)}
108   execsql {COPY test1 from 'data1.txt'}
109   execsql {SELECT * FROM test1 WHERE one=11}
112   execsql {SELECT * FROM test1 WHERE one=22}
115   execsql {SELECT * FROM test1 WHERE two=22}
118   execsql {SELECT * FROM test1 WHERE three=11}
129   execsql {CREATE TABLE test2(a int, x text)}
133   execsql {COPY test2 FROM 'data21.txt'}
134   execsql {SELECT x from test2}
145   execsql {
156   execsql {
168   execsql {
182   execsql {
189   execsql {
197   execsql {
233   execsql {
240   execsql {
245   execsql {
251   execsql {