From 9f9b32544dd7711c41a31651e57f32a9b379e1d7 Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Tue, 7 Sep 2010 15:10:27 -0700 Subject: getting better on joins --- spec/arel/select_manager_spec.rb | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'spec/arel') diff --git a/spec/arel/select_manager_spec.rb b/spec/arel/select_manager_spec.rb index f894d3230a..800018aa7d 100644 --- a/spec/arel/select_manager_spec.rb +++ b/spec/arel/select_manager_spec.rb @@ -63,7 +63,23 @@ module Arel predicate = left[:id].eq(right[:id]) manager = Arel::SelectManager.new Table.engine + manager.from left manager.join(right).on(predicate) + manager.to_sql.should be_like %{ + SELECT FROM "users" + INNER JOIN "users" "users_2" + ON "users"."id" = "users_2"."id" + } + end + + it 'takes a class' do + left = Table.new :users + right = left.alias + predicate = left[:id].eq(right[:id]) + manager = Arel::SelectManager.new Table.engine + + manager.from left + manager.join(right, Nodes::OuterJoin).on(predicate) manager.to_sql.should be_like %{ SELECT FROM "users" OUTER JOIN "users" "users_2" -- cgit v1.2.3