Class: Libis::Services::OracleClient

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

Instance Method Summary collapse

Constructor Details

#initialize(database, user, password) ⇒ OracleClient

Returns a new instance of OracleClient.



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

def initialize(database, user, password)
  @database = database
  @user = user
  @password = password
end

Instance Method Details

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



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

def call(procedure, parameters = [])
  params = ''
  params = "'" + parameters.join("','") + "'" if parameters and parameters.size > 0
  system "echo \"call #{procedure}(#{params});\" | sqlplus -S #{@user}/#{@password}@#{@database}"
end

#execute(sql) ⇒ Object 



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

def execute(sql)
  process_result `echo \"#{sql}\" | sqlplus -S #{@user}/#{@password}@#{@database}`
end

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



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

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