<?php
// Set content type
header("Content-type: application/json");

// Database connection
// http://www.php.net/manual/en/ref.pdo-mysql.php
// $pdo = new PDO('mysql:host=tfb-database;dbname=hello_world', 'benchmarkdbuser', 'benchmarkdbpass');

# inclue the ActiveRecord library
require_once 'vendor/php-activerecord/php-activerecord/ActiveRecord.php';

ActiveRecord\Connection::$PDO_OPTIONS[PDO::ATTR_PERSISTENT] = true;
ActiveRecord\Config::initialize(function($cfg)
{
  $cfg->set_model_directory('models');
  $cfg->set_connections(array('development' =>
    'mysql://benchmarkdbuser:benchmarkdbpass@tfb-database/hello_world'));
});

// Read number of queries to run from URL parameter
$query_count = 1;
if (isset($_GET['queries']) && $_GET['queries'] > 0) {
  $query_count = $_GET["queries"] > 500 ? 500 : $_GET['queries'];
}

// Create an array with the response string.
$arr = array();

// For each query, store the result set values in the response array
for ($i = 0; $i < $query_count; $i++) {
  // Choose a random row
  // http://www.php.net/mt_rand
  $id = mt_rand(1, 10000);

  $world = World::find_by_id($id);
  
  // Store result in array.
  $arr[] = $world->to_array();
}
if ($query_count === 1) {
  $arr = $arr[0];
}
// Use the PHP standard JSON encoder.
// http://www.php.net/manual/en/function.json-encode.php
echo json_encode($arr);