X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/68bb9b3b812a929ac7b281e4a49d772b6de747a7..38b9f8f7927f09b32a94df87d1264f568f620480:/script/statistics?ds=inline
diff --git a/script/statistics b/script/statistics
index 4ceb92cfc..ce785bb07 100755
--- a/script/statistics
+++ b/script/statistics
@@ -1,7 +1,6 @@
#!/usr/bin/env ruby
require File.dirname(__FILE__) + '/../config/environment'
-require 'generator'
start_time = Time.now
@@ -16,11 +15,11 @@ puts "
OpenStreetMap stats report run at #{start_time.to_s}
"
begin
ActiveRecord::Base.transaction do
- user_count = User.count(:conditions => { :status => ["active", "confirmed", "suspended"] })
- tracepoint_count = Tracepoint.count()
- node_count = Node.count(:conditions => "visible = true")
- way_count = Way.count(:conditions => "visible = true")
- relation_count = Relation.count(:conditions => "visible = true")
+ user_count = User.where(:status => ["active", "confirmed", "suspended"]).count
+ tracepoint_count = Tracepoint.count
+ node_count = Node.where(:visible => true).count
+ way_count = Way.where(:visible => true).count
+ relation_count = Relation.where(:visible => true).count
puts ""
puts "Number of users | #{user_count} |
"
@@ -34,7 +33,7 @@ begin
puts ""
puts "User | Number of Points |
"
- Trace.sum(:size, :conditions => { :inserted => true }, :group => :user_id, :order => "sum_size DESC", :limit => 50).each do |user, count|
+ Trace.where(:inserted => true).group(:user_id).order("sum_size DESC").limit(50).sum(:size).each do |user, count|
display_name = User.find(user).display_name.gsub('@', ' at ').gsub('.', ' dot ')
puts "#{display_name} | #{count} |
"
end
@@ -45,21 +44,15 @@ begin
puts ""
puts "Data Type | Day | Week | Month |
"
- day_count = Trace.count(:user_id, :distinct => true,
- :conditions => "timestamp > NOW() - '1 DAY'::INTERVAL")
- week_count = Trace.count(:user_id, :distinct => true,
- :conditions => "timestamp > NOW() - '7 DAYS'::INTERVAL")
- month_count = Trace.count(:user_id, :distinct => true,
- :conditions => "timestamp > NOW() - '28 DAYS'::INTERVAL")
+ day_count = Trace.where("timestamp > NOW() - '1 DAY'::INTERVAL").distinct.count(:user_id)
+ week_count = Trace.where("timestamp > NOW() - '7 DAYS'::INTERVAL").distinct.count(:user_id)
+ month_count = Trace.where("timestamp > NOW() - '28 DAYS'::INTERVAL").distinct.count(:user_id)
puts "GPX Files | #{day_count} | #{week_count} | #{month_count} |
"
- day_count = OldNode.count(:user_id, :distinct => true, :joins => :changeset,
- :conditions => "timestamp > NOW() - '1 DAY'::INTERVAL")
- week_count = OldNode.count(:user_id, :distinct => true, :joins => :changeset,
- :conditions => "timestamp > NOW() - '7 DAYS'::INTERVAL")
- month_count = OldNode.count(:user_id, :distinct => true, :joins => :changeset,
- :conditions => "timestamp > NOW() - '28 DAYS'::INTERVAL")
+ day_count = OldNode.where("timestamp > NOW() - '1 DAY'::INTERVAL").joins(:changeset).distinct.count(:user_id)
+ week_count = OldNode.where("timestamp > NOW() - '7 DAYS'::INTERVAL").joins(:changeset).distinct.count(:user_id)
+ month_count = OldNode.where("timestamp > NOW() - '28 DAYS'::INTERVAL").joins(:changeset).distinct.count(:user_id)
puts "Nodes | #{day_count} | #{week_count} | #{month_count} |
"
@@ -69,17 +62,11 @@ begin
puts ""
puts "Day | Week | Month |
"
- day_users = OldNode.count(:conditions => "timestamp > NOW() - '1 DAY'::INTERVAL",
- :joins => :changeset, :group => :user_id,
- :order => "count_all DESC")
- week_users = OldNode.count(:conditions => "timestamp > NOW() - '7 DAYS'::INTERVAL",
- :joins => :changeset, :group => :user_id,
- :order => "count_all DESC", :limit => 60)
- month_users = OldNode.count(:conditions => "timestamp > NOW() - '28 DAYS'::INTERVAL",
- :joins => :changeset, :group => :user_id,
- :order => "count_all DESC", :limit => 60)
-
- SyncEnumerator.new(day_users, week_users, month_users).each do |row|
+ day_users = OldNode.where("timestamp > NOW() - '1 DAY'::INTERVAL").joins(:changeset).order("count_all DESC").group(:user_id).count
+ week_users = OldNode.where("timestamp > NOW() - '7 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(60).group(:user_id).count
+ month_users = OldNode.where("timestamp > NOW() - '28 DAYS'::INTERVAL").joins(:changeset).order("count_all DESC").limit(60).group(:user_id).count
+
+ day_users.zip(week_users, month_users).each do |row|
puts ""
row.each do |column|
if column.nil?