UpdateResource.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  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 UpdateResource 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. $count = $request->parameter('queries');
  20. if ($count !== null && $count > 0) {
  21. $count = min($count, 500);
  22. } else {
  23. $count = 1;
  24. }
  25. $selectQuery = '
  26. SELECT id,
  27. randomNumber
  28. FROM World
  29. WHERE id = ?
  30. ';
  31. $selectProcedure = $this->database->prepare($selectQuery);
  32. $updateQuery = '
  33. UPDATE World
  34. SET randomNumber = ?
  35. WHERE id = ?
  36. ';
  37. $updateProcedure = $this->database->prepare($updateQuery);
  38. $payload = [];
  39. while ($count-- > 0) {
  40. $id = mt_rand(1, 10000);
  41. $randomNumber = mt_rand(1, 10000);
  42. $selectProcedure->bindInteger($id);
  43. /** @var RandomNumber $entry */
  44. $entry = $selectProcedure->processOne()->selectAll()->cast(RandomNumber::class)->collectHead();
  45. $modifiedEntry = $entry->withNumber($randomNumber);
  46. $updateProcedure->bindInteger($modifiedEntry->number());
  47. $updateProcedure->bindInteger($modifiedEntry->id());
  48. $updateProcedure->execute();
  49. $payload[] = $modifiedEntry;
  50. }
  51. return new SimpleOKResponse(new JsonEntity($payload));
  52. }
  53. }