#!/bin/sh
#
# Copyright (c) 2020 Vincent Delft <vincent.delft@gmail.com>
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
# WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
# ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
# WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
# ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

pkgid=$(echo $1 | cut -d "|" -f1)
echo "Category:"
sqlite3 /usr/local/share/sqlports "select DISTINCT FullPkgPath from Categories where PathId=\"$pkgid\";"
echo " "

res=$(sqlite3 /usr/local/share/sqlports "select Value from Flavors where PathId=\"$pkgid\";"| tr '\n' ', ')
[ -n "$res" ] && echo "Flavors:\n${res%%,}\n"

echo "Description:"
sqlite3 /usr/local/share/sqlports "SELECT Value FROM Descr WHERE PathId = \"$pkgid\";"