From 8bc0fce00b9f64e328c18e98f82780e29dc5f554 Mon Sep 17 00:00:00 2001 From: Jon Leighton Date: Tue, 4 Jan 2011 07:11:34 +0800 Subject: Allow HAVING to take multiple conditions, like WHERE --- test/test_select_manager.rb | 17 ++++++++++++++++- 1 file changed, 16 insertions(+), 1 deletion(-) (limited to 'test') 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 -- cgit v1.2.3