diff options
author | Aaron Patterson <aaron.patterson@gmail.com> | 2010-09-07 15:10:27 -0700 |
---|---|---|
committer | Aaron Patterson <aaron.patterson@gmail.com> | 2010-09-07 15:10:27 -0700 |
commit | 9f9b32544dd7711c41a31651e57f32a9b379e1d7 (patch) | |
tree | ad1021958a82e7c4137fa71c9de71f8c003e7f57 /spec/arel/select_manager_spec.rb | |
parent | 40f31b6f5e9f570f92a65a6654d6b00d70cd922f (diff) | |
download | rails-9f9b32544dd7711c41a31651e57f32a9b379e1d7.tar.gz rails-9f9b32544dd7711c41a31651e57f32a9b379e1d7.tar.bz2 rails-9f9b32544dd7711c41a31651e57f32a9b379e1d7.zip |
getting better on joins
Diffstat (limited to 'spec/arel/select_manager_spec.rb')
-rw-r--r-- | spec/arel/select_manager_spec.rb | 16 |
1 files changed, 16 insertions, 0 deletions
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,9 +63,25 @@ 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" ON "users"."id" = "users_2"."id" } |