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

Example 41 with Query

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

the class AsyncDatabaseHelperTest method testInsertDatabaseObjects.

public void testInsertDatabaseObjects() {
    AsyncDatabaseHelper helper1 = new TestAsyncDatabaseHelp(mTargetContext, AUTHORITY, SampleObject1.class, true);
    assertNotNull(helper1);
    AsyncDatabaseHelper helper2 = new TestAsyncDatabaseHelp(mTargetContext, AUTHORITY, SampleObject2.class, true);
    assertNotNull(helper2);
    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);
        }
        objects[i] = object;
    }
    helper1.startBulkInsert(mRandom.nextInt(), "BulkInsertCookie1", objects);
    waitHelper(helper1);
    helper2.startBulkInsert(mRandom.nextInt(), "BulkInsertCookie2", objects);
    waitHelper(helper2);
    AbsDatabaseConnectivity connectivity1 = new DatabaseConnectivity(mTargetContext, AUTHORITY, SampleObject1.class);
    assertNotNull(connectivity1);
    AbsDatabaseConnectivity connectivity2 = new DatabaseConnectivity(mTargetContext, AUTHORITY, SampleObject2.class);
    assertNotNull(connectivity2);
    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) {
            assertEquals(i * 1000l, c.getLong(c.getColumnIndex("time")));
            c.moveToNext();
        }
    }
    c.close();
    // sqlDB.delete(AbsDatabaseConnectivity.classToTable(SampleObject1.class),
    // null, null);
    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) {
            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")));
            c.moveToNext();
        }
    }
    c.close();
    // sqlDB.delete(AbsDatabaseConnectivity.classToTable(SampleObject2.class),
    // null, null);
    sqlDB.close();
    connectivity1.delete(new Query(SampleObject1.class));
    connectivity2.delete(new Query(SampleObject2.class));
}

Example 42 with Query

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

the class AsyncDatabaseHelperTest 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;
    }
    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.gt(5).and(col.lt(9));
    query.setSelection(selToken);
    helper.startQuery(mRandom.nextInt(), "testQueryWithProjectionClass", query, ProjectionObject.class);
    waitHelper(helper);
    AbsDatabaseConnectivity connectivity = new DatabaseConnectivity(mTargetContext, AUTHORITY, QueryObject.class);
    assertNotNull(connectivity);
    connectivity.delete(new Query(QueryObject.class));
}

Example 43 with Query

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

the class AbsDatabaseUpdater method doUpdate.

public void doUpdate(int newVersion, int oldVersion) {
    if (mContext == null || mObjectClass == null) {
        return;
    }
    AbsDatabaseConnectivity connectivity = null;
    connectivity = getConnectivity(oldVersion);
    if (connectivity == null) {
        return;
    }
    Query query = new Query(mObjectClass);
    List<DatabaseObject> oldObjects = connectivity.query(query);
    connectivity.delete(query);
    if (oldObjects == null) {
        return;
    }
    final int N = oldObjects.size();
    if (N <= 0) {
        return;
    }
    DatabaseObject[] newObjects = new DatabaseObject[N];
    DatabaseObject oldObj = null;
    DatabaseObject newObj = null;
    for (int i = 0; i < N; i++) {
        oldObj = oldObjects.get(i);
        newObj = DatabaseObjectFactory.createDatabaseObject(mObjectClass, newVersion);
        updateObject(newObj, oldObj);
        newObjects[i] = newObj;
    }
    connectivity = getConnectivity(newVersion);
    if (connectivity == null) {
        return;
    }
    connectivity.insert(newObjects);
}

Example 44 with Query

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

the class AbsTimeCapsuleModel method getObject.

public T getObject(Context context, DatabaseObjectKeys keys) {
    if (context == null || keys == null) {
        return null;
    }
    TimeCapsuleDatabaseReader<T> reader = new TimeCapsuleDatabaseReader<>(context, mObjectClass);
    Query query = new Query(mObjectClass);
    ExpressionToken selToken = objectsToken(keys, TOKEN_TYPE_EXISTENCE);
    if (selToken == null) {
        return null;
    }
    query.setSelection(selToken);
    return (reader.queryLastOne(query));
}

Example 45 with Query

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

the class TimeCapsuleDatabaseWriter method update.

public int update(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.update(query, object);
}