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.36	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.35	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.34	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.33	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.32	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.31	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.30	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.29	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.28	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.27	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.26	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.25	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.24	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.23	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.22	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.21	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.20	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.18	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.17	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.16	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb