public function testPersist()
{
$mapper = new StatusMapper($this->connection);
$rows = $this->connection->query('SELECT COUNT(*) FROM STATUSES')->fetch(PDO::FETCH_NUM);
$this->assertEquals(0, $rows[0]);
$status = new Status(null, 'picharles', 'message', date('Y-m-d H:i:s'));
$mapper->persist($status);
$rows = $this->connection->query('SELECT COUNT(*) FROM STATUSES')->fetch(PDO::FETCH_NUM);
$this->assertEquals(1, $rows[0]);
}
});
// Matches if the HTTP method is GET -> /statuses/id
$app->get('/statuses/(\\d+)', function (Request $request, $id) use($app, $statusFinder) {
if (null === ($status = $statusFinder->findOneById($id))) {
throw new HttpException(404);
}
$data = array('status' => $status);
if ($request->guessBestFormat() === 'json') {
return new JsonResponse($data);
}
return $app->render('status.php', $data);
});
// Matches if the HTTP method is POST -> /statutes
$app->post('/statuses', function (Request $request) use($app, $statusFinder, $statusMapper) {
$status = new Status(null, htmlspecialchars($request->getParameter('user')), htmlspecialchars($request->getParameter('message')), date("Y-m-d H:i:s"));
$statusMapper->persist($status);
if ($request->guessBestFormat() === 'json') {
return new JsonResponse("statuses/" . count($statusFinder->findAll()), 201);
}
$app->redirect('/statuses');
});
// Matches if the HTTP method is POST -> /login
$app->post('/login', function (Request $request) use($app, $userFinder) {
$userName = $request->getParameter('userName');
$userPassword = $request->getParameter('userPassword');
if (!isset($userName) || !isset($userPassword)) {
$response = new Response("Empty Username or password", 400);
$response->send();
return $app->render('login.php', array('error' => "Empty Username or password", 'userName' => $userName));
}
$user = $userFinder->findOneByUserName($userName);