/**
* Create table
*
* @param string $name
* @param array $data
*/
function createTable($name, $data)
{
$PDODb = PDODb::getInstance();
$PDODb->rawQuery("DROP TABLE IF EXISTS {$name}");
$query = "CREATE TABLE {$name} (id INT(9) UNSIGNED PRIMARY KEY AUTO_INCREMENT";
foreach ($data as $key => $value) {
$query .= ", {$key} {$value}";
}
$query .= ")";
$PDODb->rawQuery($query);
}
public function testPagination()
{
$PDODb = PDODb::getInstance();
$PDODb->orderBy('id', 'ASC')->setPageLimit(2);
$result = $PDODb->paginate('products', 1);
$this->assertEquals(3, $PDODb->totalPages);
$this->assertEquals(2, count($result));
}
