Class: DbMon::MysqlMonitor

Inherits:
Monitor
  • Object
show all
Defined in:
lib/db_mon/mysql_monitor.rb

Instance Method Summary collapse

Methods inherited from Monitor

#monitor_table, #send_alert_email

Constructor Details

#initialize(options) ⇒ MysqlMonitor

Returns a new instance of MysqlMonitor.



5
6
7
8
 
# File 'lib/db_mon/mysql_monitor.rb', line 5

def initialize(options)
  super(options)
  @connection = Mysql2::Client.new(host: 'localhost', username: @username, password: @password)    
end

Instance Method Details

#query_table ⇒ Object 



10
11
12
 
# File 'lib/db_mon/mysql_monitor.rb', line 10

def query_table
  return @connection.query("SELECT #{@time_column} FROM #{@table} WHERE #{@time_column} BETWEEN '#{@interval.seconds.ago}' AND '#{Time.now}' ORDER BY #{@time_column}")
end