aboutsummaryrefslogtreecommitdiffstats
path: root/spec/engines/sql/unit/relations/having_spec.rb
diff options
context:
space:
mode:
Diffstat (limited to 'spec/engines/sql/unit/relations/having_spec.rb')
-rw-r--r--spec/engines/sql/unit/relations/having_spec.rb78
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
-