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

Example 11 with OrderingToken

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

the class AsyncDatabaseHelperTest method testQueryWithGroupBy.

public void testQueryWithGroupBy() {
    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", i);
            object.setValue("doubleValue", ((double) i * 2));
            object.setValue("textValue", String.format("%04d", i * 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 = new Query(QueryObject.class);
    assertNotNull(query);
    ExpressionToken selToken = col.gte(0).and(col.lt(2));
    query.setSelection(selToken);
    OrderingToken groupByToken = col.groupBy();
    query.setGroupBy(groupByToken);
    helper.startQuery(mRandom.nextInt(), "testQueryWithGroupBy", query);
    waitHelper(helper);
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivity(mTargetContext, AUTHORITY, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.delete(new Query(QueryObject.class));
}

Example 12 with OrderingToken

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

the class DatabaseConnectivityDirectSQLImplTest method testQueryWithGroupBy.

public void testQueryWithGroupBy() {
    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", i);
            object.setValue("doubleValue", ((double) i * 2));
            object.setValue("textValue", String.format("%04d", i * 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 = new Query(QueryObject.class);
    assertNotNull(query);
    ExpressionToken selToken = col.gte(0).and(col.lt(2));
    query.setSelection(selToken);
    OrderingToken groupByToken = col.groupBy();
    query.setGroupBy(groupByToken);
    List<DatabaseObject> results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(2, results.size());
    DatabaseObject resultObject = null;
    for (int i = 0; i < 2; i++) {
        resultObject = results.get(i);
        assertNotNull(resultObject);
        Logger.debug("resultObject(%s)", resultObject.toSQLSelectionString());
        Integer iVal = resultObject.getIntegerValue("intValue");
        assertNotNull(iVal);
        assertEquals(i, iVal.intValue());
        Double dVal = resultObject.getDoubleValue("doubleValue");
        assertNotNull(dVal);
        assertEquals(((double) i * 2), dVal.doubleValue());
        String sVal = resultObject.getTextValue("textValue");
        assertNotNull(sVal);
        assertEquals(String.format("%04d", i * 3), sVal);
    }
    connectivity.delete(new Query(QueryObject.class));
}

Example 13 with OrderingToken

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

the class TimeColumnTest method testGroupBy.

public void testGroupBy() {
    TimeColumn column = new TimeColumn("time");
    assertNotNull(column);
    OrderingToken token = null;
    String expected = null;
    token = column.groupByHour();
    expected = "CAST ( strftime('%H', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByMinute();
    expected = "CAST ( strftime('%M', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupBySecond();
    expected = "CAST ( strftime('%S', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByDate();
    expected = "date((time / 1000), 'unixepoch', 'localtime')";
    assertEquals(expected, token.toString());
    token = column.groupByDay();
    expected = "CAST ( strftime('%d', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByWeekday();
    expected = "CAST ( strftime('%w', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByWeek();
    expected = "CAST ( strftime('%W', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByMonth();
    expected = "CAST ( strftime('%m', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
    token = column.groupByYear();
    expected = "CAST ( strftime('%Y', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertEquals(expected, token.toString());
}