Lines Matching refs:COPY

15 # focus of this file is testing the COPY statement.
55 # Try to COPY into a non-existant table.
58   set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
65   set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
73   execsql {COPY test1 FROM 'data1.txt'}
81   execsql {COPY test1 FROM 'data2.txt'}
89   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
94   execsql {COPY test1 FROM 'data5.txt' USING DELIMITERS '|'}
99   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS '|'}
110   execsql {COPY test1 from 'data1.txt'}
135   execsql {COPY test2 FROM 'data21.txt'}
149     COPY t1 FROM 'data6.txt';
160     COPY t1 FROM 'data6.txt';
172     COPY t1 FROM 'data6.txt' USING DELIMITERS ':';
186     COPY t1 FROM 'data6.txt';
196 # Test the conflict resolution logic for COPY
202     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
211     COPY t1 FROM 'data6.txt' USING DELIMITERS '|';
220     COPY OR IGNORE t1 FROM 'data6.txt' USING DELIMITERS '|';
229     COPY OR REPLACE t1 FROM 'data6.txt' USING DELIMITERS '|';
238     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
243     COPY OR REPLACE t1 FROM 'data5.txt' USING DELIMITERS '|';
248     COPY OR IGNORE t1 FROM 'data5.txt' USING DELIMITERS '|';
256     COPY t2 FROM 'dataX.txt' USING DELIMITERS '|';