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);
}
