Contents

module RailsSqlViews4
 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

3 entries across 3 versions & 1 rubygems

Version	Path
rails_sql_views4-0.0.3	lib/rails_sql_views4/connection_adapters/oci_adapter.rb
rails_sql_views4-0.0.2	lib/rails_sql_views4/connection_adapters/oci_adapter.rb
rails_sql_views4-0.0.1	lib/rails_sql_views4/connection_adapters/oci_adapter.rb