Tests the join sql

habtm_test_with_arel_master.rb

require 'rubygems'
require 'test/unit'
require 'arel' # master
require 'active_record'

ActiveRecord::Base.establish_connection(
  :adapter => defined?(JRUBY_VERSION) ? 'jdbcsqlite3' : 'sqlite3',
  :database => ':memory:'
)

users_table = %{CREATE TABLE users (id INTEGER PRIMARY KEY);}
records_table = %{CREATE TABLE records (id INTEGER PRIMARY KEY);}
records_users_table = %{CREATE TABLE records_users (user_id INTEGER NOT NULL, record_id INTEGER NOT NULL);}

ActiveRecord::Base.connection.execute(users_table)
ActiveRecord::Base.connection.execute(records_table)
ActiveRecord::Base.connection.execute(records_users_table)

class User < ActiveRecord::Base
  has_and_belongs_to_many :records
end

class Record < ActiveRecord::Base
  has_and_belongs_to_many :users
end

class HBTMTest < Test::Unit::TestCase
  def test_sql
    expected_sql = %{INNER JOIN "records_users" ON "records_users"."user_id" = "users"."id" INNER JOIN "records" ON "records"."id" = "records_users"."record_id"}
    assert_equal expected_sql, User.joins(:records).join_sql
  end
end