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

Example 21 with Query

use of com.dailystudio.dataobject.query.Query 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;
}

Example 22 with Query

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

the class ConvertedDatabaseObjectsAsyncTask method doInBackground.

@SuppressWarnings("unchecked")
@Override
protected List<C> doInBackground(Void... params) {
    final Class<D> objectClass = getObjectClass();
    if (objectClass == null) {
        return null;
    }
    final DatabaseConnectivity connectivity = getDatabaseConnectivity(objectClass);
    if (connectivity == null) {
        return null;
    }
    final Query query = getQuery(objectClass);
    if (query == null) {
        return null;
    }
    final Class<P> projectionClass = getProjectionClass();
    List<DatabaseObject> data = null;
    if (projectionClass == null) {
        data = connectivity.query(query);
    } else {
        data = connectivity.query(query, projectionClass);
    }
    return (List<C>) data;
}

Example 23 with Query

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

the class ConvertedDatabaseObjectsLoader method loadInBackground.

@SuppressWarnings("unchecked")
@Override
public List<C> loadInBackground() {
    if (mObserver != null) {
        getContext().getContentResolver().unregisterContentObserver(mObserver);
    }
    final Class<D> objectClass = getObjectClass();
    if (objectClass == null) {
        return null;
    }
    final DatabaseConnectivity connectivity = getDatabaseConnectivity(objectClass);
    if (connectivity == null) {
        return null;
    }
    final Query query = getQuery(objectClass);
    if (query == null) {
        return null;
    }
    final Class<? extends DatabaseObject> projectionClass = getProjectionClass();
    List<DatabaseObject> data = null;
    if (projectionClass == null) {
        data = connectivity.query(query);
    } else {
        data = connectivity.query(query, projectionClass);
    }
    Uri uri = connectivity.getDatabaseObserverUri();
    if (uri != null) {
        ContentResolver cr = getContext().getContentResolver();
        cr.registerContentObserver(uri, true, mObserver);
    }
    return (projectionClass == null ? convertRawObjects((List<D>) data) : convertProjectedObjects((List<P>) data));
}

Example 24 with Query

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

the class DatabaseConnectivityDirectSQLImplTest method testLimitQuery.

public void testLimitQuery() {
    final int count = 10;
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 10; i++) {
        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] = object;
    }
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.insert(objects);
    Query query = new Query(QueryObject.class);
    assertNotNull(query);
    ExpressionToken limit = new ExpressionToken("5");
    query.setLimit(limit);
    List<DatabaseObject> results = connectivity.query(query);
    assertNotNull(results);
    assertEquals(5, results.size());
    DatabaseObject resultObject = null;
    for (int i = 0; i < 5; 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 25 with Query

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

the class DatabaseConnectivityDirectSQLImplTest method testUpdateDatabaseObjects.

public void testUpdateDatabaseObjects() {
    AbsDatabaseConnectivity connectivity1 = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, SampleObject1.class);
    assertNotNull(connectivity1);
    AbsDatabaseConnectivity connectivity2 = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, SampleObject2.class);
    assertNotNull(connectivity2);
    final int count = 10;
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 10; i++) {
        if (i % 2 == 0) {
            object = DatabaseObjectFactory.createDatabaseObject(SampleObject1.class);
            assertNotNull(object);
            object.setValue(SampleObject1.COLUMN_TIME, (1000l * i));
        } else {
            object = DatabaseObjectFactory.createDatabaseObject(SampleObject2.class);
            assertNotNull(object);
            object.setValue(SampleObject2.COLUMN_LAT, 0.1 * i);
            object.setValue(SampleObject2.COLUMN_LON, 0.2 * i);
            object.setValue(SampleObject2.COLUMN_ALT, 0.3 * i);
            object.setValue(SampleObject2.COLUMN_BIN, fillBytesArray(i, (byte) i));
        }
        objects[i] = object;
    }
    connectivity1.insert(objects);
    connectivity2.insert(objects);
    DatabaseObject updateObject = null;
    Query query1 = new Query(SampleObject1.class);
    assertNotNull(query1);
    ExpressionToken selection1 = SampleObject1.COLUMN_TIME.gt(5000l);
    assertNotNull(selection1);
    query1.setSelection(selection1);
    updateObject = DatabaseObjectFactory.createDatabaseObject(SampleObject1.class);
    updateObject.setValue(SampleObject1.COLUMN_TIME, 0l);
    connectivity1.update(query1, updateObject);
    Query query2 = new Query(SampleObject2.class);
    assertNotNull(query2);
    ExpressionToken selection2 = SampleObject2.COLUMN_LAT.gt(0.2).and(SampleObject2.COLUMN_LON.lt(0.8));
    assertNotNull(selection2);
    query2.setSelection(selection2);
    updateObject = DatabaseObjectFactory.createDatabaseObject(SampleObject2.class);
    updateObject.setValue(SampleObject2.COLUMN_ALT, 12.34);
    updateObject.setValue(SampleObject2.COLUMN_BIN, fillBytesArray(100, (byte) 0xFF));
    connectivity2.update(query2, updateObject);
    DatabaseOpenHandler handler1 = DatabaseOpenHandler.getInstance(mTargetContext, DatabaseObject.classToDatabase(SampleObject1.class), 0x1);
    assertNotNull(handler1);
    DatabaseOpenHandler handler2 = DatabaseOpenHandler.getInstance(mTargetContext, DatabaseObject.classToDatabase(SampleObject2.class), 0x1);
    assertNotNull(handler2);
    SQLiteDatabase sqlDB = null;
    Cursor c = null;
    sqlDB = handler1.getReadableDatabase();
    assertNotNull(sqlDB);
    c = sqlDB.query(DatabaseObject.classToTable(SampleObject1.class), null, null, null, null, null, null);
    assertNotNull(c);
    assertEquals(5, c.getCount());
    assertEquals(true, c.moveToFirst());
    for (int i = 0; i < 10; i++) {
        if (i % 2 == 0) {
            if (i * 1000l > 5000l) {
                assertEquals(0, c.getLong(c.getColumnIndex("time")));
            } else {
                assertEquals(i * 1000l, c.getLong(c.getColumnIndex("time")));
            }
            c.moveToNext();
        }
    }
    c.close();
    sqlDB.close();
    sqlDB = handler2.getReadableDatabase();
    assertNotNull(sqlDB);
    c = sqlDB.query(DatabaseObject.classToTable(SampleObject2.class), null, null, null, null, null, null);
    assertNotNull(c);
    assertEquals(5, c.getCount());
    assertEquals(true, c.moveToFirst());
    for (int i = 0; i < 5; i++) {
        if (i % 2 != 0) {
            if ((0.1 * i > 0.2) && (0.2 * i < 0.8)) {
                assertEquals(0.1 * i, c.getDouble(c.getColumnIndex("latitude")));
                assertEquals(0.2 * i, c.getDouble(c.getColumnIndex("longitude")));
                assertEquals(12.34, c.getDouble(c.getColumnIndex("altitude")));
                object.setValue(SampleObject2.COLUMN_BIN, fillBytesArray(i, (byte) i));
            } else {
                assertEquals(0.1 * i, c.getDouble(c.getColumnIndex("latitude")));
                assertEquals(0.2 * i, c.getDouble(c.getColumnIndex("longitude")));
                assertEquals(0.3 * i, c.getDouble(c.getColumnIndex("altitude")));
                object.setValue(SampleObject2.COLUMN_BIN, fillBytesArray(100, (byte) 0xFF));
            }
            c.moveToNext();
        }
    }
    c.close();
    sqlDB.close();
    connectivity1.delete(new Query(SampleObject1.class));
    connectivity2.delete(new Query(SampleObject2.class));
}