#!/bin/sh
sqlite3 "$REPOCOP_TEST_TMPDIR/tmp.db" <<EOSQL
attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
CREATE TEMPORARY TABLE texmf (tpkgid TXT);
CREATE TEMPORARY TABLE br (bpkgid TXT);
INSERT INTO br SELECT DISTINCT pkgid FROM rpm_buildrequires WHERE buildrequirename = 'rpm-build-texmf';
INSERT INTO texmf SELECT DISTINCT pkgid FROM rpm_files WHERE filename glob '/usr/share/texmf/*' AND NOT filename glob '/usr/share/texmf/doc/*' AND NOT filename glob '/usr/share/texmf/source/*';
DELETE FROM texmf WHERE tpkgid glob 'tex-common-*';
.mode tabs
.output $REPOCOP_TEST_TMPDIR/msg
SELECT DISTINCT sourceid FROM texmf LEFT JOIN rpm ON tpkgid=pkgid WHERE NOT sourceid IN (SELECT bpkgid FROM br WHERE bpkgid=sourceid);
DROP TABLE texmf;
DROP TABLE br;
EOSQL
perl -ne 'chomp;@a=split /\t/;system(qw/repocop-test-warn -k/,$a[0], "According to TeX policy (http://www.altlinux.org/TeXPolicy) packages that install files to /usr/share/texmf should BuildRequires(pre): rpm-build-texmf for the dependency magic to work.")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
