Rails: Tables Finder

rails_tables_finder.rb

# Example:
#
#   > TablesFinder.call(column_name: 'site_id')
#   => ['events', 'users']
class TablesFinder
  VALID_ATTRIBUTES = %w[
    COLUMN_NAME
  ].freeze

  def self.call(args)
    new(args).call
  end

  def initialize(args)
    @matcher_attribute = args.keys.first.to_s.upcase
    @matcher_value = args.values.first.to_s.downcase
  end

  def call
    return [] unless [matcher_attribute, matcher_value].all?
    return [] unless matcher_attribute.in?(VALID_ATTRIBUTES)

    find_tables
  end

  private

  attr_reader :matcher_attribute, :matcher_value

  def find_tables
    ActiveRecord::Base.connection.execute(
      "SELECT table_name FROM INFORMATION_SCHEMA.COLUMNS
      WHERE #{matcher_attribute} = '#{matcher_value}'
      ORDER BY TABLE_NAME"
    ).values.flatten
  end
end