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.14	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.13	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.12	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.11	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.10	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.9	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.8	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.7	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.6	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.5	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.4	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.3	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.2	db/migrate/20121221164723_create_activeadmin_selleo_cms_searches.rb