Class: MintPress::OracleDatabase::Table

Inherits:

Object

Object
MintPress::OracleDatabase::Table

show all

Includes:: MintLogger, Mixins::Properties

Defined in:: src/oracle-database/lib/oracle-database/model/database/table.rb

Overview

An Oracle table object that represents an Oracle database table of an Oracle Database Database This class provides a set of methods to manage an Oracle Tables in an Oracle Database. The attributes of this class closely resemble the DBA_TABLES data dictionary view

Since:

0.1.0

Properties (Read/Write)

#table_name ⇒ String
The name of the table
Property Attributes

required ⇒ true
alias ⇒ :name

25	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 25 property :table_name, required: true, type: String, alias: :name

#tablespace_name ⇒ [ String, MintPress::OracleDatabase::Tablespace ]

Property Attributes

26	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 26 property :tablespace_name, type: [ String, MintPress::OracleDatabase::Tablespace ]

#owner ⇒ [ String, MintPress::OracleDatabase::User ]

Property Attributes

27	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 27 property :owner, type: [ String, MintPress::OracleDatabase::User ]

#cluster_name ⇒ String

Property Attributes

28	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 28 property :cluster_name, type: String

#iot_name ⇒ String

Property Attributes

29	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 29 property :iot_name, type: String

#status ⇒ String

Property Attributes

allowed_values ⇒ %w{VALID UNUSABLE}

30	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 30 property :status, type: String, allowed_values: %w{VALID UNUSABLE}

#pct_free ⇒ Integer

Property Attributes

from ⇒ BigDecimal

31	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 31 property :pct_free, type: Integer, from: BigDecimal

#pct_used ⇒ Integer

Property Attributes

from ⇒ BigDecimal

32	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 32 property :pct_used, type: Integer, from: BigDecimal

#ini_trans ⇒ Integer

Property Attributes

from ⇒ BigDecimal

33	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 33 property :ini_trans, type: Integer, from: BigDecimal

#max_trans ⇒ Integer

Property Attributes

from ⇒ BigDecimal

34	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 34 property :max_trans, type: Integer, from: BigDecimal

#initial_extent ⇒ Integer

Property Attributes

from ⇒ BigDecimal

35	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 35 property :initial_extent, type: Integer, from: BigDecimal

#next_extent ⇒ Integer

Property Attributes

from ⇒ BigDecimal

36	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 36 property :next_extent, type: Integer, from: BigDecimal

#min_extents ⇒ Integer

Property Attributes

from ⇒ BigDecimal

37	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 37 property :min_extents, type: Integer, from: BigDecimal

#max_extents ⇒ Integer

Property Attributes

from ⇒ BigDecimal

38	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 38 property :max_extents, type: Integer, from: BigDecimal

#pct_increase ⇒ Integer

Property Attributes

from ⇒ BigDecimal

39	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 39 property :pct_increase, type: Integer, from: BigDecimal

#freelists ⇒ Integer

Property Attributes

from ⇒ BigDecimal

40	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 40 property :freelists, type: Integer, from: BigDecimal

#freelist_groups ⇒ Integer

Property Attributes

from ⇒ BigDecimal

41	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 41 property :freelist_groups, type: Integer, from: BigDecimal

#logging ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 42

property :logging, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

#backed_up ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 43

property :backed_up, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

#num_rows ⇒ Integer

Property Attributes

from ⇒ BigDecimal

44	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 44 property :num_rows, type: Integer, from: BigDecimal

#blocks ⇒ Integer

Property Attributes

from ⇒ BigDecimal

45	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 45 property :blocks, type: Integer, from: BigDecimal

#empty_blocks ⇒ Integer

Property Attributes

from ⇒ BigDecimal

46	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 46 property :empty_blocks, type: Integer, from: BigDecimal

#avg_space ⇒ Integer

Property Attributes

from ⇒ BigDecimal

47	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 47 property :avg_space, type: Integer, from: BigDecimal

#chain_cnt ⇒ Integer

Property Attributes

from ⇒ BigDecimal

48	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 48 property :chain_cnt, type: Integer, from: BigDecimal

#avg_row_len ⇒ Integer

Property Attributes

from ⇒ BigDecimal

49	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 49 property :avg_row_len, type: Integer, from: BigDecimal

#avg_space_freelist_blocks ⇒ Integer

Property Attributes

from ⇒ BigDecimal

50	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 50 property :avg_space_freelist_blocks, type: Integer, from: BigDecimal

#num_freelist_blocks ⇒ Integer

Property Attributes

from ⇒ BigDecimal

51	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 51 property :num_freelist_blocks, type: Integer, from: BigDecimal

#degree ⇒ String

Property Attributes

52	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 52 property :degree, type: String

#instances ⇒ String

Property Attributes

53	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 53 property :instances, type: String

#cache ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 54

property :cache, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

#table_lock ⇒ String

Property Attributes

allowed_values ⇒ %w{ENABLED DISABLED}

55	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 55 property :table_lock, type: String, allowed_values: %w{ENABLED DISABLED}

#sample_size ⇒ Integer

Property Attributes

from ⇒ BigDecimal

56	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 56 property :sample_size, type: Integer, from: BigDecimal

#last_analyzed ⇒ Time

Property Attributes

from ⇒ String

57	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 57 property :last_analyzed, type: Time, from: String

#partitioned ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 58

property :partitioned, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

#iot_type ⇒ String

Property Attributes

allowed_values ⇒ %w{IOT IOT_OVERFLOW IOT_MAPPING NULL}

59	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 59 property :iot_type, type: String, allowed_values: %w{IOT IOT_OVERFLOW IOT_MAPPING NULL}

#temporary ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 60

property :temporary, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

#secondary ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 61

property :secondary, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'y' ? true : false }

#nested ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 62

property :nested, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

#buffer_pool ⇒ String

Property Attributes

allowed_values ⇒ %w{DEFAULT KEEP RECYCLE NULL}

63	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 63 property :buffer_pool, type: String, allowed_values: %w{DEFAULT KEEP RECYCLE NULL}

#flash_cache ⇒ String

Property Attributes

allowed_values ⇒ %w{DEFAULT KEEP NONE}

64	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 64 property :flash_cache, type: String, allowed_values: %w{DEFAULT KEEP NONE}

#cell_flash_cache ⇒ String

Property Attributes

allowed_values ⇒ %w{DEFAULT KEEP NONE}

65	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 65 property :cell_flash_cache, type: String, allowed_values: %w{DEFAULT KEEP NONE}

#row_movement ⇒ String

Property Attributes

allowed_values ⇒ %w{ENABLED DISABLED}

66	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 66 property :row_movement, type: String, allowed_values: %w{ENABLED DISABLED}

#global_stats ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 67

property :global_stats, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

#user_stats ⇒ [ TrueClass, FalseClass ] (Default Value: false)

Property Attributes

default ⇒ false
from ⇒ Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 68

property :user_stats, type: [ TrueClass, FalseClass ], default: false, from: Proc.new { |v| v.to_s.downcase == 'yes' ? true : false }

#duration ⇒ String

Property Attributes

allowed_values ⇒ %w{SYS$SESSION SYS$TRANSACTION}

69	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 69 property :duration, type: String, allowed_values: %w{SYS$SESSION SYS$TRANSACTION}

#parent ⇒ MintPress::OracleDatabase::Database

Property Attributes

prop_name ⇒ :users

71	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 71 property :parent, type: MintPress::OracleDatabase::Database, prop_name: :users

#database ⇒ MintPress::OracleDatabase::Database

Property Attributes

72	# File 'src/oracle-database/lib/oracle-database/model/database/table.rb', line 72 property :database, type: MintPress::OracleDatabase::Database

Properties (Read Only)

Constant Summary

Constants included from MintLogger

MintLogger::DEBUG, MintLogger::ERROR, MintLogger::FATAL, MintLogger::INFO, MintLogger::UNKNOWN, MintLogger::VERBOSE, MintLogger::WARN

Instance Attribute Summary

Attributes included from Mixins::Properties

#autopush_set_cache, #dynamic_create, #harvest_on_access, #harvest_undefined_only, #harvested, #tree_root

Instance Method Summary collapse

#create ⇒ void
Create a table.
#drop ⇒ void
Drop a table.
#harvest ⇒ MintPress::OracleDatabase::Table
Harvest the configuration of a table in an Oracle database.
#initialize(opts = {}) ⇒ Table constructor
A new instance of Table.
#move ⇒ void
Move a table in an Oracle database.
#to_hash ⇒ Hash
Return a Hash representation for the class and all its sub-classes.
#usage ⇒ String
Example usage of the class.

Methods included from Mixins::Properties

#[], #[]=, #add_validate_report_result, #armour_set_property, #array_contains?, #array_is_a?, #check_autopush, #check_stack_overflow, #clone_property_object, #cloner_handle_single_property, #coerce_single, #contains_as_string?, #display_validate_report_result, #double_initialize?, #dump_to_hash, #find_parent, #find_parent_by_identity, #generate_accessor_functions, #get_canonical_renamed, #get_from_opts, #get_my_name, #get_property, #get_property_item, #has?, included, #initialize_validate_report, #inspect, #is_cloned_object?, #is_mintpress_object?, #is_probably_canonical?, #is_set?, #local_debug, #local_info, #local_verbose, #mintpress_property_definitions, #place_object_by_identity, #process_properties, #prop_set?, #property, #property_definitions, #property_details, #property_is_simple_object?, #push_root!, #require_property, #require_update, #retrieve_docstring, #sanitize, #set_map_dirty, #set_property, #set_property_item, #show_short_array, #strip_defaults!, #synchronize, #uncloned_property_definitions, #update_map, #validate, #validate_generic, #validate_properties, #validate_property, #validate_required, #version_allowed?, #weakref

Methods included from MintLogger::Utils::Common

#boolean_val, #has_value?, #no_value?, #nvl, #path_as_symbol, #ruby_level_to_send

Constructor Details

#initialize(opts = {}) ⇒ `Table`

Returns a new instance of Table.

Since:

0.1.0

Instance Method Details

#create ⇒ `void`

This method returns an undefined value.

Create a table

Since:

0.1.0

#drop ⇒ `void`

This method returns an undefined value.

Drop a table

Since:

0.1.0

#harvest ⇒ `MintPress::OracleDatabase::Table`

Harvest the configuration of a table in an Oracle database

Returns:

(MintPress::OracleDatabase::Table)

Since:

0.1.0

#move ⇒ `void`

This method returns an undefined value.

Move a table in an Oracle database

Since:

0.1.0

#to_hash ⇒ `Hash`

Return a Hash representation for the class and all its sub-classes.

Returns:

(Hash) —
the object in Hash format

Since:

0.1.0

#usage ⇒ `String`

Example usage of the class

Returns:

(String) —
Example usage

Since:

0.1.0

Class: MintPress::OracleDatabase::Table

Overview

Properties (Read/Write)

Properties (Read Only)

Constant Summary

Constants included from MintLogger

Instance Attribute Summary

Attributes included from Mixins::Properties

Instance Method Summary collapse

Methods included from Mixins::Properties

Methods included from MintLogger::Utils::Common

Constructor Details

#initialize(opts = {}) ⇒ Table

Instance Method Details

#create ⇒ void

#drop ⇒ void

#harvest ⇒ MintPress::OracleDatabase::Table

#move ⇒ void

#to_hash ⇒ Hash

#usage ⇒ String

#initialize(opts = {}) ⇒ `Table`

#create ⇒ `void`

#drop ⇒ `void`

#harvest ⇒ `MintPress::OracleDatabase::Table`

#move ⇒ `void`

#to_hash ⇒ `Hash`

#usage ⇒ `String`