Lines Matching refs:name
44 proc fix_stat_mode {name mode} {
53 if {[file attributes $name -readonly]} {
71 SELECT replace(name,'test_unzip/',''),modefix(name,mode),mtime,data
73 WHERE name!='test_unzip'
74 ORDER BY name
92 # Argument $file is the name of a zip archive on disk. This function
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
171 0 name {} 1 {} 1
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)
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');
231 SELECT name, json_extract( zipfile_cds(z) , '$.crc32')!=0
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;
263 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
272 UPDATE zz SET mtime=4 WHERE name='i.txt';
273 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
289 UPDATE zz SET mode=$modes WHERE name='h.txt';
290 SELECT name, mode, mtime, data, method FROM zipfile('test.zip');
299 UPDATE zz SET name = 'blue.txt' WHERE name='f.txt';
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'
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
349 WHERE a.name=+b.name AND +a.mode=b.mode
357 SELECT name, data FROM zz WHERE name LIKE '%txt'
376 INSERT INTO zzz(name, mode) VALUES('dirname', 'drwxr-xr-x');
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;
390 UPDATE zzz SET name = 'dirname3' WHERE name = 'dirname/';
393 SELECT name, mode, data FROM zzz;
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);
445 } [list 1 "duplicate name: \"$fname/\""]
447 INSERT INTO x1(name, data) VALUES($fname || '/', NULL);
448 } [list 1 "duplicate name: \"$fname/\""]
450 INSERT INTO x1(name, data) VALUES($fname, 'abcd');
451 } [list 1 "duplicate name: \"$fname\""]
488 WITH c(name,data) AS ( SELECT 'a.txt', 'abc')
489 SELECT zipfile(name) FROM c
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
516 } {1 {non-directory name must not end with /}}
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) ) )
551 SELECT name, strftime('%s', mtime, 'unixepoch', 'localtime')
552 FROM fsdir('test_unzip') WHERE name!='test_unzip'
553 ORDER BY name
564 SELECT sum(name LIKE '%/a.txt')
570 SELECT name, mtime, data FROM zipfile('test1.zip')
583 SELECT name, mtime
584 FROM fsdir('test_unzip') WHERE name!='test_unzip'
585 ORDER BY name
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') } {
619 if {$name==2} { close [open test.zip w+] }
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 }
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');
690 SELECT name FROM zipfile((SELECT zipfile(nm, NULL) FROM src))
706 INSERT INTO z(name,data) VALUES('a0','one'),('a0','two');
707 } {1 {duplicate name: "a0"}}
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;
735 UPDATE z SET name = 'b1' WHERE name = 'b0';
736 SELECT name, data FROM z;
739 INSERT INTO z (name,data) VALUES ('b0','one');
740 SELECT name, data FROM z ORDER BY name;
743 UPDATE z SET name = 'b1' WHERE name = 'b0';
744 } {1 {duplicate name: "b1"}}
746 UPDATE z SET data = 'two' WHERE name = 'b0';
747 SELECT name, data FROM z ORDER BY name;
750 UPDATE z SET name = 'b1';
751 } {1 {duplicate name: "b1"}}
753 UPDATE z SET name = 'b2';
754 } {1 {duplicate name: "b2"}}
756 UPDATE z SET name = name;
757 SELECT name, data FROM z ORDER BY name;
760 UPDATE z SET name = name || 'suffix';
761 SELECT name, data FROM z ORDER BY name;
781 SELECT name FROM fsdir('subdir') ORDER BY 1;
790 SELECT name FROM d JOIN x JOIN fsdir(d) ORDER BY 1;
794 SELECT name FROM d JOIN x JOIN fsdir('.', d) ORDER BY 1;
807 SELECT quote(name),quote(mode),quote(mtime),quote(sz),quote(rawdata),