#!/bin/sh
sqlite3 "$REPOCOP_TEST_TMPDIR/tmp.db" <<EOSQL
attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
.mode tabs
create temporary table tmp1 (pkgid TEXT);
insert into tmp1 select distinct a.pkgid from rpm_files as a where filename glob '/usr/lib/menu/*';
delete from tmp1 where pkgid glob 'menu-*' or pkgid glob 'wm*' or pkgid glob 'WM*';
-- sessions menus and wm-specific menus
delete from tmp1 where pkgid glob 'kde4base-workspace-core-*' or pkgid glob 'icewm-light-*' or pkgid glob 'kdebase-wm-*' or pkgid glob 'WindowMaker-*' or pkgid glob 'fvwm-base-*' or pkgid glob 'fluxbox-*' or pkgid glob 'speyes' or pkgid glob 'fbpager';

.output $REPOCOP_TEST_TMPDIR/msg
select pkgid from tmp1;
EOSQL
for i in `cat $REPOCOP_TEST_TMPDIR/msg`; do repocop-test-warn -k $i "package contains deprecated /usr/lib/menu/ files. Please, convert to .desktop files"; done
rm $REPOCOP_TEST_TMPDIR/*
