X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=zpm-contents;h=6cdd485d4562397bb10baffac3334fe5d156c40a;hb=c907b8ec08b06a4a256fd12b79b4bcf5088fbb19;hp=7522c183a647f0f8f9ab34647963e3954e2021db;hpb=d92a98237b9bccf4e7017dce7a294ece618cf1fc;p=zpackage diff --git a/zpm-contents b/zpm-contents index 7522c18..6cdd485 100755 --- a/zpm-contents +++ b/zpm-contents @@ -1,17 +1,22 @@ #!/bin/sh -pkgfile=${ZPMDB:-/var/lib/zpm/db.zpm} +pkgfile=${ZPMDB:-/var/lib/zpm/local.db} long=0 pkgonly=0 quiet=0 +config=include +showsoname=0 -while getopts f:qln opt; do +while getopts f:qlncCL opt; do case $opt in f) pkgfile="$OPTARG" ;; l) long=1 ;; n) pkgonly=1 ;; q) quiet=1 ;; + c) config=only ;; + C) config=exclude ;; + L) showsoname=1 ;; esac done shift $((OPTIND - 1)) @@ -22,7 +27,7 @@ if [ ! -f $pkgfile ]; then fi if [ $long -gt 0 ]; then - cols="filetype,printf('%3.3s', mode) as mode,username,groupname," + cols="filetype,printf('%.4s', mode) as mode,username,groupname," fi if [ $pkgonly -eq 1 ]; then @@ -67,21 +72,25 @@ cols=${cols%,} printf ', ' fi - cat <<-EOC - case when filetype = 'd' then - rtrim(path,'/') || '/' - else - path - end as path - EOC + printf "case\n"; + printf "when filetype = 'd' then rtrim(path,'/') || '/'\n" + printf "when filetype = 'l' then printf('%%s -> %%s', path, target)\n" + if [ $showsoname -eq 1 ]; then + printf "when EL.soname is not null then printf('%%s (%%s)', path, EL.soname)\n" + fi + printf "else path end as path\n" fi - printf 'from packagefiles_pkgid\nwhere true\n' + printf 'from packagefiles_pkgid PF left join elflibraries EL on EL.file = PF.hash\nwhere true\n' if [ -n "$globlist" ]; then printf "and (%s)\n" "$globlist" fi if [ -n "$pkglist" ]; then printf "and pkgid in (%s)\n" "$pkglist" fi + case $config in + only) printf "and configuration = 1\n" ;; + exclude) printf "and configuration = 0\n" ;; + esac printf 'order by pkgid,path\n' printf ';\n' } | zpm shell $pkgfile