Get a list of businesses and ads counts

businesses_and_ads.rb

range = Date.new(2014,12,1)..Date.new(2014,12,31)

# Gets the list of businesses that ran ads in "range" and the ad count
Business.joins(:ads).where(ads: {publisher_id: 365, start_date:range}).uniq.map do |business|
  "#{business.name}, #{business.ads.where(publisher_id: 365, start_date: range).count}"
end.each { |elem| puts elem }; 1

# Gets the list of ads that ran for a given publisher with the business name, business uuid
Business.joins(:ads).where(ads: {publisher_id: 365, start_date:range}).uniq.each do |business|
  puts "#{business.uuid},#{business.name},#{business.custom_id}"
end

# Gets the list of ads that ran for a given publisher with the business name, business uuid and ad file name
CSV.open("/home/<user>/businesses.csv", "wb") do |csv|
  Business.joins(:ads).where(ads: {publisher_id: 575, start_date:range}).each do |business|
    business.ads.where(publisher_id: 575, start_date:range).each do |ad|
      csv << [business.uuid,business.name,business.custom_id,ad.pdf_file_name]
    end
  end
end