'Hello, World!']);
}
public function plaintext()
{
return Response::text('Hello, World!');
}
public function db()
{
$prepare = app()->dbWorld;
$prepare->execute([mt_rand(1, 10000)]);
$data = $prepare->fetch();
return Response::json($data);
}
public function fortunes()
{
$fortune = app()->dbFortune;
$fortune->execute();
$arr = $fortune->fetchAll(\PDO::FETCH_KEY_PAIR);
$arr[0] = 'Additional fortune added at request time.';
\asort($arr);
$html = '';
foreach ($arr as $id => $message) {
$message = \htmlspecialchars($message, \ENT_QUOTES, 'UTF-8');
$html .= "| $id | $message |
";
}
return Response::html("Fortunes");
}
public function queries($q=1)
{
$statement = app()->dbWorld;
$query_count = max(min(intval($q), 500), 1);
$arr = [];
while ($query_count--) {
$statement->execute([mt_rand(1, 10000)]);
$arr[] = $statement->fetch();
}
return Response::json($arr);
}
public function updates($q=1)
{
static $updates = [];
$random = app()->dbWorld;
$count = max(min(intval($q), 500), 1);
$worlds = $keys = $values = [];
for ($i = 0; $i < $count; ++ $i) {
$values[] = $keys[] = $id = mt_rand(1, 10000);
$random->execute([$id]);
$row = $random->fetch();
$values[] = $row['randomNumber'] = mt_rand(1, 10000);
$worlds[] = $row;
}
if (!isset($updates[$count])) {
$sql = 'UPDATE World SET randomNumber = CASE id' . str_repeat(' WHEN ?::INTEGER THEN ?::INTEGER ', $count) . 'END WHERE id IN (' . str_repeat('?::INTEGER,', $count - 1) . '?::INTEGER)';
$updates[$count] = app()->db->prepare($sql);
}
$updates[$count]->execute([...$values, ...$keys]);
return Response::json($worlds);
}
}