DRY in ActiveJob::Base

Question

I need to use sanitization in Jobs, so i wrote method

  def sanitized_sql_statement(query)
    ActiveRecord::Base.send(
        :sanitize_sql_array,
        query
    )
  end

I have 2 different job files. Where I should place this method and how to use it from Jobs?

Answer 1

Use concern.
create concerns directory under jobs directory app/jobs/concerns like models and controllers do.

write concern file.

module SqlSanitizer
  extend ActiveSupport::Concern

  def sanitized_sql_statement(query)
    ActiveRecord::Base.send(
      :sanitize_sql_array,
      query
    )
  end
end

And include in your job

class YourJob < ActiveJob::Base
  include SqlSanitizer

  # ... do something
end

If you fail to auto load SqlSanitizer, add autoload path in config/application.rb file => config.autoload_paths << "#{Rails.root}/app/jobs/concerns"