Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a few more zipfile tests. No changes to code. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
3f621545879ea39502cfaf2b61883f92 |
| User & Date: | dan 2018-02-01 20:42:23.543 |
Context
|
2018-02-02
| ||
| 16:20 | Remove the time() dependency from the zipfile extension. Use SQLite VFS methods instead. (check-in: 0702fb5611 user: dan tags: trunk) | |
|
2018-02-01
| ||
| 20:42 | Add a few more zipfile tests. No changes to code. (check-in: 3f62154587 user: dan tags: trunk) | |
| 19:41 | Fix a problem triggered when a zipfile virtual table is created and written to within the same transaction. And add other zipfile tests. (check-in: 48f1c55699 user: dan tags: trunk) | |
Changes
Changes to test/zipfile.test.
| ︙ | ︙ | |||
436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 |
} {
do_catchsql_test 4.5.$tn {
WITH m(m) AS ( SELECT $mode)
SELECT zipfile('a.txt', m, 1000, 'xyz') FROM m
} [list 1 "zipfile: parse error in mode: $mode"]
}
#--------------------------------------------------------------------------
db func rt remove_timestamps
do_execsql_test 5.0 {
WITH c(name,mtime,data) AS (
SELECT 'a.txt', 946684800, 'abc'
)
SELECT name,mtime,data FROM zipfile(
| > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | | 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 |
} {
do_catchsql_test 4.5.$tn {
WITH m(m) AS ( SELECT $mode)
SELECT zipfile('a.txt', m, 1000, 'xyz') FROM m
} [list 1 "zipfile: parse error in mode: $mode"]
}
do_catchsql_test 4.6 {
WITH c(name,data) AS ( SELECT 'a.txt', 'abc')
SELECT zipfile(name) FROM c
} {1 {wrong number of arguments to function zipfile()}}
do_catchsql_test 4.7 {
WITH c(name,data) AS (
SELECT 'a.txt', 'abc' UNION ALL
SELECT NULL, 'def'
)
SELECT zipfile(name,data) FROM c
} {1 {first argument to zipfile() must be non-NULL}}
do_catchsql_test 4.7 {
WITH c(name,data,method) AS (
SELECT 'a.txt', 'abc', 0
UNION SELECT 'b.txt', 'def', 8
UNION SELECT 'c.txt', 'ghi', 16
)
SELECT zipfile(name,NULL,NULL,data,method) FROM c
} {1 {illegal method value: 16}}
do_catchsql_test 4.8 {
WITH c(name,data) AS (
SELECT 'a.txt', 'abc'
UNION SELECT 'b.txt', 'def'
UNION SELECT 'c.txt/', 'ghi'
)
SELECT zipfile(name,NULL,NULL,data) FROM c
} {1 {non-directory name must not end with /}}
#--------------------------------------------------------------------------
db func rt remove_timestamps
do_execsql_test 5.0 {
WITH c(name,mtime,data) AS (
SELECT 'a.txt', 946684800, 'abc'
)
SELECT name,mtime,data FROM zipfile(
( SELECT rt( zipfile(name,NULL,mtime,data,NULL) ) FROM c )
)
} {
a.txt 946684800 abc
}
if {[info vars ::UNZIP]!=""} {
ifcapable datetime {
|
| ︙ | ︙ | |||
588 589 590 591 592 593 594 595 596 |
do_execsql_test 8.3.1 {
BEGIN;
CREATE VIRTUAL TABLE ok USING zipfile('test.zip');
INSERT INTO ok(name, data) VALUES ('sqlite3', 'elf');
COMMIT;
}
finish_test
| > > > > > > > > > > > > > | 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 |
do_execsql_test 8.3.1 {
BEGIN;
CREATE VIRTUAL TABLE ok USING zipfile('test.zip');
INSERT INTO ok(name, data) VALUES ('sqlite3', 'elf');
COMMIT;
}
#-------------------------------------------------------------------------
# Test that the zipfile aggregate correctly adds and removes "/" from
# the ends of directory file names.
do_execsql_test 9.0 {
WITH src(nm) AS (
VALUES('dir1') UNION ALL
VALUES('dir2/') UNION ALL
VALUES('dir3//') UNION ALL
VALUES('dir4///') UNION ALL
VALUES('/')
)
SELECT name FROM zipfile((SELECT zipfile(nm, NULL) FROM src))
} {dir1/ dir2/ dir3/ dir4/ /}
finish_test
|
Changes to test/zipfilefault.test.
| ︙ | ︙ | |||
80 81 82 83 84 85 86 87 88 89 90 91 92 93 |
);
}
} -test {
faultsim_test_result {0 {1 aaaaaaaaaaabbbbbbbbbbaaaaaaaaaabbbbbbbbbb}}
}
reset_db
load_static_extension db zipfile
do_execsql_test 5.0 {
CREATE VIRTUAL TABLE setup USING zipfile('test.zip')
}
do_faultsim_test 5.1 -faults oom* -prep {
| > | 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 |
);
}
} -test {
faultsim_test_result {0 {1 aaaaaaaaaaabbbbbbbbbbaaaaaaaaaabbbbbbbbbb}}
}
reset_db
sqlite3_db_config_lookaside db 0 0 0
load_static_extension db zipfile
do_execsql_test 5.0 {
CREATE VIRTUAL TABLE setup USING zipfile('test.zip')
}
do_faultsim_test 5.1 -faults oom* -prep {
|
| ︙ | ︙ | |||
122 123 124 125 126 127 128 129 |
execsql {
INSERT INTO setup(name, data) VALUES('dir', NULL)
}
} -test {
catchsql { COMMIT }
faultsim_test_result {0 {}}
}
| > > > > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > | 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 |
execsql {
INSERT INTO setup(name, data) VALUES('dir', NULL)
}
} -test {
catchsql { COMMIT }
faultsim_test_result {0 {}}
}
do_faultsim_test 6.1 -faults oom* -body {
execsql {
WITH c(n, d) AS (
VALUES('a.txt', '1234567890') UNION ALL
VALUES('dir', NULL)
)
SELECT zipfile(n, d) IS NULL FROM c;
}
} -test {
faultsim_test_result {0 0}
}
set big [string repeat 0123456789 1000]
do_faultsim_test 6.2 -faults oom* -body {
execsql {
WITH c(n, d) AS (
VALUES('a.txt', $big)
)
SELECT zipfile(n, NULL, NULL, d, 0) IS NULL FROM c;
}
} -test {
faultsim_test_result {0 0}
}
do_faultsim_test 7.0 -faults oom* -prep {
catch { db close }
sqlite3 db ""
} -body {
load_static_extension db zipfile
} -test {
}
finish_test
|