30 lines
824 B
Ruby
30 lines
824 B
Ruby
|
# frozen_string_literal: true
|
||
|
|
|
||
|
|
# Para no estar calculando todo el tiempo el diccionario del idioma,
|
||
|
|
# agregamos una columna más.
|
||
|
|
class AddDictionaryToIndexedPosts < ActiveRecord::Migration[6.1]
|
||
|
|
LOCALES = {
|
||
|
|
'english' => 'en',
|
||
|
|
'spanish' => 'es'
|
||
|
|
}
|
||
|
|
|
||
|
|
def up
|
||
|
|
add_column :indexed_posts, :dictionary, :string
|
||
|
|
|
||
|
|
create_trigger(compatibility: 1).on(:indexed_posts).before(:insert, :update) do
|
||
|
|
"new.indexed_content := to_tsvector(('pg_catalog.' || new.dictionary)::regconfig, coalesce(new.title, '') || '\n' || coalesce(new.content,''));"
|
||
|
|
end
|
||
|
|
|
||
|
|
IndexedPost.find_each do |post|
|
||
|
|
locale = post.locale
|
||
|
|
|
||
|
|
post.update dictionary: locale, locale: LOCALES[locale]
|
||
|
|
end
|
||
|
|
end
|
||
|
|
|
||
|
|
def down
|
||
|
|
remove_column :indexed_posts, :locale
|
||
|
|
rename_column :indexed_posts, :dictionary, :locale
|
||
|
|
end
|
||
|
|
end
|