Lines Matching refs:zz

168   CREATE VIRTUAL TABLE temp.zz USING zipfile('test.zip');
169   PRAGMA table_info(zz);
181   INSERT INTO zz(name, mode, mtime, sz, rawdata, method) 
185   INSERT INTO zz(name, mtime, sz, data, method) 
189   INSERT INTO zz(name, mtime, rawdata, method) 
193   INSERT INTO zz(name, data, method) 
198   INSERT INTO zz(name, mode, mtime, data, method) 
202   INSERT INTO zz(name, mode, mtime, data, method) 
215   INSERT INTO zz(name, mode, mtime, data) VALUES('h.txt', 
245     INSERT INTO zz(name, mode, mtime, data, method)
247     SELECT name FROM zz;
251   SELECT name FROM zz;
254   SELECT data FROM zz WHERE name='i.txt';
258   DELETE FROM zz WHERE name='g.txt';
259   SELECT name FROM zz;
272   UPDATE zz SET mtime=4 WHERE name='i.txt';
289   UPDATE zz SET mode=$modes WHERE name='h.txt';
299   UPDATE zz SET name = 'blue.txt' WHERE name='f.txt';
309   UPDATE zz SET data = 'edcba' WHERE name='blue.txt';
318   UPDATE zz SET mode=NULL, data = NULL WHERE name='blue.txt';
327   UPDATE zz SET data=NULL WHERE name='i.txt'
338   UPDATE zz SET data = '' WHERE name='i.txt';
348   FROM zz AS a, zz AS b 
357   SELECT name, data FROM zz WHERE name LIKE '%txt'
364   DELETE FROM zz;
365   SELECT * FROM zz;
626   CREATE VIRTUAL TABLE zz USING zipfile('test.zip');
628     INSERT INTO zz(name, data) VALUES('a.txt', '1');
629     INSERT INTO zz(name, data) VALUES('b.txt', '2');
630     INSERT INTO zz(name, data) VALUES('c.txt', '1');
631     INSERT INTO zz(name, data) VALUES('d.txt', '2');
632     SELECT name, data FROM zz;
637   db eval { SELECT name, data FROM zz } {
638     if { $data=="2" } { db eval { DELETE FROM zz WHERE name=$name } }
640   execsql { SELECT name, data FROM zz } 
643   db eval { SELECT name, data FROM zz } {
644     db eval { DELETE FROM zz WHERE name=$name }
646   execsql { SELECT name, data FROM zz }