pythonandchips

def backfill_bill_items
  bills = Bill.all

  progress_bar = ProgressBar.new(bills.count)

  # Keeping the batch size low to reduce the time we are locking the 100 records
  # for update
  bills.select(
    :id,
    :contact_id,

pythonandchips

def fix_sent_invoices(company_id, reference)
  company = Company.find(company_id)
  invoices = company.invoices.where(company_id: company_id, reference: reference)

  return "Only #{invoices.length} found" if invoices.length < 2
  puts "update #{invoices.length} invoices (#{invoices.map(&:id).join(",")}) for #{company.subdomain}?"
  confirm = gets.chomp

  return unless confirm == "y"

pythonandchips

require "perform_on_replica"

def find_duplicate_references
  PerformOnReplica.perform_on_replica do
    companies = Company.all

    progress_bar = ProgressBar.new(companies.count)
    companies.includes(:subscription).find_each do |company|
      references = company.invoices.
        group(:reference).

pythonandchips

def delete_all_recurring_invoices
  progress_bar = ProgressRateLimiter.new(count: Invoice.where(type: "RecurringInvoice").count)

  Invoice.where(type: "RecurringInvoice").find_each do |recurring_invoice|
    recurring_invoice.destroy!
    progress_bar.increment!
  end
end

pythonandchips

def backfill_recurring_invoice_profile_id
  ids = RecurringInvoiceProfile.select(:id)

  progress_bar = ProgressBar.new(ids.count)

  RecurringInvoiceProfile.select(:id).find_each do |recurring_invoice_profile|
    Invoice.where(recurring_invoice_id: recurring_invoice_profile.id).
      update_all(recurring_invoice_profile_id: recurring_invoice_profile.id)

    progress_bar.increment!

pythonandchips

<div class="data-table">
  <%= form_with url: search_path, method: :get do |f| %>
    <div class="data-table_controls">
      <div class="data-table_length">
        <%= f.label "page_size" do %>
          Show
          <%= f.select "page_size", options_for_select([10, 25, 50, 100], @collection.per_page) %>
          entries
        <% end %>
      </div>

pythonandchips

require "benchmark"
require "perform_on_replica"


company = Company.find(126455)

class BenchmarkExporter 
  include PerformOnReplica

  def initialize(company)

pythonandchips

switch_to_slave_db

companies = Company.joins(:subscription).merge(Subscription.live)
companies_count = companies.count
progress_bar = ProgressBar.new(companies_count)
ProgressBar.new(companies_count)

companies.find_each do |company|
  Rails.logger.info({
    event: "COMPANY_OVERDUE_INVOICE_COUNT",

pythonandchips

negative_recurring_invoice_profiles = []
count = RecurringInvoiceProfile.active.count
progress = ProgressBar.new(count)

RecurringInvoiceProfile.includes(
  :company,
  :contact,
  {recurring_invoice_profile_items: [:general_ledger_account, :company]},
).active.find_each do |recurring_invoice_profile|

pythonandchips

class CompareRecurringInvoiceProfiles
  def self.perform
    recurring_invoice_count = RecurringInvoiceProfile.count
    progress = ProgressBar.new(recurring_invoice_count)
    RecurringInvoiceProfile.all.find_each do |recurring_invoice_profile|
      render_and_compare(recurring_invoice_profile.source_recurring_invoice, recurring_invoice_profile)

      progress.increment!
    end
  end