summaryrefslogtreecommitdiffstats
path: root/tests/codeigniter/database/query_builder/group_test.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/codeigniter/database/query_builder/group_test.php')
-rw-r--r--tests/codeigniter/database/query_builder/group_test.php120
1 files changed, 0 insertions, 120 deletions
diff --git a/tests/codeigniter/database/query_builder/group_test.php b/tests/codeigniter/database/query_builder/group_test.php
deleted file mode 100644
index df3f168c6..000000000
--- a/tests/codeigniter/database/query_builder/group_test.php
+++ /dev/null
@@ -1,120 +0,0 @@
-<?php
-
-class Group_test extends CI_TestCase {
-
- /**
- * @var object Database/Query Builder holder
- */
- protected $db;
-
- public function set_up()
- {
- $this->db = Mock_Database_Schema_Skeleton::init(DB_DRIVER);
-
- Mock_Database_Schema_Skeleton::create_tables();
- Mock_Database_Schema_Skeleton::create_data();
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_group_by()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->get()
- ->result_array();
-
- $this->assertCount(4, $jobs);
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_having_by()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->having('SUM(id) > 2')
- ->get()
- ->result_array();
-
- $this->assertCount(2, $jobs);
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_having_in()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->having_in('SUM(id)', array(1, 2, 5))
- ->get()
- ->result_array();
-
- $this->assertCount(2, $jobs);
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_or_having_in()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->or_having_in('SUM(id)', array(1, 5))
- ->or_having_in('SUM(id)', array(2, 6))
- ->get()
- ->result_array();
-
- $this->assertCount(2, $jobs);
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_having_not_in()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->having_not_in('SUM(id)', array(3, 6))
- ->get()
- ->result_array();
-
- $this->assertCount(3, $jobs);
- }
-
- // ------------------------------------------------------------------------
-
- /**
- * @see ./mocks/schema/skeleton.php
- */
- public function test_or_having_not_in()
- {
- $jobs = $this->db->select('name')
- ->from('job')
- ->group_by('name')
- ->or_having_not_in('SUM(id)', array(1, 2, 3))
- ->or_having_not_in('SUM(id)', array(1, 3, 4))
- ->get()
- ->result_array();
-
- $this->assertCount(2, $jobs);
- }
-}