Class: Platform::ApplicationUsageMetric
- Defined in:
- app/models/platform/application_usage_metric.rb
Overview
– Copyright © 2010-2012 Michael Berkovich
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. ++
– Platform::ApplicationUsageMetric Schema Information
Table name: platform_application_usage_metrics
id INTEGER not null, primary key
type varchar(255)
interval datetime
application_id integer
event varchar(255)
count integer
avg_response_time integer
error_count integer
created_at datetime
updated_at datetime
Indexes
paumai (application_id, interval)
++
Class Method Summary collapse
- .calculate_metric(app, interval) ⇒ Object
- .find_or_create(app, interval, event) ⇒ Object
- .interval_duration ⇒ Object
Class Method Details
.calculate_metric(app, interval) ⇒ Object
59 60 61 62 63 64 65 66 67 68 69 70 71 |
# File 'app/models/platform/application_usage_metric.rb', line 59 def self.calculate_metric(app, interval) interval_start = interval interval_end = interval_start + interval_duration results = execute_query("select event, count(event) as count, avg(duration) as avg_response_time from platform_application_logs where application_id=#{app.id} and created_at >= '#{interval_start}' and created_at < '#{interval_end}' group by event"); results.each do |result| metric = find_or_create(app, interval, result['event']) metric.count = result['count'] metric.avg_response_time = result['avg_response_time'] metric.error_count = 0 # need to add ability to count errors metric.save end end |
.find_or_create(app, interval, event) ⇒ Object
50 51 52 53 |
# File 'app/models/platform/application_usage_metric.rb', line 50 def self.find_or_create(app, interval, event) metric = find(:first, :conditions => ["application_id = ? and interval = ? and event = ?", app.id, interval, event]) metric || create(:application => app, :interval => interval, :event => event) end |
.interval_duration ⇒ Object
55 56 57 |
# File 'app/models/platform/application_usage_metric.rb', line 55 def self.interval_duration 15.minutes end |