How to use

scalarOrNull

method

in

leap.orm.query.Query

/**
 * Returns the scalar value or <code>null</code> if n o records returned.
 *
 * @throws TooManyRecordsException if two or more records returned.
 */
default <T> T scalarValueOrNull(Class<T> type) throws TooManyRecordsException {
  Scalar scalar = scalarOrNull();
  return null == scalar ? null : scalar.get(type);
}

/**
 * Returns the scalar value or <code>null</code> if n o records returned.
 *
 * @throws TooManyRecordsException if two or more records returned.
 */
default <T> T scalarValueOrNull() throws TooManyRecordsException {
  Scalar scalar = scalarOrNull();
  return null == scalar ? null : (T)scalar.get();
}

public Boolean queryBoolean(String sql, Map<String, Object> params) {
  return createQuery(sql, params).scalarOrNull().get(Boolean.class);
}

public Double queryDouble(String sql, Map<String, Object> params) {
  return createQuery(sql, params).scalarOrNull().get(Double.class);
}

public String queryString(String sql, Map<String, Object> params) {
  return createQuery(sql, params).scalarOrNull().getString();
}

public Object queryScalar(String sql, Map<String, Object> params) {
  return createQuery(sql, params).scalarOrNull().get();
}