Sha256: 1d8ffa31ef18ac9a9e17038741ac35c14dee37a7560146b038139f1333481714
Contents?: true
Size: 862 Bytes
Versions: 19
Compression:
Stored size: 862 Bytes
Contents
module RailsSqlViews
module ConnectionAdapters
module OciAdapter
# 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