Production script for generating a CSV of practice managed Mettle-resold companies. Pending Looker report.

mettle_practice_managed_report.rb

switch_to_slave_db

require "csv"

headers = ["Name", "Email", "Subdomain", "Bank Account ID", "Practice Name"]

mettle = Reseller.find_by_name("mettle")

csv_string = CSV.generate(headers: headers, write_headers: true) do |csv|
  Company.where(reseller: mettle).where.not(account_manager: nil).each do |c|
    csv << [
      # The bank name usually includes 'mettle'
      c.name, c.account_owner.email, c.subdomain, c.bank_accounts.where("bank_name LIKE 'mettle%'").take&.id,
      c.account_manager.accountancy_practice.name
    ]
  end
end

puts csv_string