summaryrefslogtreecommitdiffstats
path: root/tests/codeigniter/database/query_builder/truncate_test.php
diff options
context:
space:
mode:
authorTimothy Warren <tim@timshomepage.net>2012-05-16 14:48:13 +0200
committerTimothy Warren <tim@timshomepage.net>2012-05-16 14:48:13 +0200
commit351c2e1b0d3fdca80a5483d708d7c71084226e68 (patch)
tree749c6accebdf6da1c301f9c2ee76c78bfe15954e /tests/codeigniter/database/query_builder/truncate_test.php
parent2ed226bd5ed19754c2fb28d4b98ac5423741f039 (diff)
parent8279420f989a8cda4427c3983ee919c6a1073dd7 (diff)
Merge branch 'develop' of git://github.com/EllisLab/CodeIgniter into errors
Diffstat (limited to 'tests/codeigniter/database/query_builder/truncate_test.php')
-rw-r--r--tests/codeigniter/database/query_builder/truncate_test.php61
1 files changed, 61 insertions, 0 deletions
diff --git a/tests/codeigniter/database/query_builder/truncate_test.php b/tests/codeigniter/database/query_builder/truncate_test.php
new file mode 100644
index 000000000..2a9c8a91e
--- /dev/null
+++ b/tests/codeigniter/database/query_builder/truncate_test.php
@@ -0,0 +1,61 @@
+<?php
+
+class Truncate_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_truncate()
+ {
+ // Check initial record
+ $jobs = $this->db->get('job')->result_array();
+
+ $this->assertEquals(4, count($jobs));
+
+ // Do the empty
+ $this->db->truncate('job');
+
+ // Check the record
+ $jobs = $this->db->get('job');
+
+ $this->assertEmpty($jobs->result_array());
+ }
+
+ // ------------------------------------------------------------------------
+
+ /**
+ * @see ./mocks/schema/skeleton.php
+ */
+ public function test_truncate_with_from()
+ {
+ // Check initial record
+ $users = $this->db->get('user')->result_array();
+
+ $this->assertEquals(4, count($users));
+
+ // Do the empty
+ $this->db->from('user')
+ ->truncate();
+
+ // Check the record
+ $users = $this->db->get('user');
+
+ $this->assertEmpty($users->result_array());
+ }
+
+} \ No newline at end of file