Class: DBGeni::Migrator::Oracle

Inherits:
MigratorInterface show all
Defined in:
lib/dbgeni/migrators/oracle.rb

Instance Attribute Summary

Attributes inherited from MigratorInterface

#logfile

Instance Method Summary collapse

Methods inherited from MigratorInterface

#apply, #rollback, #verify

Constructor Details

#initialize(config, connection) ⇒ Oracle

Returns a new instance of Oracle.

[View source]

6
7
8
 
# File 'lib/dbgeni/migrators/oracle.rb', line 6

def initialize(config, connection)
  super(config, connection)
end

Instance Method Details

#code_errors ⇒ Object

[View source]

62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
 
# File 'lib/dbgeni/migrators/oracle.rb', line 62

def code_errors
  # The error part of the file file either looks like:

  # SQL> show err
  # No errors.
  # SQL> spool off

  # or

  # SQL> show err
  # Errors for PACKAGE BODY PKG1:

  # LINE/COL ERROR
  # -------- -----------------------------------------------------------------
  # 5/1      PLS-00103: Encountered the symbol "END" when expecting one of the
  # following:
  # Error messages here
  # SQL> spool off

  # In the first case, return nil, but in the second case get everything after show err

  error_msg = ''
  start_search = false
  File.open(@logfile, 'r').each_line do |l|
    if !start_search && l =~ /^SQL> show err/
      start_search = true
      next
    end
    if start_search
      if l =~ /^No errors\./
        error_msg = nil
        break
      elsif l =~ /^SQL> spool off/
        break
      else
        error_msg << l
      end
    end
  end
  error_msg
end

#compile(code, force = false) ⇒ Object

def verify(migration) end

[View source]

48
49
50
 
# File 'lib/dbgeni/migrators/oracle.rb', line 48

def compile(code, force=false)
  run_in_client(code.runnable_code, force, true)
end

#migration_errors ⇒ Object

def rollback(migration, force=nil) end

[View source]

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
# File 'lib/dbgeni/migrators/oracle.rb', line 16

def migration_errors
  has_errors = false
  buffer = []

  begin
    File.open(@logfile, 'r').each_line do |l|
      buffer.push l
      if buffer.length > 10
        buffer.shift
      end
      if !has_errors && l =~ /^ERROR at line/
        has_errors = true
        next
      end
      # After we find the ERROR at line, the next line contains the error
      # message, so we just want to consume it and then exit.
      # The line we care about will be in the buffer, so just break and join
      # the buffer.
      if has_errors
        break
      end
    end
  rescue Errno::ENOENT
    # assume this means the log was never written as, generally because
    # sqlplus didn't connect to Oracle. In this case do nothing
  end
  buffer.join("")
end

#remove(code, force = false) ⇒ Object

[View source]

52
53
54
55
56
57
58
59
60
 
# File 'lib/dbgeni/migrators/oracle.rb', line 52

def remove(code, force=false)
  begin
    @connection.execute(drop_command(code))
  rescue Exception => e
    unless e.to_s =~ /(object|trigger) .+ does not exist/
      raise DBGeni::CodeRemoveFailed, e.to_s
    end
  end
end