class WarpEngine::DownloadStatsService

# File app/services/warp_engine/download_stats_service.rb, line 33
def for_release(release)
  by_file(Download.where(release_id: release.id))
end

# File app/services/warp_engine/download_stats_service.rb, line 40
def for_software(software)
  releases = software.releases.to_a
  {
    total:    Download.joins(:release).where(releases: { software_id: software.id }).count,
    releases: releases.map do |release|
      files = for_release(release)
      { release_id: release.id, version: release.version, downloads: files.sum { |f| f[:downloads] }, files: files }
    end
  }
end

# File app/services/warp_engine/download_stats_service.rb, line 6
def summary(now: Time.current)
  {
    total: Download.count,
    today: Download.where(created_at: now.beginning_of_day..).count,
    week:  Download.where(created_at: 1.week.ago(now)..).count,
    month: Download.where(created_at: 1.month.ago(now)..).count
  }
end

# File app/services/warp_engine/download_stats_service.rb, line 17
def top_files(limit: 10)
  by_file(Download.all).first(limit)
end

# File app/services/warp_engine/download_stats_service.rb, line 23
def top_softwares(limit: 5)
  Download.joins(release: :software)
          .group("softwares.id", "softwares.name", "softwares.title")
          .order(Arel.sql("COUNT(*) DESC"))
          .limit(limit)
          .count
          .map { |(id, name, title), count| { software_id: id, name: name, title: title, downloads: count } }
end