#!/bin/sh

portsdir=/usr/ports
tmpdir=/home/jilles/src/sh/makefilenamedb

#echo "CREATE TABLE files ( category TEXT, port TEXT, file TEXT, PRIMARY KEY(file) );"
echo "CREATE TABLE files ( category TEXT, port TEXT, file TEXT);"
echo "BEGIN TRANSACTION;"

mkdir -p "$tmpdir"

cd "$portsdir"

for category in devel; do
	cd "$category" || continue
	for port in *; do
		[ -d "$port" ] || continue
		cd "$port" || continue
		export TMPPLIST="$tmpdir/tmp-plist"
		> "$TMPPLIST"
		make generate-plist >/dev/null
		make add-plist-docs >/dev/null
		make add-plist-info >/dev/null
		#make add-plist-post
		while read -r file; do
			case "$file" in
				[!@]*) echo "INSERT INTO files VALUES (\"$category\", \"$port\", \"$file\");" ;;
			esac
		done < "$TMPPLIST"
		cd ..
	done
	cd ..
done

echo "COMMIT TRANSACTION;"