Class: ActiveRecord::ConnectionAdapters::SQLServerAdapter
- Inherits:
-
Object
- Object
- ActiveRecord::ConnectionAdapters::SQLServerAdapter
- Defined in:
- lib/rails_sql_views/connection_adapters/sqlserver_adapter.rb
Instance Method Summary collapse
-
#supports_views? ⇒ Boolean
Returns true as this adapter supports views.
-
#view_select_statement(view, name = nil) ⇒ Object
Get the view select statement for the specified view.
-
#views(name = nil) ⇒ Object
Returns all the view names from the currently connected schema.
Instance Method Details
#supports_views? ⇒ Boolean
Returns true as this adapter supports views.
5 6 7 |
# File 'lib/rails_sql_views/connection_adapters/sqlserver_adapter.rb', line 5 def supports_views? true end |
#view_select_statement(view, name = nil) ⇒ Object
Get the view select statement for the specified view.
15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
# File 'lib/rails_sql_views/connection_adapters/sqlserver_adapter.rb', line 15 def view_select_statement(view, name=nil) q =<<-ENDSQL SELECT view_definition FROM information_schema.views WHERE table_name = '#{view}' ENDSQL view_def = select_value(q, name) if view_def return convert_statement(view_def) else raise "No view called #{view} found" end end |
#views(name = nil) ⇒ Object
Returns all the view names from the currently connected schema.
10 11 12 |
# File 'lib/rails_sql_views/connection_adapters/sqlserver_adapter.rb', line 10 def views(name = nil) select_values("SELECT table_name FROM information_schema.views", name) end |