Examples with QueryResults org.josql.QueryResults used on opensource projects

Example 1 with QueryResults

use of org.josql.QueryResults in project DirectMemory by raffaeleguidi.

the class OffHeapMemoryBuffer method selectOrderBy.

private QueryResults selectOrderBy(String whereClause, String orderBy, String limit) throws QueryParseException, QueryExecutionException {
    Query q = new Query();
    q.parse("SELECT * FROM " + Pointer.class.getCanonicalName() + "  WHERE " + whereClause + " order by " + orderBy + " " + limit);
    QueryResults qr = q.execute(pointers);
    return qr;
}

Example 2 with QueryResults

use of org.josql.QueryResults in project DirectMemory by raffaeleguidi.

the class OffHeapMemoryBuffer method collectLFU.

public long collectLFU(int limit) {
    if (limit <= 0)
        limit = pointers.size() / 10;
    QueryResults qr;
    try {
        qr = selectOrderBy("free=false", "frequency", "limit 1, " + limit);
        @SuppressWarnings("unchecked") List<Pointer> result = qr.getResults();
        return free(result);
    } catch (QueryParseException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (QueryExecutionException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return 0;
}

Example 3 with QueryResults

use of org.josql.QueryResults in project DirectMemory by raffaeleguidi.

the class OffHeapMemoryBuffer method select.

private QueryResults select(String whereClause) throws QueryParseException, QueryExecutionException {
    Query q = new Query();
    q.parse("SELECT * FROM " + Pointer.class.getCanonicalName() + "  WHERE " + whereClause);
    QueryResults qr = q.execute(pointers);
    return qr;
}