#!/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
+status=
+sharedlibsonly=0
-while getopts f:qln opt; do
+while getopts f:qlncCLIs 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 ;;
+ s) sharedlibsonly=1 ;;
+ I) status=installed ;;
esac
done
shift $((OPTIND - 1))
q=$(zpm quote -q "$pkgid")
pkglist=",$q"
else
- warn "package $pkg not found, ignoring"
+ printf "package $pkg not found, ignoring\n" 1>&2
+ exit 1
+ fi
+ pkglist=${pkglist#,}
+ if [ -z "$pkglist" ]; then
+ printf "can't find any packages\n" 1>&2
+ exit 1
fi
done
-pkglist=${pkglist#,}
globlist=
for glob in "$@"; do
{
printf '.separator " "\n'
+# printf '.echo on\n'
printf 'select %s\n' "$cols"
if [ $pkgonly -eq 0 ]; then
printf ', '
fi
- cat <<-EOC
- case when filetype = 'd' then
- rtrim(path,'/') || '/'
- when filetype = 'l' then
- printf('%s -> %s', path, target)
- 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 PF\n"
+ if [ $showsoname -eq 1 ] || [ $sharedlibsonly -eq 1 ]; then
+ printf "left join elflibraries EL on EL.file = PF.hash\n"
+ fi
+ if [ -n "$status" ]; then
+ printf "join packages P on P.package = PF.package and P.version = PF.version and P.release = PF.release\n"
fi
- printf 'from packagefiles_pkgid\nwhere true\n'
+ printf "where true\n"
if [ -n "$globlist" ]; then
printf "and (%s)\n" "$globlist"
fi
if [ -n "$pkglist" ]; then
printf "and pkgid in (%s)\n" "$pkglist"
fi
- printf 'order by pkgid,path\n'
+ case $config in
+ only) printf "and configuration = 1\n" ;;
+ exclude) printf "and configuration = 0\n" ;;
+ esac
+ if [ $sharedlibsonly -eq 1 ]; then
+ printf "and EL.soname is not null\n"
+ fi
+ if [ -n "$status" ]; then
+ printf "and P.status = '%s'\n" "$status"
+ fi
+ printf 'order by package,version collate vercmp, release, path\n'
printf ';\n'
} | zpm shell $pkgfile
#} | cat