/**
* Executes a given Query to the inner PDO connection.
*/
public function execute(Query $query)
{
$statement = $this->prepareSQL($query);
if ($this->logger != null) {
$this->logger->message('QueryHandler : executing query ...', true);
}
$statement->execute();
$res = $statement->fetchAll(\PDO::FETCH_ASSOC);
$res = $this->groupTwoColumns($res);
if ($this->logger != null) {
$this->logger->done();
}
return $res;
}
}
require_once __DIR__ . '/../vendor/autoload.php';
use DS3\Framework\HTTP\Request;
use DS3\Framework\PDO\FilePDOBuilder;
use DS3\Framework\HTTP\JsonResponse;
use DS3\Framework\Logger\Logger;
use DS3\Framework\Filesystem\File;
use DS3\Framework\HTTP\JsonHandler;
$logger = new Logger(new File(__DIR__ . '/../app/dev.log'));
try {
$logger->message("-------------------------------------------------------\n");
$logger->message(sprintf('[%s] : Started dbCharts', date(DATE_ATOM)));
// --- Request
$logger->message("Creating request...", true);
$request = Request::fromGlobals();
$logger->done();
$logger->message('Handling request ' . "`{$request->getMethod()} {$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}`");
// --- PDO configuration
$pdo_cfg_path = '/../app/pdo.cfg';
$logger->message("Loading PDO configuration from file '" . $pdo_cfg_path . "'...", true);
$pdo_config = new FilePDOBuilder(__DIR__ . $pdo_cfg_path);
$logger->done();
// --- Controller
$logger->message("Creating controller...", true);
$controller = new \DS3\Application\Controller($pdo_config, $logger);
$logger->done();
// --- Response
$logger->message("Creating response...", true);
try {
$response = $controller->handle($request);
} catch (\Exception $e) {
