Lines Matching refs:data
34 set data [read $fd]
36 set data
71 SELECT replace(name,'test_unzip/',''),modefix(name,mode),mtime,data
99 # (SELECT zipfile(name,mode,mtime,data,method) FROM zipfile($file))
105 set q1 {SELECT name,mode,mtime,method,quote(data) FROM zipfile($file)}
106 set q2 {SELECT name,mode,mtime,method,quote(data) FROM zipfile( r($file) )}
107 set q3 {SELECT name,mode,mtime,method,quote(data) FROM zipfile(
108 ( SELECT zipfile(name,mode,mtime,data,method) FROM zipfile($file) )
133 # ( SELECT zipfile(name,mode,mtime,data,method) FROM zipfile($file) )
144 ( SELECT zipfile(name,mode,mtime,data,method) FROM zipfile($file) )
149 SELECT sss(name),mode,mtime,data FROM zipfile($file) ORDER BY name
176 5 data {} 0 {} 0
185 INSERT INTO zz(name, mtime, sz, data, 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)
207 SELECT name, mtime, data FROM zipfile('test.zip')
215 INSERT INTO zz(name, mode, mtime, data) VALUES('h.txt',
222 SELECT name, mtime, data, method FROM zipfile('test.zip');
245 INSERT INTO zz(name, mode, mtime, data, method)
254 SELECT data FROM zz WHERE name='i.txt';
263 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
273 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
290 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
300 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
309 UPDATE zz SET data = 'edcba' WHERE name='blue.txt';
310 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
318 UPDATE zz SET mode=NULL, data = NULL WHERE name='blue.txt';
319 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
327 UPDATE zz SET data=NULL WHERE name='i.txt'
328 } {1 {zipfile: mode does not match data}}
330 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
338 UPDATE zz SET data = '' WHERE name='i.txt';
339 SELECT name,mode,mtime,data,method from zipfile('test.zip');
347 SELECT a.name, a.data
357 SELECT name, data FROM zz WHERE name LIKE '%txt'
377 SELECT name, mode, data FROM zzz;
380 INSERT INTO zzz(name, data) VALUES('dirname2', NULL);
381 INSERT INTO zzz(name, data) VALUES('dirname2/file1.txt', 'abcdefghijklmnop');
382 SELECT name, mode, data FROM zzz;
393 SELECT name, mode, data FROM zzz;
420 set data [read $fd]
422 set data
434 INSERT INTO x1(name, data) VALUES('dir1/', NULL);
435 INSERT INTO x1(name, data) VALUES('file1', '1234');
436 INSERT INTO x1(name, data) VALUES('dir1/file2', '5678');
444 INSERT INTO x1(name, data) VALUES($fname, NULL);
447 INSERT INTO x1(name, data) VALUES($fname || '/', NULL);
450 INSERT INTO x1(name, data) VALUES($fname, 'abcd');
488 WITH c(name,data) AS ( SELECT 'a.txt', 'abc')
493 WITH c(name,data) AS (
497 SELECT zipfile(name,data) FROM c
501 WITH c(name,data,method) AS (
506 SELECT zipfile(name,NULL,NULL,data,method) FROM c
510 WITH c(name,data) AS (
515 SELECT zipfile(name,NULL,NULL,data) FROM c
522 WITH c(name,mtime,data) AS (
525 SELECT name,mtime,data FROM zipfile(
526 ( SELECT rt( zipfile(name,NULL,mtime,data,NULL) ) FROM c )
537 WITH c(name,mtime,data) AS (
542 SELECT writefile('test1.zip', rt( zipfile(name, NULL, mtime, data) ) ),
543 writefile('test2.zip', ( zipfile(name, NULL, mtime, data) ) )
570 SELECT name, mtime, data FROM zipfile('test1.zip')
594 SELECT name, mtime, sz, rawdata, data FROM zipfile('test2.zip')
609 WITH c(name,data) AS (
614 SELECT writefile('test.zip', zipfile(name, data) ) FROM c;
618 db eval { SELECT name, data FROM 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 } {
646 execsql { SELECT name, data FROM zz }
656 INSERT INTO nogood(name, data) VALUES('abc', 'def');
665 INSERT INTO nogood(name, data) VALUES('abc', 'def');
675 INSERT INTO ok(name, data) VALUES ('sqlite3', 'elf');
706 INSERT INTO z(name,data) VALUES('a0','one'),('a0','two');
709 SELECT name, data FROM z;
712 REPLACE INTO z(name,data) VALUES('a0','three'),('a0','four');
715 SELECT name, data FROM z;
718 INSERT OR IGNORE INTO z(name,data) VALUES('a0','five'),('a0','six');
721 SELECT name, data FROM z;
728 SELECT name, data FROM z;
731 INSERT INTO z (name,data) VALUES ('b0','one');
732 SELECT name, data FROM z;
736 SELECT name, data FROM z;
739 INSERT INTO z (name,data) VALUES ('b0','one');
740 SELECT name, data FROM z ORDER BY name;
746 UPDATE z SET data = 'two' WHERE name = 'b0';
747 SELECT name, data FROM z ORDER BY name;
757 SELECT name, data FROM z ORDER BY name;
761 SELECT name, data FROM z ORDER BY name;
808 quote(data),quote(method) FROM t1;