/ 
DBD-SQLite-FTS3Transitional-1.00
River stage zero No dependents
/ DBD::SQLite::FTS3Transitional

NAME

DBD::SQLite::FTS3Transitional - helper function for migrating FTS3 applications

SYNOPSIS

use DBD::SQLite::FTS3Transitional qw/fts3_convert/;
my $new_match_syntax = fts3_convert($old_match_syntax);
my $sql = "SELECT ... FROM ... WHERE col MATCH $new_match_syntax";

DESCRIPTION

Starting from version 1.31, DBD::SQLite uses the new, recommended "Enhanced Query Syntax" for binary set operators in fulltext FTS3 queries (AND, OR, NOT, possibly nested with parenthesis).

Previous versions of DBD::SQLite used the "Standard Query Syntax" (see http://www.sqlite.org/fts3.html#section_3_2). Applications built with the old "Standard Query" syntax, have to be migrated, because the precedence of the OR operator has changed.

This module helps in the migration process : it provides a function to automatically translate from old to new syntax.

FUNCTIONS

fts3_convert

Takes as input a string for the MATCH clause in a FTS3 fulltext search; returns the same clause rewritten in new, "Extended" syntax.

AUTHOR

Laurent Dami <dami@cpan.org>

COPYRIGHT

Copyright 2010 Laurent Dami.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.

NAME

DBD::SQLite::FTS3Transitional - The great new DBD::SQLite::FTS3Transitional!

VERSION

Version 0.01

SYNOPSIS

Quick summary of what the module does.

Perhaps a little code snippet.

use DBD::SQLite::FTS3Transitional;

my $foo = DBD::SQLite::FTS3Transitional->new();
...

EXPORT

A list of functions that can be exported. You can delete this section if you don't export anything, such as for a purely object-oriented module.

SUBROUTINES/METHODS

function1

function2

AUTHOR

Laurent Dami, <dami at cpan.org>

BUGS

Please report any bugs or feature requests to bug-dbd-sqlite-fts3transitional at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBD-SQLite-FTS3Transitional. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc DBD::SQLite::FTS3Transitional

You can also look for information at:

ACKNOWLEDGEMENTS

LICENSE AND COPYRIGHT

Copyright 2010 Laurent Dami.

This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.

See http://dev.perl.org/licenses/ for more information.