Examples with SqlRow com.hazelcast.sql.SqlRow used on opensource projects

Example 1 with SqlRow

use of com.hazelcast.sql.SqlRow in project hazelcast by hazelcast.

the class BetweenOperatorIntegrationTest method executePossiblyFailingQuery.

/**
 * Execute a query and return either the result, or the exception it threw.
 */
protected Tuple2<List<SqlRow>, HazelcastSqlException> executePossiblyFailingQuery(String sql, SqlColumnType firstColumnExpectedType, Object... params) {
    try {
        SqlResult result = instance().getSql().execute(sql, params);
        List<SqlRow> rows = new ArrayList<>();
        for (SqlRow row : result) {
            assertEquals(firstColumnExpectedType, row.getMetadata().getColumn(0).getType());
            rows.add(row);
        }
        return tuple2(rows, null);
    } catch (HazelcastSqlException e) {
        return tuple2(Collections.emptyList(), e);
    }
}

Example 2 with SqlRow

use of com.hazelcast.sql.SqlRow in project hazelcast by hazelcast.

the class IsNullPredicateIntegrationTest method checkLiteral.

private void checkLiteral(String literal, String function, boolean expectedResult) {
    String expression = literal + " " + function;
    String sql = "SELECT " + expression + " FROM map WHERE " + expression;
    List<SqlRow> rows = execute(sql);
    if (expectedResult) {
        assertEquals(1, rows.size());
        SqlRow row = rows.get(0);
        assertEquals(SqlColumnType.BOOLEAN, row.getMetadata().getColumn(0).getType());
        assertTrue(row.getObject(0));
    } else {
        assertEquals(0, rows.size());
    }
}

Example 3 with SqlRow

use of com.hazelcast.sql.SqlRow in project hazelcast by hazelcast.

the class IsTrueFalsePredicateIntegrationTest method keys.

private Set<Integer> keys(String sql, Object... params) {
    List<SqlRow> rows = execute(sql, params);
    if (rows.size() == 0) {
        return Collections.emptySet();
    }
    assertEquals(1, rows.get(0).getMetadata().getColumnCount());
    Set<Integer> keys = new HashSet<>();
    for (SqlRow row : rows) {
        int key = row.getObject(0);
        boolean added = keys.add(key);
        assertTrue("Key is not unique: " + key, added);
    }
    return keys;
}

Example 4 with SqlRow

use of com.hazelcast.sql.SqlRow in project hazelcast by hazelcast.

the class IsTrueFalsePredicateIntegrationTest method checkLiteral.

private void checkLiteral(String literal, String function, boolean expectedResult) {
    String expression = literal + " " + function;
    String sql = "SELECT " + expression + " FROM map WHERE " + expression;
    List<SqlRow> rows = execute(sql);
    if (expectedResult) {
        assertEquals(1, rows.size());
        SqlRow row = rows.get(0);
        assertEquals(SqlColumnType.BOOLEAN, row.getMetadata().getColumn(0).getType());
        assertTrue(row.getObject(0));
    } else {
        assertEquals(0, rows.size());
    }
}

Example 5 with SqlRow

use of com.hazelcast.sql.SqlRow in project hazelcast by hazelcast.

the class IsTrueFalsePredicateIntegrationTest method checkColumn.

private void checkColumn(String function, Set<Integer> expectedKeys) {
    String expression = "field1 " + function;
    String sql = "SELECT key, " + expression + " FROM map WHERE " + expression;
    List<SqlRow> rows = execute(sql);
    assertEquals(expectedKeys.size(), rows.size());
    for (SqlRow row : rows) {
        assertEquals(SqlColumnType.BOOLEAN, row.getMetadata().getColumn(1).getType());
        int key = row.getObject(0);
        boolean value = row.getObject(1);
        assertTrue("Key is not returned: " + key, expectedKeys.contains(key));
        assertTrue(value);
    }
}