/ 
MKDoc-SQL-0.4
/ MKDoc::SQL::IndexedTable

NAME

MKDoc::SQL::IndexedTable - Table with inverted weighted keyword searches

SUMMARY

MKDoc::SQL::IndexedTable is a subclass of MKDoc::SQL::Table, with the following difference:

The table MUST have a list of weights for the columns which need to be indexed. See new() for details.

The MKDoc::SQL::IndexedTable adds a method, fast_search(), to perform searches on the index table and quickly retrieve records.

$class->new (%arguments);

MKDoc::SQL::IndexedTable->new (
    name     => $table_name,
    pk       => [ $name1 ],
    cols     => [ { name => $name1, type => $type1 },
                  { name => $name2, type => $type2 } ],
    unique   => { $name1 => [ $col1, $col2 ] }
    index    => { $name2 => [ $col2 ] }
    fk       => { foreign_table => { source_col => target_col } }
    ai       => TRUE / FALSE

    # extra mandatory parameters
    weight   => {
        col1   =>  1,
        col2   =>  2,
        col3   =>  5
    }
);

$self->fast_search ($condition);

Searches the index table for the keywords from $query, and returns a list of results for that search.

[ $record_id, $weight ], [ $record_id, $weight ], ...