Find empty account from mastodon

empty_account.rb

# frozen_string_literal: true
Account
  .local.without_suspended
  .where('accounts.created_at < ?', 30.days.ago)
  .where(note: '')
  .where(display_name: '')
  .where(avatar_file_name: nil)
  .where(
    Account.arel_table[:fields].eq(nil).or(
      Account.arel_table[:fields].eq([])
    )
  )
  .joins(:account_stat)
  .where('account_stats.statuses_count': 0)
  .find_in_batches do |accs|
    accs.each do |acc|
      p "#{acc.id} #{acc.username}"
      # SuspendAccountService.new.call(acc)
    end
  end

I added this to avoid suspending my own server actor.

.where('accounts.id > ?', 0)

EDIT: Filtering on the actor_type may be useful as well.