+#!/bin/sh
+
+add=
+remove=
+setlist=
+quiet=0
+clearlist=0
+
+while getopts :f:s:a:r:qc opt; do
+ case $opt in
+ f) pkgfile="$OPTARG" ;;
+ s) setlist="$setlist $OPTARG"; clearlist=1 ;;
+ a) add="$add $OPTARG"; ;;
+ r) remove="$remove $OPTARG" ;;
+ q) quiet=1 ;;
+ c) clearlist=1 ;;
+ esac
+done
+shift $(( OPTIND - 1))
+
+: ${pkgfile:=${ZPMDB:-/var/lib/zpm/local.db}}
+
+if [ -z "$pkgfile" ]; then
+ echo "must specify package file"
+ exit 1
+fi
+
+pkgid=$(zpm findpkg -f $pkgfile "$1")
+if [ -z "$pkgid" ]; then
+ echo "cannot find pkgid for $1"
+ exit 1
+fi
+
+eval $(zpm parse -E "$pkgid")
+package=$(zpm quote -q "$name")
+version=$(zpm quote -q "$version")
+pkgselector="package = $package and version = $version and release = $release"
+listdeps="select requires from packagedeps where %s;\n"
+adddep='insert or ignore into packagedeps (package,version,release,requires) values (%s,%s,%d,%s);\n'
+rmdep='delete from packagedeps where %s and requires = %s;\n'
+cleardeps='delete from packagedeps where %s;\n'
+
+{
+ printf ".bail on\n";
+ printf "begin;\n";
+if [ $clearlist -eq 1 ]; then
+ printf "$cleardeps" "$pkgselector"
+fi
+if [ -n "$setlist" ]; then
+ for dep in $setlist; do
+ qdep=$(zpm quote -q "$dep")
+ printf "$adddep" "$package" "$version" "$release" "$qdep"
+ done
+fi
+if [ -n "$add" ]; then
+ for dep in $add; do
+ qdep=$(zpm quote -q "$dep")
+ printf "$adddep" "$package" "$version" "$release" "$qdep"
+ done
+fi
+if [ -n "$remove" ]; then
+ for dep in $remove; do
+ qdep=$(zpm quote -q "$dep")
+ printf "$rmdep" "$pkgselector" "$qdep"
+ done
+fi
+if [ $quiet -eq 0 ]; then
+ printf "$listdeps" "$pkgselector"
+fi
+ printf "commit;\n";
+} | zpm shell $pkgfile