20110215024229_create_views.rb

class CreateViews < ActiveRecord::Migration

  def self.up
    create_view :departments
    create_view :employees
    create_view :employees_addresses
    create_view :employee_department_histories
    create_view :employee_pay_histories
    create_view :job_candidates
    create_view :shifts
  end

  def self.down
    drop_view :departments
    drop_view :employees
    drop_view :employees_addresses
    drop_view :employee_department_histories
    drop_view :employee_pay_histories
    drop_view :job_candidates
    drop_view :shifts
  end


  protected
  
  def self.create_view(name)
    view_file = File.join Rails.root, "db", "views", "#{name}.sql"
    view_sql = File.read(view_file)
    execute(view_sql)
  end
  
  def self.drop_view(name)
    execute "IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[HumanResources].[#{name}]')) 
             DROP VIEW [HumanResources].[#{name}]"
  end
  
end