#!/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
-- note: 64 is RPMFILE_GHOST (1 << 6)
select rpm_files.pkgid, FILENAME, altlinux_alternatives.pkgid from altlinux_alternatives, rpm_files WHERE ALTALTERNATIVE=FILENAME and FILEFLAG & 64 > 0;
EOSQL
perl -ne 'chomp;@a=split /\t/;system("repocop-test-info -k $a[0] Since alternatives 0.4 the practice to own alternative symlinks as ghost files is deprecated. the ghost file $a[1] is an alternative in package $a[2]. Consider removing the ghost file $a[1].")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
