GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SEARCH::INVERTEDINDEX::DB::MYSQL (3)

.ds Aq ’

NAME

Search::InvertedIndex::DB::Mysql - A MySQL database interface object for Search::InvertedIndex

CONTENTS

SYNOPSIS



  use Search::InvertedIndex::DB::Mysql;

  my $db = Search::InvertedIndex::DB::Mysql->new({
              -db_name => searchdb,
             -hostname => db.domain.com,
             -username => dbuser,
             -password => dbuserpw,
           -table_name => indextablename,
            -lock_mode => EX });

  my $inv_map = Search::InvertedIndex->new({ -database => $db });

  my $query = Search::InvertedIndex::Query->new(...);
  my $result = $inv_map->search({ -query => $query });

  my $update = Search::InvertedIndex::Update->new(...);
  my $result = $inv_map->update({ -update => $update });

  $inv_map->close;



DESCRIPTION

An interface allowing Search::InvertedIndex to store and retrieve data from Mysql database tables. All of the data is stored in a single table, which will be created automatically if it does not exist when the new method is called.

The new method takes up to six parameters, two of which are required.
-db_name Mysql database name. Required.
-table_name Table within the database to use. *CAUTION* If this table exists, the clear method will erase the contents WITHOUT verifying that the table contains data the module understands. If you point the module to an existing table you do so at your own risk! Required.
-hostname Mysql database host. Default: database server is on the local machine.
-username User for connecting to the Mysql server. The user must have appropriate authority for the operations you are performing or Mysql may complain. Default: none.
-password Password for the User. Default: none.
-lock_mode Locking status for the database table. EX, SH, or UN. EX will attempt to obtain a WRITE lock on the table, SH a READ lock, and UN will not request one at all. Tables may be created and modified in any mode, but EX is obviously recommended.

CHANGES



 1.00 2000.11.28 - First version.



COPYRIGHT

This software may be copied or redistributed under the same terms as Perl itelf.

AUTHOR

Michael Cramer <cramer@webkist.com>, based on Search::InvertedIndex::DB::DB_File_SplitHash by Benjamin Franz.

NOTES

This module is not tested during installation due to its need for MySQL support in Perl and associated access permissions and so on.

You *MUST* have the DBI and DBD::mysql modules installed to be able to use this module.

Theoretically, someone could use this module as a starting point for creating support for all kinds of DBI supported databases.

SEE ALSO

Search::InvertedIndex Search::InvertedIndex::DB::DB_File_SplitHash DBI DBD::mysql
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 SEARCH::INVERTEDINDEX::DB::MYSQL (3) 2003-11-14

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.