#!/bin/sh
sqlite3 "$REPOCOP_TEST_TMPDIR/tmp.db" <<EOSQL
attach database '$REPOCOP_TEST_DBDIR/rpm.db' as rpm;
.mode tabs
CREATE TEMPORARY TABLE t1(PKGID TEXT);
insert into t1 select pkgid from RPM where (PKGID glob 'ispell-*' or PKGID glob 'aspell-*' or PKGID glob 'hunspell-*' or PKGID glob 'mythes-*' or PKGID glob 'hyphen-*' ) and RPMGROUP <> 'Text tools';
DELETE FROM t1 WHERE PKGID glob 'hunspell-util*' or PKGID glob '*-debuginfo-*';
.output $REPOCOP_TEST_TMPDIR/msg
select pkgid from t1;
EOSQL
for i in `cat $REPOCOP_TEST_TMPDIR/msg`; do repocop-test-info -k $i "RPM group should be 'Text tools'." ; done
rm $REPOCOP_TEST_TMPDIR/*
