upscale/newrelic-query-builder

Query builder for New Relic Query Language (NRQL)

1.0.0 2015-03-08 11:32 UTC

README

Build Status

Query Builder for NRQL

The New Relic Query Language (NRQL) is an SQL-flavored query language for making calls against the Insights Events database.

This project is a PHP library for assembling NRQL queries in object-oriented applications. Library implements the official NRQL specification. It offers a "fluent" interface to specify query parts in an arbitrary order. That allows different application parts to influence the query w/o worrying about the query assembly order. Query integrity validation is performed upon rendering. Library provides object-oriented representation for complex elements of NRQL syntax. That enables code completion and avoids typos in contrast to plain text queries.

Installation

Library is to be installed via Composer as a project dependency in composer.json:

{
    "require": {
        "upscale/newrelic-query-builder": "*"
    }
}

Usage

The example below demonstrates a query with all available clauses:

use Upscale\Nrql\QueryBuilder;
use Upscale\Nrql\TimePeriod;
use Upscale\Nrql\Moment\TimeAgo;
use Upscale\Nrql\Moment\ExactTime;
use Upscale\Nrql\Moment\Yesterday;

$nrql = new QueryBuilder();
$nrql->select([
        'userAgentName',
    ])
    ->from([
        'PageView',
    ])
    ->where('userAgentOS = "Windows"')
    ->facet('countryCode')
    ->limit(20)
    ->since(new TimeAgo(new TimePeriod(4, TimePeriod::UNIT_DAYS)))
    ->until(new Yesterday())
    ->compareWith(new ExactTime(new \DateTime('2015-01-01 00:00:00')))
    ->timeSeries(new TimePeriod(1, TimePeriod::UNIT_HOURS))
;

echo $nrql;

Limitations

Some complex aspects of the NRQL syntax have not been implemented in an object-oriented manner. These include Aggregator Functions, Math Operators and logical operators (AND, OR, grouping). However, the library allows to utilize as complex expressions as needed in place of string arguments.

Free-format string arguments:

  • Attributes of SELECT statement, including optional AS clause
  • Conditions of WHERE clause
  • Attribute of FACET clause

License

Licensed under the Apache License, Version 2.0.