1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
use strict;
use warnings;
use RT::Test tests => undef;
use Test::Warn;
my $q = RT::Test->load_or_create_queue( Name => 'General' );
ok $q && $q->id, 'loaded or created queue';
my $queue = $q->Name;
my $group;
{
$group = RT::Group->new( RT->SystemUser );
my ($id, $msg) = $group->CreateUserDefinedGroup( Name => 'Test' );
ok $id, "$msg";
}
my $root = RT::Test->load_or_create_user( Name => 'root', MemberOf => $group->id );
ok $root && $root->id;
RT::Test->create_tickets(
{ Queue => $q, },
{ Subject => '-', },
{ Subject => 'o', Owner => $root->id },
{ Subject => 'r', Requestor => $root->id },
{ Subject => 'c', Cc => $root->id },
{ Subject => 'a', AdminCc => $root->id },
);
run_tests(
'OwnerGroup = "Test"' => { '-' => 0, o => 1, r => 0, c => 0, a => 0 },
'RequestorGroup = "Test"' => { '-' => 0, o => 0, r => 1, c => 0, a => 0 },
'CCGroup = "Test"' => { '-' => 0, o => 0, r => 0, c => 1, a => 0 },
'AdminCCGroup = "Test"' => { '-' => 0, o => 0, r => 0, c => 0, a => 1 },
'WatcherGroup = "Test"' => { '-' => 0, o => 1, r => 1, c => 1, a => 1 },
);
warning_like {
my $tickets = RT::Tickets->new( RT->SystemUser );
my ($status, $msg) = $tickets->FromSQL('OwnerGroup != "Test"');
ok !$status, "incorrect op: $msg";
} qr{Invalid OwnerGroup Op: !=};
done_testing();
sub run_tests {
my @test = @_;
while ( my ($query, $checks) = splice @test, 0, 2 ) {
run_test( $query, %$checks );
}
}
sub run_test {
my ($query, %checks) = @_;
my $tix = RT::Tickets->new(RT->SystemUser);
$tix->FromSQL($query);
my $error = 0;
my $count = 0;
$count++ foreach grep $_, values %checks;
is($tix->Count, $count, "found correct number of ticket(s) by '$query'") or $error = 1;
my $good_tickets = ($tix->Count == $count);
while ( my $ticket = $tix->Next ) {
next if $checks{ $ticket->Subject };
diag $ticket->Subject ." ticket has been found when it's not expected";
$good_tickets = 0;
}
ok( $good_tickets, "all tickets are good with '$query'" ) or $error = 1;
diag "Wrong SQL query for '$query':". $tix->BuildSelectQuery if $error;
}
|
