README
1$Header: /cvsroot/TextQuery/Text-Query-SQL/README,v 1.4 2000/03/21 14:10:48 benj2 Exp $
2
3The Text-Query-SQL home page is http://www.senga.org/Text-Query-SQL/
4
5What is it ?
6------------
7
8Text-Query-SQL is derived from the Text-Query module.
9What is Text-Query then ? It is a general purpose query
10parser and resolver. It is able to parse the AltaVista 'simple
11query' and 'advanced query' syntax. The resulting syntax tree
12is then used to build a search query that depends on the
13database used.
14
15Text-Query-SQL provides query builders for
16SQL databases. Searching 'foo and bar' will retrieve rows containing
17the words foo and bar. It does it by generating the appropriate SQL
18request.
19
20At present Text-Query-SQL only supports MySQL and Fulcrum's
21SearchServer but one could easily add support for any other database
22(see DATABASE file), the module was architectured to make this easy.
23
24Where is the documentation ?
25----------------------------
26
27See the following manual pages : Text::Query::BuildSQL(3),
28Text::Query::BuildSQLFulcrum(3), Text::Query::BuildSQLMySQL(3),
29Text::Query::BuildSQLPg(3), Text::Query::SolveSQL(3)
30
31How to install it ?
32-------------------
33
34perl -MCPAN -e 'install Bundle::Text::Query::BuildSQL'
35
36And if you want to do it by hand
37
38gtar -zxvf Text-Query-SQL-*.tar.gz
39
40cd Text-Query-SQL-*[0-9]
41
42perl Makefile.PL
43
44make all
45
46make test
47
48If you want to run tests that create a table and exercise search expressions on it
49you should try the following:
50
51For MySQL:
52
53DBI_DSN=dbi:mysql:mysql DBI_USER=user DBI_PASS=passpass make TEST_FILES=t/04mysql.t test
54
55For Fulcrum:
56
57FULCRUM_HOME=/opt/fulcrum FULCREATE=/tmp FULSEARCH=/opt/fulcrum/fultext:/tmp \
58 DBI_DSN=dbi:SearchServer: DBI_USER='' DBI_PASS='' \
59 make TEST_FILES=t/02fulcrum.t test
60
61For PostgreSQL:
62
63DBI_DSN=dbi:Pg:dbname=test DBI_USER=user DBI_PASS=pass make TEST_FILES=t/06Pg.t test
64
65make install
66
67Where can I download it ?
68-------------------------
69
70The Text-Query-SQL home page is http://www.senga.org/Text-Query-SQL/
71
72Loic Dachary
73loic@senga.org
74http://www.senga.org/
75
README.fulcrum
README.mysql
1Short example for installing Msql-Mysql-modules-1.2017 :
2
3MYSQL_HOME=/usr IN_MYSQL_DISTRIBUTION=1 \
4 DBI_DB=mysql DBI_DSN=dbi:mysql:mysql DBI_USER=root DBI_PASS=passpass \
5 perl Makefile.PL
6make all
7make install
8
README.pg