bash koji

WORKDIR="/tmp"
SQLFILE=$1.sql
cat > $WORKDIR/$SQLFILE << EOF
delete from tag_listing where build_id in (select id from build where pkg_id in (select id from package where name = '$1'));
delete from rpmsigs where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = '$1')));
delete from buildroot_listing where rpm_id in (select id from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = '$1')));
delete from rpminfo where build_id in (select id from build where pkg_id in (select id from package where name = '$1'));
delete from build where pkg_id = (select id from package where name = '$1');
delete from tag_packages where package_id = (select id from package where name = '$1');
delete from package where name = '$1';
EOF

su - koji -c  "psql koji < $WORKDIR/$SQLFILE"

# remove old package directory otherwise koji failed
rm -rf /mnt/koji/hub/packages/$1/