Examples with OrderingToken com.dailystudio.dataobject.query.OrderingToken used on opensource projects

Example 1 with OrderingToken

use of com.dailystudio.dataobject.query.OrderingToken in project devbricks by dailystudio.

the class AsyncDatabaseHelperTest method testQueryWithOrderBy.

public void testQueryWithOrderBy() {
    final int count = (3 * 10);
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 3; i++) {
        for (int j = 0; j < 10; j++) {
            object = DatabaseObjectFactory.createDatabaseObject(QueryObject.class);
            assertNotNull(object);
            object.setValue("intValue", j);
            object.setValue("doubleValue", ((double) j * 2));
            object.setValue("textValue", String.format("%04d", j * 3));
            objects[i * 10 + j] = object;
        }
    }
    AsyncDatabaseHelper helper = new TestAsyncDatabaseHelp(mTargetContext, AUTHORITY, QueryObject.class, true);
    assertNotNull(helper);
    helper.startBulkInsert(mRandom.nextInt(), "BulkInsert1", objects);
    waitHelper(helper);
    final Template templ = object.getTemplate();
    Column col = templ.getColumn("intValue");
    Query query = null;
    OrderingToken orderByToken = null;
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByAscending();
    query.setOrderBy(orderByToken);
    helper.startQuery(mRandom.nextInt(), "testQueryWithOrderBy1", query);
    waitHelper(helper);
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByDescending();
    query.setOrderBy(orderByToken);
    helper.startQuery(mRandom.nextInt(), "testQueryWithOrderBy2", query);
    waitHelper(helper);
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivity(mTargetContext, AUTHORITY, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.delete(new Query(QueryObject.class));
}

Example 2 with OrderingToken

use of com.dailystudio.dataobject.query.OrderingToken in project devbricks by dailystudio.

the class DatabaseConnectivityDirectSQLImplTest method testQueryWithOrderBy.

public void testQueryWithOrderBy() {
    final int count = (3 * 10);
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 3; i++) {
        for (int j = 0; j < 10; j++) {
            object = DatabaseObjectFactory.createDatabaseObject(QueryObject.class);
            assertNotNull(object);
            object.setValue("intValue", j);
            object.setValue("doubleValue", ((double) j * 2));
            object.setValue("textValue", String.format("%04d", j * 3));
            objects[i * 10 + j] = object;
        }
    }
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.insert(objects);
    final Template templ = object.getTemplate();
    Column col = templ.getColumn("intValue");
    Query query = null;
    List<DatabaseObject> results = null;
    OrderingToken orderByToken = null;
    DatabaseObject resultObject = null;
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByAscending();
    query.setOrderBy(orderByToken);
    results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(30, results.size());
    for (int j = 0; j < 10; j++) {
        for (int i = 0; i < 3; i++) {
            resultObject = results.get(j * 3 + i);
            assertNotNull(resultObject);
            Logger.debug("resultObject(%s)", resultObject.toSQLSelectionString());
            Integer iVal = resultObject.getIntegerValue("intValue");
            assertNotNull(iVal);
            assertEquals(j, iVal.intValue());
            Double dVal = resultObject.getDoubleValue("doubleValue");
            assertNotNull(dVal);
            assertEquals(((double) j * 2), dVal.doubleValue());
            String sVal = resultObject.getTextValue("textValue");
            assertNotNull(sVal);
            assertEquals(String.format("%04d", j * 3), sVal);
        }
    }
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByDescending();
    query.setOrderBy(orderByToken);
    results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(30, results.size());
    for (int j = 9; j >= 0; j--) {
        for (int i = 0; i < 3; i++) {
            resultObject = results.get((9 - j) * 3 + i);
            assertNotNull(resultObject);
            Logger.debug("resultObject(%s)", resultObject.toSQLSelectionString());
            Integer iVal = resultObject.getIntegerValue("intValue");
            assertNotNull(iVal);
            assertEquals(j, iVal.intValue());
            Double dVal = resultObject.getDoubleValue("doubleValue");
            assertNotNull(dVal);
            assertEquals(((double) j * 2), dVal.doubleValue());
            String sVal = resultObject.getTextValue("textValue");
            assertNotNull(sVal);
            assertEquals(String.format("%04d", j * 3), sVal);
        }
    }
    connectivity.delete(new Query(QueryObject.class));
}

Example 3 with OrderingToken

use of com.dailystudio.dataobject.query.OrderingToken in project devbricks by dailystudio.

the class DatabaseConnectivityTest method testQueryWithOrderBy.

public void testQueryWithOrderBy() {
    final int count = (3 * 10);
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 3; i++) {
        for (int j = 0; j < 10; j++) {
            object = DatabaseObjectFactory.createDatabaseObject(QueryObject.class);
            assertNotNull(object);
            object.setValue("intValue", j);
            object.setValue("doubleValue", ((double) j * 2));
            object.setValue("textValue", String.format("%04d", j * 3));
            objects[i * 10 + j] = object;
        }
    }
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivity(mTargetContext, AUTHORITY, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.insert(objects);
    final Template templ = object.getTemplate();
    Column col = templ.getColumn("intValue");
    Query query = null;
    List<DatabaseObject> results = null;
    OrderingToken orderByToken = null;
    DatabaseObject resultObject = null;
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByAscending();
    query.setOrderBy(orderByToken);
    results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(30, results.size());
    for (int j = 0; j < 10; j++) {
        for (int i = 0; i < 3; i++) {
            resultObject = results.get(j * 3 + i);
            assertNotNull(resultObject);
            Logger.debug("resultObject(%s)", resultObject.toSQLSelectionString());
            Integer iVal = resultObject.getIntegerValue("intValue");
            assertNotNull(iVal);
            assertEquals(j, iVal.intValue());
            Double dVal = resultObject.getDoubleValue("doubleValue");
            assertNotNull(dVal);
            assertEquals(((double) j * 2), dVal.doubleValue());
            String sVal = resultObject.getTextValue("textValue");
            assertNotNull(sVal);
            assertEquals(String.format("%04d", j * 3), sVal);
        }
    }
    query = new Query(QueryObject.class);
    assertNotNull(query);
    orderByToken = col.orderByDescending();
    query.setOrderBy(orderByToken);
    results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(30, results.size());
    for (int j = 9; j >= 0; j--) {
        for (int i = 0; i < 3; i++) {
            resultObject = results.get((9 - j) * 3 + i);
            assertNotNull(resultObject);
            Logger.debug("resultObject(%s)", resultObject.toSQLSelectionString());
            Integer iVal = resultObject.getIntegerValue("intValue");
            assertNotNull(iVal);
            assertEquals(j, iVal.intValue());
            Double dVal = resultObject.getDoubleValue("doubleValue");
            assertNotNull(dVal);
            assertEquals(((double) j * 2), dVal.doubleValue());
            String sVal = resultObject.getTextValue("textValue");
            assertNotNull(sVal);
            assertEquals(String.format("%04d", j * 3), sVal);
        }
    }
    connectivity.delete(new Query(QueryObject.class));
}

Example 4 with OrderingToken

use of com.dailystudio.dataobject.query.OrderingToken in project devbricks by dailystudio.

the class AbsTimeCapsuleModel method listObjects.

public List<T> listObjects(Context context, DatabaseObjectKeys keys, String listTokenType) {
    if (context == null) {
        return null;
    }
    TimeCapsuleDatabaseReader<T> reader = new TimeCapsuleDatabaseReader<>(context, mObjectClass);
    Query query = new Query(mObjectClass);
    if (keys != null && !TextUtils.isEmpty(listTokenType)) {
        ExpressionToken token = objectsToken(keys, listTokenType);
        if (token == null) {
            return null;
        }
        query.setSelection(token);
    }
    OrderingToken orderByToken = orderByToken(listTokenType);
    if (orderByToken != null) {
        query.setOrderBy(orderByToken);
    }
    return reader.query(query);
}

Example 5 with OrderingToken

use of com.dailystudio.dataobject.query.OrderingToken in project devbricks by dailystudio.

the class TimeCapsuleQueryBuilder method getQueryForIntersect.

public Query getQueryForIntersect(ExpressionToken startExp, ExpressionToken durationExp, long start, long end, boolean orderByAscending) {
    if (startExp == null || durationExp == null) {
        return null;
    }
    String startExpStr = startExp.toString();
    Logger.debug("expression: startExp(%s), durationExp(%s)", startExp, durationExp, orderByAscending);
    Logger.debug("peroid: start(%s), end(%s), orderByAscending(%s)", CalendarUtils.timeToReadableString(start), CalendarUtils.timeToReadableString(end), orderByAscending);
    Query query = getQuery();
    if (query != null) {
        if (start < end) {
            ExpressionToken sExp = new ExpressionToken(start);
            ExpressionToken eExp = new ExpressionToken(end);
            ExpressionToken sel1 = new ExpressionToken(startExpStr).lte(sExp).and(new ExpressionToken(startExpStr).plus(durationExp).gt(sExp));
            ExpressionToken sel2 = new ExpressionToken(startExpStr).gt(sExp).and(new ExpressionToken(startExpStr).plus(durationExp).lte(eExp));
            ExpressionToken selection = sel1.or(sel2);
            if (selection != null) {
                query.setSelection(selection);
            }
        }
        OrderingToken orderBy = (orderByAscending ? TimeCapsule.COLUMN_TIME.orderByAscending() : TimeCapsule.COLUMN_TIME.orderByDescending());
        if (orderBy != null) {
            query.setOrderBy(orderBy);
        }
    }
    return query;
}