4 use RT::Test tests => undef;
8 my $q = RT::Test->load_or_create_queue( Name => 'General' );
9 ok $q && $q->id, 'loaded or created queue';
15 $group = RT::Group->new( RT->SystemUser );
16 my ($id, $msg) = $group->CreateUserDefinedGroup( Name => 'Test' );
20 my $root = RT::Test->load_or_create_user( Name => 'root', MemberOf => $group->id );
21 ok $root && $root->id;
23 RT::Test->create_tickets(
26 { Subject => 'o', Owner => $root->id },
27 { Subject => 'r', Requestor => $root->id },
28 { Subject => 'c', Cc => $root->id },
29 { Subject => 'a', AdminCc => $root->id },
33 'OwnerGroup = "Test"' => { '-' => 0, o => 1, r => 0, c => 0, a => 0 },
34 'RequestorGroup = "Test"' => { '-' => 0, o => 0, r => 1, c => 0, a => 0 },
35 'CCGroup = "Test"' => { '-' => 0, o => 0, r => 0, c => 1, a => 0 },
36 'AdminCCGroup = "Test"' => { '-' => 0, o => 0, r => 0, c => 0, a => 1 },
37 'WatcherGroup = "Test"' => { '-' => 0, o => 1, r => 1, c => 1, a => 1 },
41 my $tickets = RT::Tickets->new( RT->SystemUser );
42 my ($status, $msg) = $tickets->FromSQL('OwnerGroup != "Test"');
43 ok !$status, "incorrect op: $msg";
44 } qr{Invalid OwnerGroup Op: !=};
50 while ( my ($query, $checks) = splice @test, 0, 2 ) {
51 run_test( $query, %$checks );
56 my ($query, %checks) = @_;
58 my $tix = RT::Tickets->new(RT->SystemUser);
59 $tix->FromSQL($query);
63 $count++ foreach grep $_, values %checks;
64 is($tix->Count, $count, "found correct number of ticket(s) by '$query'") or $error = 1;
66 my $good_tickets = ($tix->Count == $count);
67 while ( my $ticket = $tix->Next ) {
68 next if $checks{ $ticket->Subject };
69 diag $ticket->Subject ." ticket has been found when it's not expected";
72 ok( $good_tickets, "all tickets are good with '$query'" ) or $error = 1;
74 diag "Wrong SQL query for '$query':". $tix->BuildSelectQuery if $error;