aboutsummaryrefslogtreecommitdiffstats
path: root/test
diff options
context:
space:
mode:
authorJon Leighton <j@jonathanleighton.com>2011-01-04 07:11:34 +0800
committerAaron Patterson <aaron.patterson@gmail.com>2011-01-04 07:19:58 +0800
commit8bc0fce00b9f64e328c18e98f82780e29dc5f554 (patch)
tree791d2d112adb4d21c5e8d1a333b55eb39de0be6a /test
parent597fe1580902f9ae661992448c966bc6372d5ba0 (diff)
downloadrails-8bc0fce00b9f64e328c18e98f82780e29dc5f554.tar.gz
rails-8bc0fce00b9f64e328c18e98f82780e29dc5f554.tar.bz2
rails-8bc0fce00b9f64e328c18e98f82780e29dc5f554.zip
Allow HAVING to take multiple conditions, like WHERE
Diffstat (limited to 'test')
-rw-r--r--test/test_select_manager.rb17
1 files changed, 16 insertions, 1 deletions
diff --git a/test/test_select_manager.rb b/test/test_select_manager.rb
index 7c8da972e1..271a8ae0b0 100644
--- a/test/test_select_manager.rb
+++ b/test/test_select_manager.rb
@@ -99,13 +99,28 @@ module Arel
end
end
- describe '#having' do
+ describe 'having' do
it 'converts strings to SQLLiterals' do
table = Table.new :users
mgr = table.from table
mgr.having 'foo'
mgr.to_sql.must_be_like %{ SELECT FROM "users" HAVING foo }
end
+
+ it 'can have multiple items specified separately' do
+ table = Table.new :users
+ mgr = table.from table
+ mgr.having 'foo'
+ mgr.having 'bar'
+ mgr.to_sql.must_be_like %{ SELECT FROM "users" HAVING foo AND bar }
+ end
+
+ it 'can have multiple items specified together' do
+ table = Table.new :users
+ mgr = table.from table
+ mgr.having 'foo', 'bar'
+ mgr.to_sql.must_be_like %{ SELECT FROM "users" HAVING foo AND bar }
+ end
end
end