Class: Libis::Services::OracleClient

Inherits:
Object
  • Object
show all
Defined in:
lib/libis/services/oracle_client.rb

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(url) ⇒ OracleClient

Returns a new instance of OracleClient.



10
11
12
13
14
 
# File 'lib/libis/services/oracle_client.rb', line 10

def initialize(url)
  @url = url
  @oci = OCI8.new(url)
  ObjectSpace.define_finalizer(self, self.class.finalize(@oci))
end

Instance Attribute Details

#oci ⇒ Object (readonly)

Returns the value of attribute oci.



8
9
10
 
# File 'lib/libis/services/oracle_client.rb', line 8

def oci
  @oci
end

#url ⇒ Object (readonly)

Returns the value of attribute url.



8
9
10
 
# File 'lib/libis/services/oracle_client.rb', line 8

def url
  @url
end

Class Method Details

.finalize(oci) ⇒ Object 



16
17
18
 
# File 'lib/libis/services/oracle_client.rb', line 16

def self.finalize(oci)
  proc { oci.logoff }
end

Instance Method Details

#blocking=(value) ⇒ Object

Parameters:

  • value (Boolean) 


21
22
23
24
 
# File 'lib/libis/services/oracle_client.rb', line 21

def blocking=(value)
  oci.non_blocking = !value
  blocking?
end

#blocking? ⇒ Boolean

Returns:

  • (Boolean) 


26
27
28
 
# File 'lib/libis/services/oracle_client.rb', line 26

def blocking?
  !oci.non_blocking?
end

#call(procedure, parameters = []) ⇒ Object 



30
31
32
33
34
 
# File 'lib/libis/services/oracle_client.rb', line 30

def call(procedure, parameters = [])
  params = ''
  params = "'" + parameters.map(&:to_s).join("','") + "'" if parameters and parameters.size > 0
  oci.exec("call #{procedure}(#{params})")
end

#execute(statement, *bindvars, &block) ⇒ Object 



36
37
38
 
# File 'lib/libis/services/oracle_client.rb', line 36

def execute(statement, *bindvars, &block)
  oci.exec(statement, *bindvars, &block)
end

#run(script, parameters = []) ⇒ Object 



61
62
63
64
65
 
# File 'lib/libis/services/oracle_client.rb', line 61

def run(script, parameters = [])
  params = ''
  params = "\"" + parameters.join("\" \"") + "\"" if parameters and parameters.size > 0
  process_result `sqlplus -S #{url} @#{script} #{params}`
end

#table(name) ⇒ Object 



40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# File 'lib/libis/services/oracle_client.rb', line 40

def table(name)
  metadata = oci.describe_table(name)
  {
      columns: metadata.columns.map do |column|
        {
            name: column.name,
            type: column.data_type,
            size: case column.data_type
                    when :number
                      column.precision
                    when :varchar2
                      column.char_size
                    else
                      column.data_size
                  end,
            required: !column.nullable?
        }
      end
  }
end