Boilerplate code to test MySQL behavior with ActiveRecord

testing_mysql_with_active_record.rb

require 'bundler/inline'

gemfile do
  source 'https://rubygems.org'

  gem 'minitest'
  gem 'activerecord', require: 'active_record'
  gem 'mysql2'
end

require 'minitest/autorun'
require 'logger'

ActiveRecord::Base.logger = Logger.new(STDOUT)

config = { adapter: 'mysql2', host: '127.0.0.1', username: 'root', password: 'password' }
ActiveRecord::Base.establish_connection(config)
ActiveRecord::Base.connection.recreate_database('mysql_test')
ActiveRecord::Base.establish_connection(config.merge({ database: 'mysql_test' }))

ActiveRecord::Schema.define do
  create_table :accounts do |t|
    t.string :name, null: false
  end

  create_table :withdrawals do |t|
    t.string :title, null: false
    t.integer :amount, null: false, default: 0
    t.references :accounts, foreign_key: true
    t.datetime :created_at, null: false
  end
end

class Account < ActiveRecord::Base
  has_many :withdrawals
end

class Withdrawal < ActiveRecord::Base
  belongs_to :account
end

class MysqlTest < Minitest::Test
  def test_mysql
    # TODO: test
  end
end