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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;
use DBIx::FullTextSearch;
use vars qw! $q $dbh !;
$q = new CGI;
print $q->header('text/html');
print $q->start_html;
print "<H1>DBIx::FullTextSearch Administration</H1>\n";
print $q->dump;
if (defined $q->param('dsn')) {
my $dsn = $q->param('dsn');
my $user = $q->param('user');
my $password = $q->param('password');
$dbh = DBI->connect($dsn, $user, $password, {
'RaiseError' => 0, 'PrintError' => 1,
});
if (defined $dbh and defined $q->param('test_connect')) {
print $q->pre("Connect was successfull."), "\n";
}
if (not defined $dbh) {
print $q->pre("Connect failed:\n$DBI::errstr."), "\n";
offer_dbi_connect();
exit;
}
my $tables = $dbh->selectall_arrayref('show tables');
my %possible_indexes = map { ( $_->[0] => 1 ) } @$tables
if defined $tables;
for my $table (keys %possible_indexes) {
local $dbh->{'PrintError'} = 0;
unless ($dbh->selectrow_array(
"select 1 from $table where param = 'data_table'")) {
delete $possible_indexes{$table};
}
}
my @tables = sort keys %possible_indexes;
if (@tables) {
print "Select existing DBIx::FullTextSearch index to work with:\n",
$q->start_form,
$q->scrolling_list('index_name', \@tables),
$q->br,
$q->submit('test_index', 'Select index'),
$q->hidden('dsn'), $q->hidden('user'),
$q->hidden('password'),
$q->end_form;
}
else {
print "No existing DBIx::FullTextSearch index was found.\n";
}
my $myself = $q->url('-relative' => 1);
print $q->hr, "\n",
$q->a({'href' => $myself}, 'Change database connection'), "\n";
}
else {
offer_dbi_connect();
}
if (defined $q->param('index_name')) {
my $fts_name = $q->param('index_name');
my $fts = DBIx::FullTextSearch->open($dbh, $fts_name);
if (defined $fts and defined $q->param('test_index')) {
print $q->pre("DBIx::FullTextSearch index $fts_name loaded OK.\n");
}
if (not defined $fts) {
print $q->pre("Loading DBIx::FullTextSearch index $fts_name failed: $DBIx::FullTextSearch::errstr.\n");
exit;
}
use Data::Dumper;
print '<PRE>', Dumper($fts), "</PRE>\n";
if (defined $q->param('search')) {
my $search = $q->param('search');
my @documents = $fts->contains($search);
print "Documents containing string `$search' are @documents.<P>\n";
}
elsif (defined $q->param('esearch')) {
my $search = $q->param('esearch');
my @documents = $fts->econtains(split /\s+/, $search);
print "Documents matching expression `$search' are @documents.<P>\n";
}
print $q->start_form,
$q->hidden('dsn'), $q->hidden('user'),
$q->hidden('password'), $q->hidden('index_name'),
$q->textfield('search'), $q->submit('Search in index'),
$q->end_form, "<P>\n";
print $q->start_form,
$q->hidden('dsn'), $q->hidden('user'),
$q->hidden('password'), $q->hidden('index_name'),
$q->textfield('esearch'), $q->submit('Search in index (extended)'),
$q->end_form, "<P>\n";
}
sub offer_dbi_connect {
print "Please specify the DBI connect string, the user and
password info for the database connection:\n";
print $q->start_form,
$q->table(
$q->Tr( $q->td("DBI connect"),
$q->td($q->textfield('dsn', 'dbi:mysql:test'))
), "\n",
$q->Tr( $q->td("Database user"),
$q->td($q->textfield('user', 'test'))
), "\n",
$q->Tr( $q->td("Password"),
$q->td($q->password_field('password', 'test'))
), "\n",
),
$q->submit('test_connect', 'Test connection'),
$q->end_form;
}
END { print $q->end_html; }
END { $dbh->disconnect if defined $dbh; }
|
