public function testBasics() { require_once 'Foobar.php'; // insert - true $pageArray = array('page_template' => 'tpl_new', 'page_type' => 'lall'); $tmpId = $this->db->insert($this->tableName, $pageArray); // insert - false $false = $this->db->insert($this->tableName); self::assertEquals(false, $false); // insert - false $false = $this->db->insert('', $pageArray); self::assertEquals(false, $false); // select - true $result = $this->db->select($this->tableName, "page_id = {$tmpId}"); $tmpPage = $result->fetchObject(); self::assertEquals('tpl_new', $tmpPage->page_template); // select - true $result = $this->db->select($this->tableName, "page_id = {$tmpId}"); $tmpPage = $result->fetchObject('stdClass'); self::assertEquals('tpl_new', $tmpPage->page_template); // select - true $result = $this->db->select($this->tableName, "page_id = {$tmpId}"); $tmpPage = $result->fetchObject('Foobar', array(array('foo' => 1, 'bar' => 2))); self::assertEquals(1, $tmpPage->foo); self::assertEquals(2, $tmpPage->bar); self::assertEquals(null, $tmpPage->nothing); self::assertEquals('tpl_new', $tmpPage->page_template); $tmpPage = $result->fetchAllObject('Foobar', array(array('foo' => 1, 'bar' => 2))); self::assertEquals(1, $tmpPage[0]->foo); self::assertEquals(2, $tmpPage[0]->bar); self::assertEquals(null, $tmpPage[0]->nothing); self::assertEquals('tpl_new', $tmpPage[0]->page_template); $tmpPage = $result->fetchAllObject('Foobar'); self::assertEquals(null, $tmpPage[0]->foo); self::assertEquals(null, $tmpPage[0]->bar); self::assertEquals('lall', $tmpPage[0]->page_type); self::assertEquals('tpl_new', $tmpPage[0]->page_template); // update - true $pageArray = array('page_template' => 'tpl_update'); $this->db->update($this->tableName, $pageArray, "page_id = {$tmpId}"); // update - false $false = $this->db->update($this->tableName, array(), "page_id = {$tmpId}"); self::assertEquals(false, $false); // update - false $false = $this->db->update($this->tableName, $pageArray, ""); self::assertEquals(false, $false); // update - false $false = $this->db->update($this->tableName, $pageArray, null); self::assertEquals(false, $false); // update - false $false = $this->db->update('', $pageArray, "page_id = {$tmpId}"); self::assertEquals(false, $false); // check (select) $result = $this->db->select($this->tableName, "page_id = {$tmpId}"); $tmpPage = $result->fetchAllObject(); self::assertEquals('tpl_update', $tmpPage[0]->page_template); // replace - true $data = array('page_id' => 2, 'page_template' => 'tpl_test', 'page_type' => 'öäü123'); $tmpId = $this->db->replace($this->tableName, $data); // replace - false $false = $this->db->replace($this->tableName); self::assertEquals(false, $false); // replace - false $false = $this->db->replace('', $data); self::assertEquals(false, $false); $result = $this->db->select($this->tableName, "page_id = {$tmpId}"); $tmpPage = $result->fetchAllObject(); self::assertEquals('tpl_test', $tmpPage[0]->page_template); // delete - true $deleteId = $this->db->delete($this->tableName, array('page_id' => $tmpId)); self::assertEquals(1, $deleteId); // delete - false $false = $this->db->delete('', array('page_id' => $tmpId)); self::assertEquals(false, $false); // insert - true $pageArray = array('page_template' => 'tpl_new', 'page_type' => 'lall'); $tmpId = $this->db->insert($this->tableName, $pageArray); // delete - false $false = $this->db->delete($this->tableName, ""); self::assertEquals(false, $false); // delete - false $false = $this->db->delete($this->tableName, null); self::assertEquals(false, $false); // delete - true $false = $this->db->delete($this->tableName, "page_id = " . $this->db->escape($tmpId)); self::assertEquals(true, $false); // select - true $result = $this->db->select($this->tableName, array('page_id' => 2)); self::assertEquals(0, $result->num_rows); // select - true $result = $this->db->select($this->tableName); self::assertEquals(true, $result->num_rows > 0); // select - false $false = $this->db->select($this->tableName, null); self::assertEquals(false, $false); // select - false $false = $this->db->select('', array('page_id' => 2)); self::assertEquals(false, $false); }