Class: Oraora::Meta::MaterializedView

Inherits:
Object
  • Object
show all
Defined in:
lib/oraora/meta/materialized_view.rb

Instance Method Summary collapse

Methods inherited from Object

from_oci, #initialize

Constructor Details

This class inherits a constructor from Oraora::Meta::Object

Instance Method Details

#columns(column) ⇒ Object

Raises:



42
43
44
45
 
# File 'lib/oraora/meta/materialized_view.rb', line 42

def columns(column)
  raise NotExists if !@columns_hash[column]
  @columns_hash[column]
end

#describe(options = {}) ⇒ Object 



26
27
28
29
30
31
32
33
34
 
# File 'lib/oraora/meta/materialized_view.rb', line 26

def describe(options = {})
  "    Materialized view \#{@schema}.\#{@name}\n    Updatable:        \#{@updatable}\n    Refresh mode:     \#{@refresh_mode}\n    Fast refreshable: \#{@fast_refreshable}\n    Staleness:        \#{@staleness}\n  HERE\nend\n".reset_indentation

#list(options = {}, filter = nil) ⇒ Object 



36
37
38
39
40
 
# File 'lib/oraora/meta/materialized_view.rb', line 36

def list(options = {}, filter = nil)
  columns = @columns_hash.keys
  columns.select! { |c| c =~ /^#{Regexp.escape(filter).gsub('\*', '.*').gsub('\?', '.')}$/ } if filter
  columns
end

#load_from_oci(oci) ⇒ Object

Raises:



10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/oraora/meta/materialized_view.rb', line 10

def load_from_oci(oci)
  @updatable, @refresh_mode, @fast_refreshable, @staleness =
      oci.select_one("SELECT updatable, refresh_mode, fast_refreshable, staleness
                        FROM all_mviews
                       WHERE owner = :schema AND mview_name = :name", @schema, @name)
  raise NotExists if !@updatable
  @columns = oci.pluck("SELECT column_name, column_id, data_type, data_length, data_precision, data_scale, char_used, char_length " +
                           "FROM all_tab_columns WHERE owner = :schema AND table_name = :name ORDER BY column_id", @schema, @name).collect do |col|
    Column.new(@schema, @name, col[0], id: col[1].to_i, type: col[2], length: col[3] && col[3].to_i,
               precision: col[4] && col[4].to_i, scale: col[5] && col[5].to_i, char_used: col[6],
               char_length: col[7] && col[7].to_i)
  end
  @columns_hash = Hash[@columns.collect { |col| [col.name, col] }]
  self
end

#type ⇒ Object 



6
7
8
 
# File 'lib/oraora/meta/materialized_view.rb', line 6

def type
  'MATERIALIZED VIEW'
end