X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/dc09bde7f7b28b275b83349ac2a19c59feff2145..500e6e687f2d8e87d0797fbd9373d84c7b24d628:/script/statistics
diff --git a/script/statistics b/script/statistics
index 13a26592a..50363dc32 100755
--- a/script/statistics
+++ b/script/statistics
@@ -32,11 +32,11 @@ begin
puts "
Number of ways with tags | #{tagged_way_count} |
"
puts ""
- puts "Top 10 users for uploads of GPS data
"
+ puts "Top 50 users for uploads of GPS data
"
puts ""
puts "User | Number of Points |
"
- Trace.sum(:size, :group => :user_id, :order => "sum_size DESC", :limit => 10).each do |user, count|
+ Trace.sum(:size, :group => :user_id, :order => "sum_size DESC", :limit => 50).each do |user, count|
display_name = User.find(user).display_name.gsub('@', ' at ').gsub('.', ' dot ')
puts "#{display_name} | #{count} |
"
end
@@ -76,18 +76,20 @@ begin
puts "Day | Week | Month |
"
day_users = OldNode.count(:conditions => "timestamp > NOW() - INTERVAL 1 DAY",
- :group => :user_id, :order => "count_all DESC", :limit => 60)
+ :group => :user_id, :order => "count_all DESC")
week_users = OldNode.count(:conditions => "timestamp > NOW() - INTERVAL 7 DAY",
:group => :user_id, :order => "count_all DESC", :limit => 60)
month_users = OldNode.count(:conditions => "timestamp > NOW() - INTERVAL 28 DAY",
:group => :user_id, :order => "count_all DESC", :limit => 60)
- day_users = day_users.keys.map { |u| User.find(u).display_name.gsub('@', ' at ').gsub('.', ' dot ') }
- week_users = week_users.keys.map { |u| User.find(u).display_name.gsub('@', ' at ').gsub('.', ' dot ') }
- month_users = month_users.keys.map { |u| User.find(u).display_name.gsub('@', ' at ').gsub('.', ' dot ') }
-
- SyncEnumerator.new(day_users, week_users, month_users).each do |day,week,month|
- puts "#{day} | #{week} | #{month} |
"
+ SyncEnumerator.new(day_users, week_users, month_users).each do |row|
+ puts ""
+ row.each do |column|
+ display_name = User.find(column[0]).display_name.gsub('@', ' at ').gsub('.', ' dot ')
+ count = column[1]
+ puts "#{count} #{display_name} | "
+ end
+ puts "
"
end
puts "
"