PHP DruidFamiliar\QueryExecutor\DruidNodeDruidQueryExecutor Examples

Example #1

File: compare-transformation-and-not.php Project: r4j4h/php-druid-query

<?php

require_once '../vendor/autoload.php';
$examplesDir = dirname(__FILE__);
$examplesConfig = (require_once $examplesDir . '/_examples-config.php');
$druidHost = $examplesConfig['druid-host'];
$druidPort = $examplesConfig['druid-port'];
$druidDataSource = $examplesConfig['druid-dataSource'];
date_default_timezone_set('America/Denver');
$c = new \DruidFamiliar\QueryExecutor\DruidNodeDruidQueryExecutor($druidHost, $druidPort);
$q = new \DruidFamiliar\QueryGenerator\TimeBoundaryDruidQueryGenerator();
$p = new \DruidFamiliar\QueryParameters\TimeBoundaryQueryParameters($druidDataSource);
$r = $c->executeQuery($q, $p, new DruidFamiliar\ResponseHandler\JsonFormattingResponseHandler());
var_dump($r);
//array(1) {
//    [0]=>
//  array(2) {
//        ["timestamp"]=>
//    string(24) "2011-06-01T00:00:11.000Z"
//        ["result"]=>
//    array(2) {
//            ["minTime"]=>
//      string(24) "2011-06-01T00:00:11.000Z"
//            ["maxTime"]=>
//      string(24) "2011-11-30T23:55:34.000Z"
//    }
//  }
//}
$q = new \DruidFamiliar\QueryGenerator\TimeBoundaryDruidQueryGenerator($druidDataSource);
$p = new \DruidFamiliar\QueryParameters\TimeBoundaryQueryParameters($druidDataSource);
$r = $c->executeQuery($q, $p, new DruidFamiliar\ResponseHandler\TimeBoundaryResponseHandler());

Example #2

File: html-query-printer-improved.php Project: r4j4h/php-druid-query

 * DruidFamiliar HTML TimeBoundary Printer Example
 *
 * Point your browser at this through a web server and you should see nicely formatted time boundary data. :)
 */
use DruidFamiliar\ExampleGroupByQueries\ReferralsByCompanyGroupByQueryParameters;
use DruidFamiliar\ExampleGroupByQueries\ReferralsByCompanyGroupByResponseHandler;
use DruidFamiliar\ExampleResponseObjects\ExampleReferralByCompanyResponseObject;
use DruidFamiliar\Response\TimeBoundaryResponse;
require_once '../vendor/autoload.php';
$examplesDir = dirname(__FILE__);
$examplesConfig = (require_once $examplesDir . '/_examples-config.php');
$druidHost = $examplesConfig['druid-host'];
$druidPort = $examplesConfig['druid-port'];
$druidDataSource = $examplesConfig['druid-dataSource'];
date_default_timezone_set('America/Denver');
$c = new \DruidFamiliar\QueryExecutor\DruidNodeDruidQueryExecutor($druidHost, $druidPort);
$q = new \DruidFamiliar\QueryGenerator\TimeBoundaryDruidQueryGenerator($druidDataSource);
$p = new \DruidFamiliar\QueryParameters\TimeBoundaryQueryParameters($druidDataSource);
/**
 * @var TimeBoundaryResponse $r
 */
$r = $c->executeQuery($q, $p, new DruidFamiliar\ResponseHandler\TimeBoundaryResponseHandler());
$q2 = new \DruidFamiliar\ExampleGroupByQueries\ReferralsByCompanyGroupByQueryGenerator();
$p2 = new ReferralsByCompanyGroupByQueryParameters($druidDataSource, '2006-01-01T00:00', '2015-01-01T00');
/**
 * @var ExampleReferralByCompanyResponseObject $r2
 */
$r2 = $c->executeQuery($q2, $p2, new ReferralsByCompanyGroupByResponseHandler());
$startTime = new DateTime($r->minTime);
$endTime = new DateTime($r->maxTime);
$formattedStartTime = $startTime->format("F m, Y h:i:s A");

Example #3

File: healthcheck.php Project: r4j4h/php-druid-query

 * DruidFamiliar Healthcheck Example
 *
 * Run this via the command line, e.g. `php healthcheck.php`
 * and you will either get "Good to go!" or "Problem encountered :("
 */
use DruidFamiliar\Response\TimeBoundaryResponse;
use DruidFamiliar\QueryParameters\TimeBoundaryQueryParameters;
require_once '../vendor/autoload.php';
$examplesDir = dirname(__FILE__);
$examplesConfig = (require_once $examplesDir . '/_examples-config.php');
$druidHost = $examplesConfig['druid-host'];
$druidPort = $examplesConfig['druid-port'];
$druidDataSource = $examplesConfig['druid-dataSource'];
date_default_timezone_set('America/Denver');
try {
    $c = new \DruidFamiliar\QueryExecutor\DruidNodeDruidQueryExecutor($druidHost, $druidPort);
    $q = new \DruidFamiliar\QueryGenerator\TimeBoundaryDruidQueryGenerator();
    $params = new TimeBoundaryQueryParameters($druidDataSource);
    $responseHandler = new DruidFamiliar\ResponseHandler\TimeBoundaryResponseHandler();
    /**
     * @var TimeBoundaryResponse $timeBoundaryResponse
     */
    $timeBoundaryResponse = $c->executeQuery($q, $params, $responseHandler);
    echo "DruidFamiliar\n";
    echo "Talking to {$druidHost} on port {$druidPort}.\n";
    if (isset($timeBoundaryResponse->minTime)) {
        echo "Good to go!\n";
    } else {
        echo "Problem encountered :(\n";
        echo "Talked to something, but it didn't seem to be druid.";
    }