Contents

require File.dirname(__FILE__) + '/helper'

context "Joins" do
  specify "simple == on an association" do
    sql = User.select { |m| m.account.email == '[e-mail]' }
    sql.to_hash.should ==  { 
      :conditions => "accounts.email = '[e-mail]'", 
      :include => [:account] 
    }
  end

  specify "simple mixed == on an association" do
    sql = User.select { |m| m.name == 'chris' && m.account.email == '[e-mail]' }
    sql.to_hash.should ==  { 
      :conditions => "(users.`name` = 'chris' AND accounts.email = '[e-mail]')", 
      :include => [:account] 
    }
  end

  specify "multiple associations" do
    sql = User.select { |m| m.ideas.title == 'New Freezer' || m.invites.email == '[e-mail]' }
    sql.to_hash.should ==  { 
      :conditions => "(ideas.title = 'New Freezer' OR invites.email = '[e-mail]')",
      :include => [:ideas, :invites]
    }
  end

  specify "non-existant associations" do
    sql = User.select { |m| m.liquor.brand == 'Jack' }
    should.raise { sql.to_hash } 
  end
end

Version data entries

3 entries across 2 versions & 1 rubygems

Version	Path
ambition-0.1.1	test/join_test.rb
ambition-0.1.0	./test/join_test.rb
ambition-0.1.1	./test/join_test.rb