#!/bin/sh
sqlite3 "$REPOCOP_TEST_DBDIR/freedesktop-desktop.db" <<EOSQL
-- # attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
.mode tabs
.output $REPOCOP_TEST_TMPDIR/msg
select pkgid,DESKTOPDIR,DESKTOPFILE from freedesktop_desktop where desktoptype='ServiceType' and DESKTOPDIR not glob '/usr/share/servicetypes*' and DESKTOPDIR not glob '/usr/share/kde*/servicetypes*' and DESKTOPDIR not glob '/usr/share/apps*';
EOSQL
perl -ne 'chomp;@a=split /\t/;system("repocop-test-warn", "-k", $a[0], "$a[1]/$a[2] has Type=ServiceType and should be placed under /usr/share/servicetypes.")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/msg
