Database Shared Connection

batch.rb

require 'securerandom'
require 'lib/job'

class Batch
  
  attr_reader :id, :db
  attr_accessor :jobs
  
  # pass in database connection
  def initialize(jobs, db)
    @id = SecureRandom.uuid
    @jobs = jobs
    @db = db
  end
  
  def run
    @jobs.each do |job|
      job.run
    end
  end
  
  def save
    @db['batches'].insert(:id => @id)
  end
end

job.rb

require 'securerandom'

class Job
  
  attr_reader :id, :url, :db
  
  # passing in database connection
  def initialize(url, db)
    @url = url
    @id = SecureRandom.uuid
    @db = db
  end
  
  def run
    results = # Make HTTP request
    save(results)
  end
  
  def save
    @db['jobs'].insert(:id => @id, :results => results)
  end
end

test.rb

require 'sequel'
require 'lib/job'
require 'lib/batch'

db = Sequel.connect('my sequel connection')
job1 = Job.new('test.com', db)
job2 = Job.new('test1.com', db)
jobs = [job1, job2]
batch = Batch.new(jobs, db)
batch.run