diff options
author | Phil Sturgeon <email@philsturgeon.co.uk> | 2012-05-15 00:00:06 +0200 |
---|---|---|
committer | Phil Sturgeon <email@philsturgeon.co.uk> | 2012-05-15 00:00:06 +0200 |
commit | 212b0470e1aa288ba4f4d47d13647d6cd150fd15 (patch) | |
tree | f800288e4d064c8b9e1f1f1aa6f1a3c075918cb2 /tests/codeigniter/database/query_builder/count_test.php | |
parent | fff6c2a3caa1ce14e58fcb3ee0d937d17985eea1 (diff) | |
parent | 82196b945e291c65fdb66b35e3205f786ce8e921 (diff) |
Merge pull request #1324 from toopay/db-tests
Improved DB tests
Diffstat (limited to 'tests/codeigniter/database/query_builder/count_test.php')
-rw-r--r-- | tests/codeigniter/database/query_builder/count_test.php | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/tests/codeigniter/database/query_builder/count_test.php b/tests/codeigniter/database/query_builder/count_test.php new file mode 100644 index 000000000..5e691692d --- /dev/null +++ b/tests/codeigniter/database/query_builder/count_test.php @@ -0,0 +1,44 @@ +<?php + +class Count_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_count_all() + { + $job_count = $this->db->count_all('job'); + + // Check the result + $this->assertEquals(4, $job_count); + } + + // ------------------------------------------------------------------------ + + /** + * @see ./mocks/schema/skeleton.php + */ + public function test_count_all_results() + { + $job_count = $this->db->like('name', 'ian') + ->count_all_results('job'); + + // Check the result + $this->assertEquals(2, $job_count); + } +}
\ No newline at end of file |