#!/bin/sh
sqlite3 "$REPOCOP_TEST_TMPDIR/tmp.db" <<EOSQL
attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
.mode tabs
.output $REPOCOP_TEST_TMPDIR/warn
select distinct pkgid from rpm_files where filename glob '/usr/share/gnome/apps/*';
EOSQL
cat > $REPOCOP_TEST_TMPDIR/repocop.awk <<'EOF'
BEGIN {FS="\t"}
// {system("repocop-test-warn -k " $1 " '" $2 ": This .desktop file in an obsolete directory. According to the menu-spec draft on freedesktop.org, those .desktop files that are intended to create a menu should be placed in <tt>/usr/share/applications</tt>, not <tt>/usr/share/gnome/apps</tt>'")}
EOF
cat $REPOCOP_TEST_TMPDIR/warn | awk -f $REPOCOP_TEST_TMPDIR/repocop.awk
rm $REPOCOP_TEST_TMPDIR/*
