aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/select_manager_spec.rb
diff options
context:
space:
mode:
authorAaron Patterson <aaron.patterson@gmail.com>2010-09-07 15:10:27 -0700
committerAaron Patterson <aaron.patterson@gmail.com>2010-09-07 15:10:27 -0700
commit9f9b32544dd7711c41a31651e57f32a9b379e1d7 (patch)
treead1021958a82e7c4137fa71c9de71f8c003e7f57 /spec/arel/select_manager_spec.rb
parent40f31b6f5e9f570f92a65a6654d6b00d70cd922f (diff)
downloadrails-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.rb16
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"
}