unders · November 1, 2012 13:29
diff --git a/outer_join_with_arel.rb b/outer_join_with_arel.rb
 bt = Brand.arel_table
 bft = BrandFollower.arel_table
 user = User.first

 outer_join = Arel::Nodes::OuterJoin.new(bft, Arel::Nodes::On.new(bft[:brand_id].eq(bt[:id])))
 brand_follower = bft[:role].eq(:editor).and(bft[:follower_id].eq(user.id))

 Brand.joins(outer_join).where(bt[:published].eq(true).or(brand_follower))
	bt = Brand.arel_table
	bft = BrandFollower.arel_table
	user = User.first

	outer_join = Arel::Nodes::OuterJoin.new(bft, Arel::Nodes::On.new(bft[:brand_id].eq(bt[:id])))
	brand_follower = bft[:role].eq(:editor).and(bft[:follower_id].eq(user.id))

	Brand.joins(outer_join).where(bt[:published].eq(true).or(brand_follower))