5 use RT::Test tests => undef;
6 plan skip_all => 'Not mysql' unless RT->Config->Get('DatabaseType') eq 'mysql';
8 RT->Config->Set( FullTextSearch => Enable => 1, Indexed => 1, Table => 'AttachmentsIndex' );
12 my $q = RT::Test->load_or_create_queue( Name => 'General' );
13 ok $q && $q->id, 'loaded or created queue';
19 command => $RT::SbinPath .'/rt-setup-fulltext-index',
20 dba => $ENV{'RT_DBA_USER'},
21 'dba-password' => $ENV{'RT_DBA_PASSWORD'},
23 my ($exit_code, $output) = RT::Test->run_and_capture( %args );
24 ok(!$exit_code, "setted up index") or diag "output: $output";
29 command => $RT::SbinPath .'/rt-fulltext-indexer',
31 my ($exit_code, $output) = RT::Test->run_and_capture( %args );
32 ok(!$exit_code, "setted up index") or diag "output: $output";
37 while ( my ($query, $checks) = splice @test, 0, 2 ) {
38 run_test( $query, %$checks );
44 my ($query, %checks) = @_;
45 my $query_prefix = join ' OR ', map 'id = '. $_->id, @tickets;
47 my $tix = RT::Tickets->new(RT->SystemUser);
48 $tix->FromSQL( "( $query_prefix ) AND ( $query )" );
53 $count++ foreach grep $_, values %checks;
54 is($tix->Count, $count, "found correct number of ticket(s) by '$query'") or $error = 1;
56 my $good_tickets = ($tix->Count == $count);
57 while ( my $ticket = $tix->Next ) {
58 next if $checks{ $ticket->Subject };
59 diag $ticket->Subject ." ticket has been found when it's not expected";
62 ok( $good_tickets, "all tickets are good with '$query'" ) or $error = 1;
64 diag "Wrong SQL query for '$query':". $tix->BuildSelectQuery if $error;
67 @tickets = RT::Test->create_tickets(
69 { Subject => 'first', Content => 'english' },
70 { Subject => 'second', Content => 'french' },
71 { Subject => 'third', Content => 'spanish' },
72 { Subject => 'fourth', Content => 'german' },
77 "Content LIKE 'english'" => { first => 1, second => 0, third => 0, fourth => 0 },
78 "Content LIKE 'french'" => { first => 0, second => 1, third => 0, fourth => 0 },