From: Tom Hughes <tom@compton.nu>
Date: Thu, 15 Oct 2009 10:09:33 +0000 (+0000)
Subject: Ignore traces which have not been inserted yet when calculating
X-Git-Tag: live~6560
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/138a9d97644d8cba566cf840edd524fc9947ac1a?ds=inline

Ignore traces which have not been inserted yet when calculating
the per-user statistics.
---

diff --git a/script/statistics b/script/statistics
index f04879359..afd5dd7d2 100755
--- a/script/statistics
+++ b/script/statistics
@@ -34,7 +34,7 @@ begin
     puts "<table>"
     puts "<tr><th>User</th><th>Number of Points</th></tr>"
 
-    Trace.sum(:size, :group => :user_id, :order => "sum_size DESC", :limit => 50).each do |user, count|
+    Trace.sum(:size, :conditions => { :inserted => true }, :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 "<tr><td><a href=\"/user/#{display_name}\">#{display_name}</a></td><td>#{count}</td></tr>"
     end