Class: PLSQL::Coverage

Inherits:
Object
  • Object
show all
Defined in:
lib/plsql/coverage.rb

Constant Summary collapse

@@coverages = 
{}

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(connection_alias) ⇒ Coverage

Returns a new instance of Coverage.



16
17
18
 
# File 'lib/plsql/coverage.rb', line 16

def initialize(connection_alias)
  @connection_alias = connection_alias
end

Instance Attribute Details

#directory ⇒ Object

Returns the value of attribute directory.



5
6
7
 
# File 'lib/plsql/coverage.rb', line 5

def directory
  @directory
end

Class Method Details

.cleanup(connection_alias = nil) ⇒ Object 



45
46
47
 
# File 'lib/plsql/coverage.rb', line 45

def self.cleanup(connection_alias = nil)
  find(connection_alias).cleanup
end

.find(connection_alias = nil) ⇒ Object 



55
56
57
58
 
# File 'lib/plsql/coverage.rb', line 55

def self.find(connection_alias = nil)
  connection_alias ||= :default
  @@coverages[connection_alias]
end

.report(connection_alias = nil, options = {}) ⇒ Object 



60
61
62
63
64
65
66
67
 
# File 'lib/plsql/coverage.rb', line 60

def self.report(connection_alias = nil, options = {})
  # if first parameter is Hash then consider it as options and use default connection
  if connection_alias.is_a?(Hash)
    options = connection_alias
    connection_alias = nil
  end
  find(connection_alias).report(options)
end

.reset_cache ⇒ Object

used in tests to reset coverages cache



8
9
10
 
# File 'lib/plsql/coverage.rb', line 8

def self.reset_cache
  @@coverages = {}
end

.start(connection_alias = nil) ⇒ Object 



12
13
14
 
# File 'lib/plsql/coverage.rb', line 12

def self.start(connection_alias = nil)
  find_or_new(connection_alias).start
end

.stop(connection_alias = nil) ⇒ Object 



33
34
35
 
# File 'lib/plsql/coverage.rb', line 33

def self.stop(connection_alias = nil)
  find_or_new(connection_alias).stop
end

Instance Method Details

#cleanup ⇒ Object 



49
50
51
52
53
 
# File 'lib/plsql/coverage.rb', line 49

def cleanup
  return false if @started
  drop_or_delete_profiler_tables
  true
end

#coverage_data(options = {}) ⇒ Object 



89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
 
# File 'lib/plsql/coverage.rb', line 89

def coverage_data(options={})
  quoted_ignore_schemas = if options[:ignore_schemas]
    options[:ignore_schemas].map{|schema| quote_condition_string(schema)}
  else
    %w('SYS')
  end
  quoted_ignore_schemas << "'<anonymous>'"
  like_condition = if options[:like]
    'AND ((' << Array(options[:like]).map do |like|
      like_schema, like_object = like.split('.')
      condition = "u.unit_owner LIKE #{quote_condition_string(like_schema)}"
      condition << " AND u.unit_name LIKE #{quote_condition_string(like_object)}" if like_object
    end.join(') OR (') << '))'
  else
    nil
  end
  data = {}
  rows = plsql(@connection_alias).select_all "    SELECT u.unit_owner, u.unit_name, d.line# line_number, d.total_occur\n    FROM plsql_profiler_units u, plsql_profiler_data d\n    WHERE u.runid = \#{@run_number}\n      AND u.unit_owner NOT IN (\#{quoted_ignore_schemas.join(',')})\n      AND u.runid = d.runid\n      AND u.unit_number = d.unit_number\n      \#{like_condition}\n    ORDER BY u.unit_owner, u.unit_name, d.line#\n  EOS\n  rows.each do |row|\n    unit_owner, unit_name, line_number, total_occur = row\n    data[unit_owner] ||= {}\n    data[unit_owner][unit_name] ||= {}\n    data[unit_owner][unit_name][line_number] = total_occur\n  end\n  @coverage_data = data\nend\n"

#report(options = {}) ⇒ Object 



69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
 
# File 'lib/plsql/coverage.rb', line 69

def report(options={})
  # prevent repeated invocation after coverage is reported
  # return if @coverages

  @directory = options.delete(:directory)
  coverage_data(options)
  create_static_files
  read_templates

  # Loop through each database object, evaluating it along with the template
  @coverage_data.keys.sort.each do |schema|
    @coverage_data[schema].keys.sort.each do |object|
      details_report(schema, object)
    end
  end

  index_report
  true
end

#start ⇒ Object 



20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/plsql/coverage.rb', line 20

def start
  # ignore repeated invocation
  return false if @started
  create_profiler_tables
  result = plsql(@connection_alias).dbms_profiler.start_profiler(
    :run_comment => "ruby-plsql-spec #{Time.now.xmlschema}",
    :run_number => nil
  )
  @run_number = result[1][:run_number]
  @coverages = nil
  @started = true
end

#stop ⇒ Object 



37
38
39
40
41
42
43
 
# File 'lib/plsql/coverage.rb', line 37

def stop
  # ignore repeated invocation
  return false unless @started
  plsql(@connection_alias).dbms_profiler.stop_profiler
  @started = false
  true
end