#!/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=
-while getopts f:qlncC opt; do
+while getopts f:qlncCLI opt; do
case $opt in
f) pkgfile="$OPTARG" ;;
l) long=1 ;;
q) quiet=1 ;;
c) config=only ;;
C) config=exclude ;;
+ L) showsoname=1 ;;
+ I) status=installed
esac
done
shift $((OPTIND - 1))
{
printf '.separator " "\n'
+# printf '.echo on\n'
printf 'select %s\n' "$cols"
if [ $pkgonly -eq 0 ]; then
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\n"
+ if [ $showsoname -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 "where true\n"
if [ -n "$globlist" ]; then
printf "and (%s)\n" "$globlist"
fi
only) printf "and configuration = 1\n" ;;
exclude) printf "and configuration = 0\n" ;;
esac
- printf 'order by pkgid,path\n'
+ 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