aboutsummaryrefslogtreecommitdiffstats
path: root/test
diff options
context:
space:
mode:
authorSean Griffin <sean@seantheprogrammer.com>2015-12-17 12:55:27 -0700
committerSean Griffin <sean@seantheprogrammer.com>2015-12-17 12:55:34 -0700
commit1dba173bbbf53b8734e01ff49479c58a55234ffa (patch)
tree55e2b126325cbfea1348bcd856610ce8d9f8bcc0 /test
parentdad0e081c4dc9dbbcdb195ff4e7f9ad4d2bc6de3 (diff)
parentcd395b9419ac3a860ee78cf9706af1bf7d86fe92 (diff)
downloadrails-1dba173bbbf53b8734e01ff49479c58a55234ffa.tar.gz
rails-1dba173bbbf53b8734e01ff49479c58a55234ffa.tar.bz2
rails-1dba173bbbf53b8734e01ff49479c58a55234ffa.zip
Merge pull request #349 from edpaget/delegate-where-sql-visitor
Delegate to Connection Visitor in WhereSQL Visitor
Diffstat (limited to 'test')
-rw-r--r--test/test_select_manager.rb21
1 files changed, 21 insertions, 0 deletions
diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb
index 8425cee031..e6b13e748d 100644
--- a/test/test_select_manager.rb
+++ b/test/test_select_manager.rb
@@ -968,6 +968,27 @@ module Arel
manager.where_sql.must_be_like %{ WHERE "users"."id" = 10 }
end
+ it 'joins wheres with AND' do
+ table = Table.new :users
+ manager = Arel::SelectManager.new
+ manager.from table
+ manager.where table[:id].eq 10
+ manager.where table[:id].eq 11
+ manager.where_sql.must_be_like %{ WHERE "users"."id" = 10 AND "users"."id" = 11}
+ end
+
+ it 'handles database specific statements' do
+ old_visitor = Table.engine.connection.visitor
+ Table.engine.connection.visitor = Visitors::PostgreSQL.new Table.engine.connection
+ table = Table.new :users
+ manager = Arel::SelectManager.new
+ manager.from table
+ manager.where table[:id].eq 10
+ manager.where table[:name].matches 'foo%'
+ manager.where_sql.must_be_like %{ WHERE "users"."id" = 10 AND "users"."name" ILIKE 'foo%' }
+ Table.engine.connection.visitor = old_visitor
+ end
+
it 'returns nil when there are no wheres' do
table = Table.new :users
manager = Arel::SelectManager.new