josevalim

# In your test_helper.rb
class ActiveRecord::Base
  mattr_accessor :shared_connection
  @@shared_connection = nil

  def self.connection
    @@shared_connection || retrieve_connection
  end
end

luislavena

# before tasks/rails

require "rake/exceptional"

romansklenar

# db/migrate/20131118172653_create_transactional_items_view.rb
class CreateTransactionalItemsView < ActiveRecord::Migration
  def up
    select_sql = File.open("#{Rails.root}/db/migrate/20131118172653_create_transactional_items_view.sql", 'r') { |f| f.read } 
    
    # for materialized view:
    view_sql = "CREATE MATERIALIZED VIEW transactional_items AS (#{select_sql})"
    # for normal view:
    view_sql = "CREATE VIEW transactional_items AS (#{select_sql})"