DbResource.php 967 B

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. namespace Benchmark\Resources;
  3. use Benchmark\Entities\RandomNumber;
  4. use Hamlet\Database\Database;
  5. use Hamlet\Http\Entities\JsonEntity;
  6. use Hamlet\Http\Requests\Request;
  7. use Hamlet\Http\Resources\HttpResource;
  8. use Hamlet\Http\Responses\Response;
  9. use Hamlet\Http\Responses\SimpleOKResponse;
  10. class DbResource implements HttpResource
  11. {
  12. private $database;
  13. public function __construct(Database $database)
  14. {
  15. $this->database = $database;
  16. }
  17. public function getResponse(Request $request): Response
  18. {
  19. $id = mt_rand(1, 10000);
  20. $query = '
  21. SELECT id,
  22. randomNumber
  23. FROM World
  24. WHERE id = ?
  25. ';
  26. $procedure = $this->database->prepare($query);
  27. $procedure->bindInteger($id);
  28. $record = $procedure->processOne()->selectAll()->cast(RandomNumber::class)->collectHead();
  29. return new SimpleOKResponse(new JsonEntity($record));
  30. }
  31. }