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(database, user, password) ⇒ OracleClient 



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

def initialize(database, user, password)
  @database = database
  @user = user
  @password = password
  @oci = OCI8.new(user, password, database)
  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

Class Method Details

.finalize(oci) ⇒ Object 



18
19
20
 
# File 'lib/libis/services/oracle_client.rb', line 18

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

Instance Method Details

#blocking=(value) ⇒ Object 



23
24
25
26
 
# File 'lib/libis/services/oracle_client.rb', line 23

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

#blocking? ⇒ Boolean 



28
29
30
 
# File 'lib/libis/services/oracle_client.rb', line 28

def blocking?
  !oci.non_blocking?
end

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



32
33
34
35
36
 
# File 'lib/libis/services/oracle_client.rb', line 32

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 



38
39
40
 
# File 'lib/libis/services/oracle_client.rb', line 38

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

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



63
64
65
66
67
 
# File 'lib/libis/services/oracle_client.rb', line 63

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

#table(name) ⇒ Object 



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

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