Sha256: 18ddb9eff4970363ac2999ec06a34db54774bada203f58e91a4c89a47761c784
Contents?: true
Size: 865 Bytes
Versions: 19
Compression:
Stored size: 865 Bytes
Contents
module RailsSqlViews
module ConnectionAdapters
module OracleAdapter
# Returns true as this adapter supports views.
def supports_views?
true
end
def base_tables(name = nil) #:nodoc:
tables = []
execute("SELECT TABLE_NAME FROM USER_TABLES", name).each { |row| tables << row[0] }
tables
end
alias nonview_tables base_tables
def views(name = nil) #:nodoc:
views = []
execute("SELECT VIEW_NAME FROM USER_VIEWS", name).each { |row| views << row[0] }
views
end
# Get the view select statement for the specified table.
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
end
end
end
Version data entries
19 entries across 19 versions & 8 rubygems