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

Example 16 with Query

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

the class DatabaseConnectivityTest method testQueryWithProjectionClass.

public void testQueryWithProjectionClass() {
    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 DatabaseConnectivity(mTargetContext, AUTHORITY, 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.gt(5).and(col.lt(9));
    query.setSelection(selToken);
    List<DatabaseObject> results = connectivity.query(query, ProjectionObject.class);
    assertNotNull(results);
    assertEquals(1, results.size());
    DatabaseObject resultObject = results.get(0);
    Integer iCount = resultObject.getIntegerValue("count( _id )");
    assertNotNull(iCount);
    assertEquals(3, iCount.intValue());
    connectivity.delete(new Query(QueryObject.class));
}

Example 17 with Query

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

the class DatabaseUpdaterDirectSQLImplTest method testDoUpdate.

public void testDoUpdate() {
    final int count = 10;
    DatabaseObject object = null;
    DatabaseObject[] objects = new DatabaseObject[count];
    assertNotNull(objects);
    for (int i = 0; i < 10; i++) {
        object = DatabaseObjectFactory.createDatabaseObject(DynamicColumnsObject.class, DatabaseObject.VERSION_START);
        assertNotNull(object);
        if (i % 2 != 0) {
            object.setValue(DynamicColumnsObject.COLUMN_INT_VER1, i * 10);
        }
        object.setValue(DynamicColumnsObject.COLUMN_LONG_VER1, i * 10000000000l);
        Logger.debug("object = %s", object);
        objects[i] = object;
    }
    AbsDatabaseConnectivity connectivity = null;
    connectivity = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, DynamicColumnsObject.class, DatabaseObject.VERSION_START);
    assertNotNull(connectivity);
    connectivity.insert(objects);
    SQLiteDatabase sqlDB = null;
    Cursor c = null;
    DatabaseOpenHandler handler = null;
    boolean catched = false;
    handler = DatabaseOpenHandler.getInstance(mTargetContext, DatabaseObject.classToDatabase(DynamicColumnsObject.class), DatabaseObject.VERSION_START);
    assertNotNull(handler);
    sqlDB = handler.getReadableDatabase();
    assertNotNull(sqlDB);
    c = sqlDB.query(DatabaseObject.classToTable(DynamicColumnsObject.class), null, null, null, null, null, null);
    assertNotNull(c);
    assertEquals(10, c.getCount());
    assertEquals(true, c.moveToFirst());
    for (int i = 0; i < 10; i++) {
        if (i % 2 != 0) {
            assertEquals(i * 10, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER1.getName())));
        }
        assertEquals(i * 10000000000l, c.getLong(c.getColumnIndex(DynamicColumnsObject.COLUMN_LONG_VER1.getName())));
        c.moveToNext();
    }
    c.close();
    sqlDB.close();
    DatabaseUpdateInfo info = null;
    AbsDatabaseUpdater updater = null;
    connectivity = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, DynamicColumnsObject.class, DatabaseObject.VERSION_START + 1);
    info = connectivity.checkUpdates();
    assertNotNull(info);
    assertTrue(info.needUpdate());
    assertEquals(DatabaseObject.VERSION_START + 1, info.getNewVersion());
    assertEquals(DatabaseObject.VERSION_START, info.getOldVersion());
    updater = new DynamicColumnsUpdater(mTargetContext, DynamicColumnsObject.class);
    assertNotNull(updater);
    updater.doUpdate(info.getNewVersion(), info.getOldVersion());
    handler = DatabaseOpenHandler.getInstance(mTargetContext, DatabaseObject.classToDatabase(DynamicColumnsObject.class), DatabaseObject.VERSION_START + 1);
    assertNotNull(handler);
    sqlDB = handler.getReadableDatabase();
    assertNotNull(sqlDB);
    c = sqlDB.query(DatabaseObject.classToTable(DynamicColumnsObject.class), null, null, null, null, null, null);
    assertNotNull(c);
    assertEquals(10, c.getCount());
    assertEquals(true, c.moveToFirst());
    for (int i = 0; i < 10; i++) {
        if (i % 2 != 0) {
            assertEquals(i * 10, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER1_UPDATED.getName())));
        } else {
            assertEquals(999, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER1_UPDATED.getName())));
        }
        catched = false;
        try {
            assertEquals(i * 10000000000l, c.getLong(c.getColumnIndex(DynamicColumnsObject.COLUMN_LONG_VER1.getName())));
            catched = false;
        } catch (IllegalStateException e) {
            catched = true;
        }
        assertTrue(catched);
        assertEquals(1234, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER2.getName())));
        assertEquals(0.414, c.getDouble(c.getColumnIndex(DynamicColumnsObject.COLUMN_DOUBLE_VER2.getName())));
        assertEquals("Text Version 2", c.getString(c.getColumnIndex(DynamicColumnsObject.COLUMN_TEXT_VER2.getName())));
        c.moveToNext();
    }
    c.close();
    sqlDB.close();
    connectivity = new DatabaseConnectivityDirectSQLiteImpl(mTargetContext, DynamicColumnsObject.class);
    info = connectivity.checkUpdates();
    assertNotNull(info);
    assertTrue(info.needUpdate());
    assertEquals(DatabaseObject.VERSION_START + 2, info.getNewVersion());
    assertEquals(DatabaseObject.VERSION_START + 1, info.getOldVersion());
    updater = new DynamicColumnsUpdater(mTargetContext, DynamicColumnsObject.class);
    assertNotNull(updater);
    updater.doUpdate(info.getNewVersion(), info.getOldVersion());
    handler = DatabaseOpenHandler.getInstance(mTargetContext, DatabaseObject.classToDatabase(DynamicColumnsObject.class), DatabaseObject.VERSION_START + 2);
    assertNotNull(handler);
    sqlDB = handler.getReadableDatabase();
    assertNotNull(sqlDB);
    c = sqlDB.query(DatabaseObject.classToTable(DynamicColumnsObject.class), null, null, null, null, null, null);
    assertNotNull(c);
    assertEquals(10, c.getCount());
    assertEquals(true, c.moveToFirst());
    for (int i = 0; i < 10; i++) {
        if (i % 2 != 0) {
            assertEquals(i * 10, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER1_UPDATED.getName())));
        } else {
            assertEquals(999, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER1_UPDATED.getName())));
        }
        catched = false;
        try {
            assertEquals(i * 10000000000l, c.getLong(c.getColumnIndex(DynamicColumnsObject.COLUMN_LONG_VER1.getName())));
            catched = false;
        } catch (IllegalStateException e) {
            catched = true;
        }
        assertTrue(catched);
        assertEquals(1234, c.getInt(c.getColumnIndex(DynamicColumnsObject.COLUMN_INT_VER2.getName())));
        assertEquals(0.414, c.getDouble(c.getColumnIndex(DynamicColumnsObject.COLUMN_DOUBLE_VER2.getName())));
        assertEquals("Text Version 2", c.getString(c.getColumnIndex(DynamicColumnsObject.COLUMN_TEXT_VER2.getName())));
        assertEquals("Only In Version 3", c.getString(c.getColumnIndex(DynamicColumnsObject.COLUMN_TEXT_VER3.getName())));
        c.moveToNext();
    }
    c.close();
    sqlDB.close();
    connectivity.delete(new Query(DynamicColumnsObject.class));
}

Example 18 with Query

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

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

the class AbsTimeCapsuleModel method deleteObjects.

public int deleteObjects(Context context, DatabaseObjectKeys keys) {
    if (context == null) {
        return 0;
    }
    Query query = new Query(mObjectClass);
    if (keys != null) {
        ExpressionToken token = objectsToken(keys, TOKEN_TYPE_DELETION);
        if (token == null) {
            return 0;
        }
        query.setSelection(token);
    }
    TimeCapsuleDatabaseWriter<T> writer = new TimeCapsuleDatabaseWriter<>(context, mObjectClass);
    return writer.delete(query);
}

Example 20 with Query

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

the class TimeCapsuleDatabaseWriter method delete.

public int delete(T object) {
    if (object == null) {
        return 0;
    }
    final DatabaseConnectivity connectivity = getConnectivity();
    if (connectivity == null) {
        return 0;
    }
    Query query = getQuery();
    ExpressionToken token = TimeCapsule.COLUMN_ID.eq(object.getId());
    query.setSelection(token);
    return connectivity.delete(query);
}