#!/bin/sh

# show the installed version for each package if no arguments are given, all
# installed packages are displayed.

chroot=1
pkgroot=

while getopts :R:CNXf:d:Dt:T:u:g: opt; do
	case $opt in
		R) pkgroot="$OPTARG" ;;
		d) ZPMDB="$OPTARG" ;;
	esac
done

shift $((OPTIND - 1))

for cf in /etc/zpmrc ~/.zpmrc ./.zpmrc; do
	test -r $cf && . $cf
done

: ${ZPMDB:=/var/lib/zpm/db.zpm}

export ZPMDB

die() {
	printf 'zpm-installed:' 1>&2
	printf ' %s' $* 1>&2
	printf '\n' 1>&2
	exit 1
}

db=$pkgroot$ZPMDB

set -e
zpm test -v $db

{

	printf '.separator "\\t"\n'
	printf 'select package,version,release from packages\n'
if [ $# -gt 0 ]; then
	printf 'where package in\n('
	printf "'%s'" "$1"
	shift
	for pkg in "$@"; do
		printf ",'%s'" "$pkg"
	done
	printf ')\n'
fi
printf ';\n'
} | zpm shell $db