Class: ActiveRecord::ConnectionAdapters::OracleAdapter

Inherits:
Object
  • Object
show all
Defined in:
lib/rails_sql_views/connection_adapters/oracle_adapter.rb

Instance Method Summary collapse

Instance Method Details

#supports_views? ⇒ Boolean

Returns true as this adapter supports views.

Returns:

  • (Boolean) 


5
6
7
 
# File 'lib/rails_sql_views/connection_adapters/oracle_adapter.rb', line 5

def supports_views?
  true
end

#tables(name = nil) ⇒ Object

:nodoc:



9
10
11
12
13
 
# File 'lib/rails_sql_views/connection_adapters/oracle_adapter.rb', line 9

def tables(name = nil) #:nodoc:
  tables = []
  execute("SELECT TABLE_NAME FROM USER_TABLES", name).each { |row| tables << row[0]  }
  tables
end

#view_select_statement(view, name = nil) ⇒ Object

Get the view select statement for the specified table.



22
23
24
25
26
27
 
# File 'lib/rails_sql_views/connection_adapters/oracle_adapter.rb', line 22

def view_select_statement(view, name=nil)
  row = execute("SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = '#{view}'", name).each do |row|
    return row[0]
  end
  raise "No view called #{view} found"
end

#views(name = nil) ⇒ Object

:nodoc:



15
16
17
18
19
 
# File 'lib/rails_sql_views/connection_adapters/oracle_adapter.rb', line 15

def views(name = nil) #:nodoc:
  views = []
  execute("SELECT VIEW_NAME FROM USER_VIEWS", name).each { |row| views << row[0] }
  views
end