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