Examples with StringTable com.axibase.tsd.api.model.sql.StringTable used on opensource projects

Example 71 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlEntityTagsTest method testLikeOperator.

@Issue("2926")
@Test
public void testLikeOperator() {
    String sqlQuery = String.format("SELECT entity.tags.tag1 %nFROM \"%s\" %nWHERE datetime='2016-06-19T11:00:00.000Z' AND " + "entity.tags.tag1 LIKE 'val%%' %nAND entity = '%s'", TEST_METRIC_NAME, TEST_ENTITY_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Collections.singletonList(Collections.singletonList("val1"));
    assertTableRowsExist(expectedRows, resultTable);
}

Example 72 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlEntityTagsTest method testNotLikeOperator.

@Issue("2926")
@Test
public void testNotLikeOperator() {
    String sqlQuery = String.format("SELECT entity.tags.tag1 %nFROM \"%s\" %nWHERE datetime='2016-06-19T11:00:00.000Z' AND " + "entity.tags.tag1 NOT LIKE 'val%%' %nAND entity = '%s'", TEST_METRIC_NAME, TEST_ENTITY_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Collections.emptyList();
    assertTableRowsExist(expectedRows, resultTable);
}

Example 73 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlClauseWithLastTimeTest method testWithOrderByClause.

@Issue("3291")
@Test
public void testWithOrderByClause() {
    String sqlQuery = String.format("SELECT entity, value FROM \"%s\" %nWITH time < LAST_TIME - 1*minute%n" + "ORDER BY value DESC", TEST_METRIC_NAME);
    Response response = queryResponse(sqlQuery);
    String[][] expectedRows = { { TEST_ENTITY2_NAME, "3" }, { TEST_ENTITY1_NAME, "0" } };
    StringTable resultTable = response.readEntity(StringTable.class);
    assertTableRowsExist(expectedRows, resultTable);
}

Example 74 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlClauseWithLastTimeTest method testLessOrEqualsLastTime.

@Issue("3291")
@Test
public void testLessOrEqualsLastTime() {
    String sqlQuery = String.format("SELECT entity, value FROM \"%s\" %nWITH time <= last_time - 1*minute", TEST_METRIC_NAME);
    Response response = queryResponse(sqlQuery);
    String[][] expectedRows = { { TEST_ENTITY1_NAME, "0" }, { TEST_ENTITY1_NAME, "1" }, { TEST_ENTITY2_NAME, "3" }, { TEST_ENTITY2_NAME, "4" } };
    StringTable resultTable = response.readEntity(StringTable.class);
    assertTableRowsExist(expectedRows, resultTable);
}

Example 75 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlClauseWithLastTimeTest method testGreaterOrEqualsLastTime.

@Issue("3291")
@Test
public void testGreaterOrEqualsLastTime() {
    String sqlQuery = String.format("SELECT entity, value FROM \"%s\" %nWITH time >= last_time - 1*minute", TEST_METRIC_NAME);
    Response response = queryResponse(sqlQuery);
    String[][] expectedRows = { { TEST_ENTITY1_NAME, "1" }, { TEST_ENTITY1_NAME, "2" }, { TEST_ENTITY2_NAME, "4" }, { TEST_ENTITY2_NAME, "5" } };
    StringTable resultTable = response.readEntity(StringTable.class);
    assertTableRowsExist(expectedRows, resultTable);
}