public function testExecute()
{
$this->object->select("*", "activity")->where("id > 2")->andWhere("id < 10");
$mysqlResult = $this->object->execute();
$result = mysql_fetch_assoc($mysqlResult);
$compare = array('id' => 3, 'title' => 'act2');
$this->assertEquals($compare['id'], $result['id']);
$this->assertEquals($compare['title'], $result['title']);
}
public function testLimitExecute()
{
$this->object->select("*", "activity")->limit(1, 1)->orderBy('id');
$statement = $this->object->getStatement();
$compareStatement = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER ( ORDER BY id) as row FROM [activity]) a WHERE (row > 1) and (row <= 2)";
$this->assertEquals($compareStatement, $statement);
$result = $this->object->execute();
$compare = array('id' => 3, 'title' => 'act2');
$this->assertEquals($compare['id'], $result[0]['id']);
$this->assertEquals($compare['title'], $result[0]['title']);
}
public function testCount()
{
$pdoResult = $this->object->execute("SELECT COUNT(*) FROM activity");
$result = NULL;
$count = 0;
foreach ($pdoResult as $row) {
if ($count == 0) {
$result = $row;
}
}
$compare = 3;
$this->assertEquals($compare, $result["COUNT(*)"]);
}
