Catmandu::Store::MongoDB::CQL

NAME

Catmandu::Store::MongoDB::CQL - Converts a CQL query string to a MongoDB query string

SYNOPSIS

    $mongo_query = Catmandu::Store::ElasticSearch::CQL
                    ->new(mapping => $cql_mapping)
                    ->parse($cql_query_string);

DESCRIPTION

This package currently parses most of CQL 1.1:

    and
    or
    not
    srw.allRecords
    srw.serverChoice
    srw.anywhere
    cql.allRecords
    cql.serverChoice
    cql.anywhere
    =
    scr
    <
    >
    <=
    >=
    <>
    exact
    all
    any
    within

See <https://www.loc.gov/standards/sru/cql/spec.html> for more information on the CQL query language.

LIMITATIONS

MongoDB is not a full-text search engine. All queries will try to find exact matches in the database, except for the 'any' and 'all' relations which will translate queries into wildcard queries (which are slow!):

   title any 'funny cats'

will be treated internally as something like:

    title : { $regex : /funny/ } OR title : { $regex : /cats/ }

And,

    title all 'funny cats'

as

    title : { $regex : /funny/ } AND title : { $regex : /cats/ }

This makes the 'any' and 'all' not as efficient (fast) as exact matches '==','exact'.

METHODS

parse

Parses the given CQL query string with CQL::Parser and converts it to a Mongo query string.

visit

Converts the given CQL::Node to a Mongo query string.

REMARKS

no support for fuzzy search, search modifiers, sortBy and encloses

SEE ALSO

CQL::Parser.