Class: Takwimu::Notifications::ActiveRecord

Inherits:
Base
  • Object
show all
Defined in:
lib/takwimu/notifications/active_record.rb

Constant Summary collapse

SELECT_DELETE = 
/ FROM `(w+)`/
INSERT = 
/^INSERT INTO `(w+)`/
UPDATE = 
/^UPDATE `(w+)`/

Class Method Summary collapse

Methods inherited from Base

subscribe!

Class Method Details

.callback(name, start, finish, unique_id, payload) ⇒ Object 



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
# File 'lib/takwimu/notifications/active_record.rb', line 17

def self.callback(name, start, finish, unique_id, payload)
  statsd_client = Takwimu.config.statsd
  hostname = Takwimu.config.hostname

  case payload[:sql]
    when /^SELECT/
      payload[:sql] =~ SELECT_DELETE
      statsd_client.increment("#{hostname}.sql.select")
      statsd_client.timing("#{hostname}.sql.#{$1}.select.query_time", (finish - start) * 1000, 1)
    when /^DELETE/
      payload[:sql] =~ SELECT_DELETE
      statsd_client.increment("#{hostname}.sql.delete")
      statsd_client.timing("#{hostname}.sql.#{$1}.delete.query_time", (finish - start) * 1000, 1)
    when /^INSERT/
      payload[:sql] =~ INSERT
      statsd_client.increment("#{hostname}.sql.insert")
      statsd_client.timing("#{hostname}.sql.#{$1}.insert.query_time", (finish - start) * 1000, 1)
    when /^UPDATE/
      payload[:sql] =~ UPDATE
      statsd_client.increment("#{hostname}.sql.update"  )
      statsd_client.timing("#{hostname}.sql.#{$1}.update.query_time", (finish - start) * 1000, 1)
  end
end

.event_name ⇒ Object 



13
14
15
 
# File 'lib/takwimu/notifications/active_record.rb', line 13

def self.event_name
  "sql.active_record"
end