diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/tasks/stats.rake | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/lib/tasks/stats.rake b/lib/tasks/stats.rake new file mode 100644 index 000000000..1352abd8c --- /dev/null +++ b/lib/tasks/stats.rake @@ -0,0 +1,40 @@ +namespace :stats do + + desc 'Produce transaction stats' + task :show => :environment do + month_starts = (Date.new(2009, 1)..Date.new(2011, 5)).select { |d| d.day == 1 } + month_starts.each do |month_start| + month_end = month_start.end_of_month + puts "#{month_start}-#{month_end}" + date_conditions = ['created_at >= ? + AND created_at < ?', + month_start, month_end+1] + request_count = InfoRequest.count(:conditions => date_conditions) + puts "Requests sent: #{request_count}" + comment_count = Comment.count(:conditions => date_conditions) + puts "Annotations added: #{comment_count}" + track_conditions = ['track_type = ? + AND track_medium = ? + AND created_at >= ? + AND created_at < ?', + 'request_updates', 'email_daily', month_start, month_end+1] + email_request_track_count = TrackThing.count(:conditions => track_conditions) + puts "Track this request email signups: #{email_request_track_count}" + comment_on_own_request_conditions = ['comments.user_id = info_requests.user_id + AND comments.created_at >= ? + AND comments.created_at < ?', + month_start, month_end+1] + comment_on_own_request_count = Comment.count(:conditions => comment_on_own_request_conditions, + :include => :info_request) + + followup_conditions = ['message_type = ? + AND created_at >= ? + AND created_at < ?', + 'followup', month_start, month_end+1] + follow_up_count = OutgoingMessage.count(:conditions => followup_conditions) + comments_and_followup_count = comment_on_own_request_count.to_i + follow_up_count.to_i + puts "Comments on own requests, follow ups sent: #{comments_and_followup_count}" + end + end + +end
\ No newline at end of file |