class Oraora::Meta::Database

Public Class Methods

from_oci(oci) click to toggle source
# File lib/oraora/meta/database.rb, line 10
def self.from_oci(oci)
  new.load_from_oci(oci)
end

Public Instance Methods

describe(options = {}) click to toggle source
# File lib/oraora/meta/database.rb, line 14
      def describe(options = {})
        <<-HERE.reset_indentation
          Database #{@name}
          Created:      #{@created}
        HERE
      end
list(options = {}, filter = nil) click to toggle source
# File lib/oraora/meta/database.rb, line 21
def list(options = {}, filter = nil)
  schemas = @schemas.select! { |o| o =~ /^#{Regexp.escape(filter).gsub('\*', '.*').gsub('\?', '.')}$/ } if filter
  schemas || @schemas
end
load_from_oci(oci) click to toggle source
# File lib/oraora/meta/database.rb, line 4
def load_from_oci(oci)
  @name, @created = oci.select_one("SELECT name, created FROM v$database")
  @schemas = oci.pluck_one("SELECT username FROM all_users ORDER BY username")
  self
end