Class: MintPress::OracleUtils::SQLRubySessionImpl

Inherits:

Object

• Object
• MintPress::OracleUtils::SQLRubySessionImpl

Includes:

MintLogger, Mixins::Properties

Defined in:

src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb

Properties (Read/Write)

• #host ⇒ MintPress::Infrastructure::Host
  Host used to acquire the OCI8 gem
  Property Attributes
  • no_backref ⇒ true
  • parallel ⇒ true
  • disposition ⇒ :requires

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 31
  
  property :host, type: MintPress::Infrastructure::Host, no_backref: true, parallel: true, disposition: :requires

• #db_username ⇒ String
  'Database username'
  Property Attributes
  • alias ⇒ :dba_username

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 34
  
  property :db_username, type: String, description: 'Database username', alias: :dba_username

• #db_password ⇒ Mint::Secret
  'Password credential for database user'
  Property Attributes
  • from ⇒ String
  • alias ⇒ :dba_password

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 36
  
  property :db_password, type: Mint::Secret, from: String, description: 'Password credential for database user', alias: :dba_password

• #db_role ⇒ String
  'User role'
  Property Attributes

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 38
  
  property :db_role, type: String, description: 'User role'

• #db_host ⇒ String (Default Value: Proc.new { self.host.name })
  'Database connection host'
  Property Attributes
  • default ⇒ Proc.new { self.host.name }

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 40
  
  property :db_host, type: String, description: 'Database connection host', default: Proc.new { self.host.name }

• #db_port ⇒ Integer
  'Database connection port'
  Property Attributes

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 41
  
  property :db_port, type: Integer, description: 'Database connection port'

• #db_service_name ⇒ String
  'Database connection service name'
  Property Attributes

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 43
  
  property :db_service_name, type: String, description: 'Database connection service name'

• #db_connect_descriptor ⇒ String (Default Value: Proc.new { "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=#{self.get_property(:db_host)})(PORT=#{self.get_property(:db_port)})))(CONNECT_DATA=(SERVICE_NAME=#{self.get_property(:db_service_name)})))" })
  'Database connect descriptor that will override with advanced DB connect string such as failover and other advanced settings'
  Property Attributes
  • default ⇒ Proc.new { "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=#{self.get_property(:db_host)})(PORT=#{self.get_property(:db_port)})))(CONNECT_DATA=(SERVICE_NAME=#{self.get_property(:db_service_name)})))" }

  # File 'src/oracle-utils/lib/oracle-utils/sql-ruby-session.rb', line 44
  
  property :db_connect_descriptor, type: String, description: 'Database connect descriptor that will override with advanced DB connect string such as failover and other advanced settings', default: Proc.new { "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=#{self.get_property(:db_host)})(PORT=#{self.get_property(:db_port)})))(CONNECT_DATA=(SERVICE_NAME=#{self.get_property(:db_service_name)})))" }

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

• #db ⇒ Object
• #execute(sql) ⇒ Object
• #execute_file(sql_file) ⇒ Object
• #initialize(opts = {}) ⇒ SQLRubySessionImpl constructor
  A new instance of SQLRubySessionImpl.

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 = {}) ⇒ SQLRubySessionImpl

Returns a new instance of SQLRubySessionImpl.

Instance Method Details

#db ⇒ Object

#execute(sql) ⇒ Object

#execute_file(sql_file) ⇒ Object