#!/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, filename TEXT);
insert into tmp1 select distinct a.pkgid, a.filename from rpm_files as a where filename glob '/usr/share/PolicyKit/*';
-- delete from tmp1 where pkgid glob 'menu-*' or pkgid glob 'wm*' or pkgid glob 'WM*';
.output $REPOCOP_TEST_TMPDIR/msg
select pkgid, filename from tmp1;
EOSQL
perl -ne 'chomp;@a=split /\t/;system(qw/repocop-test-fail -k/,$a[0], "Invalid path for PolicyKit: $a[1]. Should be in /usr/share/polkit-1/actions/.")' $REPOCOP_TEST_TMPDIR/msg
rm $REPOCOP_TEST_TMPDIR/*
