Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement