Ergo Project

To extract from the Koji database, which packages have failed building with mock exiting with status code 10 (build requirements not met):

$ for taskid in `echo "select id from task where result like '%exited with status 10;%';" | psql`; do
        echo "select package.name from build inner join package on build.pkg_id = package.id where build.task_id='$taskid';" | psql 2>/dev/null
    done | grep -vE "(^-|^\(|name\s*\$|^$)"