#!/bin/sh
#--select rpm_files.pkgid, group_concat(FILENAME), group_concat(altlinux_alternatives.pkgid) from altlinux_alternatives, rpm_files WHERE ALTALTERNATIVE=FILENAME GROUP BY rpm_files.pkgid;
sqlite3 "$REPOCOP_DISTROTEST_DBDIR/altlinux-alternatives.db" <<EOSQL
attach database '$REPOCOP_DISTROTEST_DBDIR/rpm.db' as rpm;
.mode tabs
.output $REPOCOP_TEST_TMPDIR/msg
select a.pkgid, a.ALTALTERNATIVE, b.pkgid from altlinux_alternatives as a, altlinux_alternatives as b where a.ALTISMASTER=0 and b.ALTISMASTER=1 and a.ALTALTERNATIVE = b.ALTALTERNATIVE and a.pkgid <> b.pkgid;
EOSQL
perl -ne 'chomp;@a=split /\t/;system("repocop-test-fail -k $a[0] slave alternative $a[1] is already registered as a master in package: $a[2]")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/msg
