Examples with Metric com.axibase.tsd.api.model.metric.Metric used on opensource projects

Example 76 with Metric

use of com.axibase.tsd.api.model.metric.Metric in project atsd-api-test by axibase.

the class InterpolateUserTimeZoneTest method testInterpolateMetricTimezone.

@Issue("4103")
@Test(description = "Check that metric.timezone can be used for interpolation")
public void testInterpolateMetricTimezone() throws Exception {
    String entityName = Mocks.entity();
    String metricName = Mocks.metric();
    Metric metric = new Metric(metricName);
    metric.setTimeZoneID("Asia/Kolkata");
    Series series = new Series(entityName, metricName);
    series.addSamples(Sample.ofDateInteger("2017-10-11T05:22:43.573Z", 1), Sample.ofDateInteger("2017-10-12T05:22:43.573Z", 2));
    MetricMethod.createOrReplaceMetricCheck(metric);
    SeriesMethod.insertSeriesCheck(series);
    String sqlQuery = String.format("SELECT date_format(datetime, 'yy-MM-dd HH:mm:ss', metric.timezone) " + "FROM \"%1$s\" " + "WHERE datetime BETWEEN '2017-10-11T05:00:00.000Z' " + "AND '2017-10-12T05:00:00.000Z' " + "WITH INTERPOLATE(1 DAY, PREVIOUS, OUTER, FALSE, CALENDAR, metric.timezone)", metricName);
    String[][] expectedRows = { { "17-10-12 00:00:00" } };
    assertSqlQueryRows("Incorrect interpolation when using metric.timezone as custom timezone", expectedRows, sqlQuery);
}