Class: Footnotes::Notes::QueriesNote

Inherits:
AbstractNote show all
Defined in:
lib/rails-footnotes/notes/queries_note.rb

Constant Summary collapse

@@alert_db_time = 
16.0
@@alert_sql_number = 
8
@@query_subscriber = 
nil
@@orm = 
[:active_record, :data_mapper]

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from AbstractNote

close!, #escape, #has_fieldset?, #hash_to_xml_attributes, included?, #initialize, #javascript, #legend, #link, #mount_table, #mount_table_for_hash, #onclick, #prefix?, #row, #stylesheet, title, #to_sym, to_sym, #valid?

Constructor Details

This class inherits a constructor from Footnotes::Notes::AbstractNote

Class Method Details

.query_subscriber ⇒ Object 



15
16
17
 
# File 'lib/rails-footnotes/notes/queries_note.rb', line 15

def self.query_subscriber
  @@query_subscriber ||= Footnotes::Notes::QuerySubscriber.new(self.orm)
end

.start!(controller) ⇒ Object 



11
12
13
 
# File 'lib/rails-footnotes/notes/queries_note.rb', line 11

def self.start!(controller)
  self.query_subscriber.reset!
end

Instance Method Details

#content ⇒ Object 



35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 
# File 'lib/rails-footnotes/notes/queries_note.rb', line 35

def content
  html = ''
  self.events.each_with_index do |event, index|
    sql_links = []
    sql_links << "<a href=\"javascript:Footnotes.toggle('qtrace_#{index}')\" style=\"color:#00A;\">trace</a>"

    html << "      <b id=\"qtitle_\#{index}\">\#{escape(event.type.to_s.upcase)}</b> (\#{sql_links.join(' | ')})<br />\n      <span id=\"sql_\#{index}\">\#{print_query(event.payload[:sql])}</span><br />\n      \#{print_name_and_time(event.payload[:name], event.duration / 1000.0)}&nbsp;\n      <p id=\"qtrace_\#{index}\" style=\"display:none;\">\#{parse_trace(event.trace)}</p><br />\n    HTML\n  end\n  return html\nend\n"

#events ⇒ Object 



19
20
21
 
# File 'lib/rails-footnotes/notes/queries_note.rb', line 19

def events
  self.class.query_subscriber.events
end

#title ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
 
# File 'lib/rails-footnotes/notes/queries_note.rb', line 23

def title
  queries = self.events.count
  total_time = self.events.map(&:duration).sum / 1000.0
  query_color = generate_red_color(self.events.count, alert_sql_number)
  db_color    = generate_red_color(total_time, alert_db_time)

  "  <span style=\"background-color:\#{query_color}\">Queries (\#{queries})</span>\n  <span style=\"background-color:\#{db_color}\">DB (\#{\"%.3f\" % total_time}ms)</span>\n  TITLE\nend\n"