#!/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))
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\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