11 zpm-shell $PF < db.sql
13 okexit direct schema load
16 pragma foreign_keys = off;
17 insert into packagefiles
18 (package,version,release,path,mode,username,groupname,hash)
20 ('foo','1',1,'/nopath','0644','root','root','fakehash')
22 } | zpm-shell $PF 2>/dev/null
24 okexit basic packagefile insert
27 pragma foreign_keys = off;
28 insert into packagefiles
29 (package,version,release,path,mode,username,groupname,hash)
31 ('foo','1',1,'/nopath','0644','root','root',NULL)
33 } | zpm-shell $PF 2>/dev/null
35 failsok regular with null hash rejected
38 pragma foreign_keys = off;
39 insert into packagefiles
40 (package,version,release,path,mode,username,groupname,hash)
42 ('foo','1',1,'/nopath','0644','root',NULL,'fakehash')
44 } | zpm-shell $PF 2>/dev/null
46 failsok null groupname rejected
49 pragma foreign_keys = off;
50 insert into packagefiles
51 (package,version,release,path,mode,username,groupname,hash)
53 ('foo','1',1,'/nopath','0644',NULL,'root','fakehash')
55 } | zpm-shell $PF 2>/dev/null
57 failsok null username rejected
63 zpm-test test.empty 2>/dev/null
64 failsok zpm-test of empty file