lucky_full_text_search

TODO: Write a description here

Installation

Add the dependency to your shard.yml:

dependencies:
  lucky_full_text_search:
    github: franciscoGPS/lucky_full_text_search

Run shards install

Usage

in shards.cr
 - require "lucky_full_text_search"
in tasks.cr
 - require "lucky_full_text_search/tasks/**"

Add your multi_scope query

1.- Include the library and call the macro

  include LuckyFullTextSearch(Post)
  full_text_search("custom_scope", true, ["title", "description"])
  # Where first param is the name of the scope
  # Second is weighted boolean param, for precedense in the columns
  # Use your new query: 
  PostQuery.new.custo_scope_search

Run generator, example FOR THE new column way:

For a model Post, with title, author and content string columns

lucky add.searchable Post search_full weighted title content

There will be created a new column called "search_full" and new scope method to query for both columns used The weighted param, stands for the descendent priority in the search for the columns to be used

 title:   'A',
 content: 'B'

Will prioritize records in which the match is higher in the column A than the B

If the priority is irrelevant, then a false ignores it

lucky add.searchable Post search_full false title content

Follow the steps provided by the task when it's done.

Create the TTSVector alais
Include the library and call the macro fast_full_text_search("desc_auth_w", true, ["title", "description"])
Use the new search scope, eg:

 PostQuery.new.search_full("Lucky") #=> PostQuery instance

Next steps

In order to achieve multisearchable capacity, we could follow the approach similar to the one used PGSearch gem (<https://github.com/Casecommons/pg_search#multi-search >)

Create a table pg_search_documents

create_table :pg_search_documents do |t|
 t.text :content
 t.references :scope, index: true
 t.belongs_to :searchable, polymorphic: true, index: true
 t.timestamps null: false
end

We'll have to manage polimorphism in the crystal way For every model there should be a column for class to hold the id the record.

  def deprecated_create_polymorphic_relation
    AppDatabase.exec "
      ALTER TABLE pg_search_documents
      ADD IF NOT EXISTS #{model.downcase}_id bigint;
    "
  end