Contents

class CreateActiveadminSelleoCmsSearches < ActiveRecord::Migration
  def up
    ActiveRecord::Base.connection.execute <<-SQL
    CREATE VIEW activeadmin_selleo_cms_searches AS
      SELECT
        'ActiveadminSelleoCms::Page' AS searchable_type,
        page_translations.activeadmin_selleo_cms_page_id AS searchable_id,
        coalesce(page_translations.title,'')||' '||coalesce(page_translations.browser_title,'') AS content,
        page_translations.locale
      FROM
        activeadmin_selleo_cms_page_translations page_translations

      UNION ALL

      SELECT
        'ActiveadminSelleoCms::Page' AS searchable_type,
        sections.sectionable_id AS searchable_id,
        coalesce(section_translations.body,'') AS content,
        section_translations.locale
      FROM
        activeadmin_selleo_cms_section_translations section_translations
      INNER JOIN
        activeadmin_selleo_cms_sections sections
          ON sections.id = section_translations.activeadmin_selleo_cms_section_id
    SQL
  end

  def down
    ActiveRecord::Base.connection.execute <<-SQL
      DROP VIEW activeadmin_selleo_cms_searches
    SQL
  end
end

Version data entries

53 entries across 53 versions & 1 rubygems

Version	Path
activeadmin-selleo-cms-0.0.61	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.60	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.59	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.58	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.54	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.52	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.51	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.49	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.48	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.47	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.46	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.45	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.44	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.43	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.42	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.41	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.40	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.39	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.38	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.37	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb