public function testRollback() { // start - test a transaction $this->db->beginTransaction(); $data = array('page_template' => 'tpl_test_new4', 'page_type' => 'öäü'); // will return the auto-increment value of the new row $resultInsert = $this->db->insert($this->tableName, $data); self::assertGreaterThan(1, $resultInsert); $data = array('page_type' => 'lall'); $where = array('page_id' => $resultInsert); $this->db->update($this->tableName, $data, $where); $data = array('page_type' => 'lall', 'page_lall' => 'öäü'); $where = array('page_id' => $resultInsert); $this->db->update($this->tableName, $data, $where); // end - test a transaction, with a rollback! $this->db->rollback(); $where = array('page_id' => $resultInsert); $resultSelect = $this->db->select($this->tableName, $where); self::assertEquals(0, $resultSelect->num_rows); }