ActiveRecord concern for MSSQL views

view_object.rb

# Usage:
#
#     class SomeView < ActiveRecord::Base
#       include ViewObject
#     end
#
#     SomeView.view_sql #=> prints out MsSQL view SQL statement
module ViewObject
  extend ActiveSupport::Concern

  included do
    self.primary_key = nil
  end

  def readonly?
    true
  end

  module ClassMethods
    def view_sql
      @view_sql ||= self.connection.select_one("SELECT VIEW_DEFINITION as view_definition FROM INFORMATION_SCHEMA.Views WHERE TABLE_NAME = N'#{self.table_name}'")['view_definition']
    end
  end
end