'Hello, World!']; } public function db() { $world = World::select()->cols(['*'])->where('`id` = :id') ->bindValue(':id', random_int(1, 10000)) ->first(); return $world ? $world->toArray() : []; } public function queries($queries = 1) { $queries = $this->clamp($queries); $rows = []; while ($queries--) { $row = World::select()->cols(['*'])->where('`id` = :id') ->bindValue(':id', random_int(1, 10000)) ->first(); $rows[] = $row ? $row->toArray() : []; } return $rows; } public function fortunes() { $rows = Fortune::select()->cols(['*'])->get(); $insert = new Fortune(); $insert->id = 0; $insert->message = 'Additional fortune added at request time.'; $rows[] = $insert; usort($rows, function ($left, $right) { return strcmp($left->message, $right->message); }); return Response::output($this->renderFortunes($rows), 200, ['Content-Type' => 'text/html;charset=utf-8']); } private function renderFortunes($fortunes) { $html = << %s

id	message

EOF; $fortuneRows = ''; foreach ($fortunes as $fortune) { $fortuneRows .= ' ' . htmlspecialchars($fortune->id) . '' . htmlspecialchars($fortune->message) . '' . PHP_EOL; } return sprintf($html, $fortuneRows); } public function updates($queries = 1) { $queries = $this->clamp($queries); $rows = []; while ($queries--) { $row = World::select()->cols(['*'])->where('`id` = :id') ->bindValue(':id', random_int(1, 10000)) ->first(); if ($row) { $row->randomNumber = random_int(1, 10000); $row->save(); $rows[] = $row->toArray(); } else { $rows[] = []; } } return $rows; } public function plaintext() { return Response::output('Hello, World!', 200, ['Content-Type' => 'text/plain']); } private function clamp($value): int { if (! is_numeric($value) || $value < 1) { return 1; } if ($value > 500) { return 500; } return (int)$value; } }