Class: OraUtils::Sql

Inherits:
Object
  • Object
show all
Defined in:
lib/orabase/utils/sql.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(options = {}) ⇒ Sql

Returns a new instance of Sql.



11
12
13
14
15
16
17
18
 
# File 'lib/orabase/utils/sql.rb', line 11

def initialize(options = {})
  @command     = SqlplusCommand.new( options)
  @sid         = @command.sid
  @os_user     = @command.os_user
  @username    = @command.username
  @password    = @command.password
  @timeout     = @command.timeout
end

Instance Attribute Details

#os_user ⇒ Object (readonly)

Returns the value of attribute os_user.



9
10
11
 
# File 'lib/orabase/utils/sql.rb', line 9

def os_user
  @os_user
end

#password ⇒ Object (readonly)

Returns the value of attribute password.



9
10
11
 
# File 'lib/orabase/utils/sql.rb', line 9

def password
  @password
end

#sid ⇒ Object (readonly)

Returns the value of attribute sid.



9
10
11
 
# File 'lib/orabase/utils/sql.rb', line 9

def sid
  @sid
end

#timeout ⇒ Object (readonly)

Returns the value of attribute timeout.



9
10
11
 
# File 'lib/orabase/utils/sql.rb', line 9

def timeout
  @timeout
end

#username ⇒ Object (readonly)

Returns the value of attribute username.



9
10
11
 
# File 'lib/orabase/utils/sql.rb', line 9

def username
  @username
end

Instance Method Details

#execute(command) ⇒ Object 



20
21
22
23
 
# File 'lib/orabase/utils/sql.rb', line 20

def execute(command)
  create_output_file
  @command.execute_sql_command(command, @output_file.path)
end