long=0
pkgonly=0
quiet=0
+config=include
-while getopts f:qln opt; do
+while getopts f:qlncC opt; do
case $opt in
f) pkgfile="$OPTARG" ;;
l) long=1 ;;
n) pkgonly=1 ;;
q) quiet=1 ;;
+ c) config=only ;;
+ C) config=exclude ;;
esac
done
shift $((OPTIND - 1))
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
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"
+ printf "else path end as path\n"
fi
printf 'from packagefiles_pkgid\nwhere true\n'
if [ -n "$globlist" ]; then
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