Laurent Dami > DBD-SQLite-FTS3Transitional > DBD::SQLite::FTS3Transitional

Download:
DBD-SQLite-FTS3Transitional-1.00.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 1.00   Source  

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.

syntax highlighting: