Contents

#--
# WebROaR - Ruby Application Server - http://webroar.in/
# Copyright (C) 2009  WebROaR
#
# This file is part of WebROaR.
#
# WebROaR is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# WebROaR is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with WebROaR.  If not, see <http://www.gnu.org/licenses/>.
#++

#This is the model class UrlBreakupTimeSample related to the url_breakup_samples table in the database.
class UrlBreakupTimeSample < ActiveRecord::Base
  class << self
    #This method gives the data details for the url in the table. The url data is retrived with the help of url ids.
    #The array of url id is supplied as input to this method.
    def get_url_breakup_sample_data(url_id)
#      url_id_array_size = url_id.size
      criteria = "url_sample_id in (" + (url_id.join(", ") || '') + ')'      
#      for i in 0..url_id_array_size-1
#        str1 =	str1 + "url_sample_id ="+url_id[i].to_s
#        if i != url_id_array_size-1
#          str1 = str1 + " or "
#        end
#      end
      query_str = "select method_name, sum(spent_time) as time_spent from url_breakup_time_samples where " + criteria + " group by method_name order by time_spent desc"
      url_breakup_sample = find_by_sql(query_str)
      return url_breakup_sample
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
webroar-0.2.2	src/admin_panel/app/models/url_breakup_time_sample.rb