Class: DbMon::PgMonitor

Inherits:
Monitor show all
Defined in:
lib/db_mon/pg_monitor.rb

Instance Method Summary collapse

Methods inherited from Monitor

#monitor_table, #send_alert_email

Constructor Details

#initialize(options) ⇒ PgMonitor

Returns a new instance of PgMonitor.



6
7
8
9
 
# File 'lib/db_mon/pg_monitor.rb', line 6

def initialize(options)
  super(options)
  @connection = PG.connect(dbname: @database, user: @username, password: @password)    
end

Instance Method Details

#query_table ⇒ Object 



11
12
13
 
# File 'lib/db_mon/pg_monitor.rb', line 11

def query_table
  @connection.exec("SELECT #{@time_column} FROM #{@table} WHERE #{@time_column} BETWEEN '#{Time.now - @interval}' AND '#{Time.now}' ORDER BY #{@time_column}").values
end