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