Class: FullTextSearch

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/bumble/templates/migrations/full_text_search.rb

Class Method Summary collapse

Class Method Details

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
 
# File 'lib/generators/bumble/templates/migrations/full_text_search.rb', line 2

def self.up
    ActiveRecord::Base.connection.execute(<<-'eosql')
      DROP index IF EXISTS posts_fts_idx
    eosql
    ActiveRecord::Base.connection.execute(<<-'eosql')
              CREATE index posts_fts_idx
      ON posts
      USING gin((to_tsvector('english', coalesce(posts.title, '') || ' ' || coalesce(posts.link_url, '') || ' ' || coalesce(posts.image_url, '') || ' ' || coalesce(posts.video_embed, '') || ' ' || coalesce(posts.description, '') || ' ' || coalesce(posts.quote, '') || ' ' || coalesce(posts.permalink, '') || ' ' || coalesce(posts.via, ''))))

    eosql
end