Sha256: 1060503e1ab968cf512d0723f26db8dd06f254cf1f676b6bee16e4fa852b4d45

Contents?: true

Size: 1.24 KB

Versions: 49

Compression:

Stored size: 1.24 KB

Contents

class ChangeActiveadminSelleoCmsSearches < ActiveRecord::Migration
  def up
    ActiveRecord::Base.connection.execute <<-SQL
      DROP VIEW activeadmin_selleo_cms_searches
    SQL
    ActiveRecord::Base.connection.execute <<-SQL
    CREATE VIEW activeadmin_selleo_cms_searches AS
      SELECT
        'ActiveadminSelleoCms::Page' AS searchable_type,
        pages.id AS searchable_id,
        pages.is_published ,
        page_translations.locale,
        coalesce(string_agg(page_translations.title, ' '), '')||' '||coalesce(string_agg(section_translations.body, ' '), '') as content
      FROM
        activeadmin_selleo_cms_pages pages
      INNER JOIN
        activeadmin_selleo_cms_page_translations page_translations ON page_translations.activeadmin_selleo_cms_page_id = pages.id
      LEFT JOIN
        activeadmin_selleo_cms_sections sections ON sections.sectionable_id = pages.id AND sections.sectionable_type = 'ActiveadminSelleoCms::Page'
      LEFT JOIN
        activeadmin_selleo_cms_section_translations section_translations ON section_translations.activeadmin_selleo_cms_section_id = sections.id AND section_translations.locale = page_translations.locale
      GROUP BY
        pages.id, page_translations.locale
    SQL
  end

  def down
  end
end

Version data entries

49 entries across 37 versions & 1 rubygems

Version Path
activeadmin-selleo-cms-0.0.61 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.61 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.60 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.60 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.59 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.59 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.58 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.58 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.54 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.54 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.52 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.52 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.51 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.51 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.49 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.49 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.48 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.48 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.47 spec/dummy/db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb
activeadmin-selleo-cms-0.0.47 db/migrate/20130206173233_change_activeadmin_selleo_cms_searches.rb