diff options
Diffstat (limited to 'spec/engines/sql/unit/relations/having_spec.rb')
-rw-r--r-- | spec/engines/sql/unit/relations/having_spec.rb | 78 |
1 files changed, 0 insertions, 78 deletions
diff --git a/spec/engines/sql/unit/relations/having_spec.rb b/spec/engines/sql/unit/relations/having_spec.rb deleted file mode 100644 index 931e8d0a06..0000000000 --- a/spec/engines/sql/unit/relations/having_spec.rb +++ /dev/null @@ -1,78 +0,0 @@ -require 'spec_helper' - -module Arel - describe Having do - before do - @relation = Table.new(:developers) - end - - describe '#to_sql' do - describe 'when given a predicate' do - it "manufactures sql with where clause conditions" do - sql = @relation.group(@relation[:department]).having("MIN(salary) > 1000").to_sql - - adapter_is :mysql do - sql.should be_like(%Q{ - SELECT `developers`.`id`, `developers`.`name`, `developers`.`salary`, `developers`.`department`, `developers`.`created_at` - FROM `developers` - GROUP BY `developers`.`department` - HAVING MIN(salary) > 1000 - }) - end - - adapter_is :oracle do - sql.should be_like(%Q{ - SELECT "DEVELOPERS"."ID", "DEVELOPERS"."NAME", "DEVELOPERS"."SALARY", "DEVELOPERS"."DEPARTMENT", "DEVELOPERS"."CREATED_AT" - FROM "DEVELOPERS" - GROUP BY "DEVELOPERS"."DEPARTMENT" - HAVING MIN(salary) > 1000 - }) - end - - adapter_is_not :mysql, :oracle do - sql.should be_like(%Q{ - SELECT "developers"."id", "developers"."name", "developers"."salary", "developers"."department", "developers"."created_at" - FROM "developers" - GROUP BY "developers"."department" - HAVING MIN(salary) > 1000 - }) - end - end - end - - describe 'when given two predicates' do - it "manufactures sql with where clause conditions joined by AND" do - sql = @relation.group(@relation[:department]).having("MIN(salary) > 1000", "MAX(salary) < 10000").to_sql - - adapter_is :mysql do - sql.should be_like(%Q{ - SELECT `developers`.`id`, `developers`.`name`, `developers`.`salary`, `developers`.`department`, `developers`.`created_at` - FROM `developers` - GROUP BY `developers`.`department` - HAVING MIN(salary) > 1000 AND MAX(salary) < 10000 - }) - end - - adapter_is :oracle do - sql.should be_like(%Q{ - SELECT "DEVELOPERS"."ID", "DEVELOPERS"."NAME", "DEVELOPERS"."SALARY", "DEVELOPERS"."DEPARTMENT", "DEVELOPERS"."CREATED_AT" - FROM "DEVELOPERS" - GROUP BY "DEVELOPERS"."DEPARTMENT" - HAVING MIN(salary) > 1000 AND MAX(salary) < 10000 - }) - end - - adapter_is_not :mysql, :oracle do - sql.should be_like(%Q{ - SELECT "developers"."id", "developers"."name", "developers"."salary", "developers"."department", "developers"."created_at" - FROM "developers" - GROUP BY "developers"."department" - HAVING MIN(salary) > 1000 AND MAX(salary) < 10000 - }) - end - end - end - end - end -end - |