class Scenic::Adapters::SqlServer

Attributes

connectable[R]

Public Class Methods

new(connectable = ActiveRecord::Base) click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 5
def initialize(connectable = ActiveRecord::Base)
  @connectable = connectable
end

Public Instance Methods

create_view(name, sql_definition) click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 13
def create_view(name, sql_definition)
  execute "CREATE VIEW #{quote_table_name(name)} AS #{sql_definition};"
end
drop_view(name) click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 22
def drop_view(name)
  execute "IF OBJECT_ID('#{quote_table_name(name)}') IS NOT NULL DROP VIEW #{quote_table_name(name)};"
end
update_view(name, sql) click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 17
def update_view(name, sql)
  drop_view name
  create_view name, sql
end
views() click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 9
def views
   Views.new(connection).all
end

Private Instance Methods

connection() click to toggle source
# File lib/scenic/adapters/sql_server.rb, line 49
def connection
  connectable.connection
end