#!/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 distinct pkgid, desktopfile from freedesktop_desktop_mimetypes LEFT JOIN freedesktop_desktop ON freedesktop_desktop_mimetypes.desktopid=freedesktop_desktop.desktopid WHERE desktopdir glob '/usr/share/applications/*' AND appexec not glob '*[ ="'']%[fuFU]*';
EOSQL
perl -ne 'chomp;@a=split /\t/;system("repocop-test-warn", "-k", $a[0], $a[1].q{: found MimeType= entry, but to handle it properly you have to declare one of %f,%F,%u,%U in Exec= entry. Note that %m is deprecated. See http://standards.freedesktop.org/desktop-entry-spec/desktop-entry-spec-1.0.html#exec-variables}) if $a[0]' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
