pd.if.org Git - zpackage/blob - t/schema.t

   1 #!/bin/sh
   2
   3 . tap.sh
   4
   5 plan 5
   6
   7 PF=test.db
   8
   9 rm -f $PF
  10
  11 zpm-shell $PF < db.sql
  12
  13 okexit direct schema load
  14
  15 { cat<<-EOS
  16 pragma foreign_keys = off;
  17 insert into packagefiles
  18 (package,version,release,path,mode,username,groupname,hash)
  19 values
  20 ('foo','1',1,'/nopath','0644','root','root','fakehash')
  21 EOS
  22 } | zpm-shell $PF 2>/dev/null
  23
  24 okexit basic packagefile insert
  25
  26 { cat<<-EOS
  27 pragma foreign_keys = off;
  28 insert into packagefiles
  29 (package,version,release,path,mode,username,groupname,hash)
  30 values
  31 ('foo','1',1,'/nopath','0644','root','root',NULL)
  32 EOS
  33 } | zpm-shell $PF 2>/dev/null
  34
  35 failsok regular with null hash rejected
  36
  37 { cat<<-EOS
  38 pragma foreign_keys = off;
  39 insert into packagefiles
  40 (package,version,release,path,mode,username,groupname,hash)
  41 values
  42 ('foo','1',1,'/nopath','0644','root',NULL,'fakehash')
  43 EOS
  44 } | zpm-shell $PF 2>/dev/null
  45
  46 failsok null groupname rejected
  47
  48 { cat<<-EOS
  49 pragma foreign_keys = off;
  50 insert into packagefiles
  51 (package,version,release,path,mode,username,groupname,hash)
  52 values
  53 ('foo','1',1,'/nopath','0644',NULL,'root','fakehash')
  54 EOS
  55 } | zpm-shell $PF 2>/dev/null
  56
  57 failsok null username rejected
  58
  59 finish
  60 rm -f $PF
  61 exit 0
  62
  63 zpm-test test.empty 2>/dev/null
  64 failsok zpm-test of empty file
  65
  66 zpm-init $PF
  67  zpm-init new file
  68
  69 finish
  70
  71 rm -f $PF test.empty