#!/bin/sh
sqlite3 "$REPOCOP_TEST_DBDIR/rpmbuild-files-req-list.db" <<EOSQL
attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
.mode tabs
-- select distinct rpm_files.pkgid, FILEREQDIR, FILEREQNAME from rpm_files LEFT JOIN rpm ON rpm_files.pkgid = rpm.pkgid, RPMBUILDFILESREQLIST where filename=FILEREQDIR and FILEREQNAME <> NAME;
CREATE TEMPORARY TABLE DIR_INTERSECTION (pkgid TEXT, REQDIR TEXT, REQNAME TEXT);
INSERT INTO DIR_INTERSECTION select distinct rpm_files.pkgid, FILEREQDIR, FILEREQNAME from rpm_files, RPMBUILDFILESREQLIST where filename=FILEREQDIR;
CREATE INDEX IF NOT EXISTS dir_intersection_IDX_NAME ON dir_intersection(pkgid);
.output $REPOCOP_TEST_TMPDIR/msg
select distinct DIR_INTERSECTION.pkgid, REQDIR, REQNAME from DIR_INTERSECTION LEFT JOIN rpm ON DIR_INTERSECTION.pkgid = rpm.pkgid where REQNAME <> NAME;
DROP TABLE DIR_INTERSECTION;
EOSQL
perl -ne 'chomp;@a=split /\t/;system(qq{repocop-test-warn -k $a[0] "sisyphus_check --check-dirlist failed: package contains a directory $a[1] that exclusively belongs to package $a[2]"})' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
