#!/bin/sh
cat > "$REPOCOP_TEST_TMPDIR/tmp.sql" <<EOSQL
CREATE TEMPORARY TABLE BAD_BUILDREQ (pkgid TEXT, buildrequirename TEXT);
INSERT INTO BAD_BUILDREQ select a.pkgid, buildrequirename from rpm_buildrequires as a left join rpm_provides as b on BUILDREQUIRENAME = b.PROVIDENAME where substr(buildrequirename,1,1)<>'/' and buildrequirename not glob '*(*)' and (PROVIDENAME is not NULL) GROUP BY BUILDREQUIRENAME having MAX(rpm_compare_op_evr_evr(BUILDREQUIREFLAG,BUILDREQUIREVERSION,PROVIDEVERSION))=0;
EOSQL
MISSINGPKG="$REPOCOP_STATEDIR/_archdiff/missing"
if [ -e "$MISSINGPKG" ]; then
    echo -n "DELETE FROM BAD_BUILDREQ WHERE buildrequirename IN ('" >> "$REPOCOP_TEST_TMPDIR/tmp.sql"
    perl -e 'my @out;while (<>) {chomp;push @out, $_};print join (q!'"'"','"'"'!,@out);' "$MISSINGPKG" >> "$REPOCOP_TEST_TMPDIR/tmp.sql"
    echo "');" >> "$REPOCOP_TEST_TMPDIR/tmp.sql"
fi

cat >> "$REPOCOP_TEST_TMPDIR/tmp.sql" <<EOSQL
.mode tabs
.output $REPOCOP_TEST_TMPDIR/msg
select pkgid, buildrequirename from BAD_BUILDREQ;
EOSQL
repocop-sqlite "$REPOCOP_DISTROTEST_DBDIR/rpm.db" < "$REPOCOP_TEST_TMPDIR/tmp.sql"
perl -ne 'chomp;@a=split /\t/;system("repocop-test-fail", "-k", $a[0], "build dependency $a[1] has no suitable version.")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
