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(*)"]); }