Class: Scenic::Adapters::SqlServer

Inherits:
Object
  • Object
show all
Defined in:
lib/scenic/adapters/sql_server.rb,
lib/scenic/adapters/sql_server/views.rb

Defined Under Namespace

Classes: NotSupportedError, Views

Instance Method Summary collapse

Constructor Details

#initialize(connectable = ActiveRecord::Base) ⇒ SqlServer

Returns a new instance of SqlServer.



5
6
7
 
# File 'lib/scenic/adapters/sql_server.rb', line 5

def initialize(connectable = ActiveRecord::Base)
  @connectable = connectable
end

Instance Method Details

#create_view(name, sql_definition) ⇒ Object 



13
14
15
 
# 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) ⇒ Object 



22
23
24
 
# File 'lib/scenic/adapters/sql_server.rb', line 22

def drop_view(name)
  execute "DROP VIEW IF EXISTS #{quote_table_name(name)};"
end

#update_view(name, sql) ⇒ Object 



17
18
19
20
 
# File 'lib/scenic/adapters/sql_server.rb', line 17

def update_view(name, sql)
  drop_view name
  create_view name, sql
end

#views ⇒ Object 



9
10
11
 
# File 'lib/scenic/adapters/sql_server.rb', line 9

def views
   Views.new(connection).all
end