Java WhereCondition类代码示例

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
public void testEqByteArray() {
    ArrayList<TestEntity> inserted = insert(3);
    TestEntity testEntity = inserted.get(1);

    byte[] byteArray = {96, 77, 37, -21};
    testEntity.setSimpleByteArray(byteArray);
    dao.update(testEntity);

    // Unsupported: Query<TestEntity> query = dao.queryBuilder().where(Properties.SimpleByteArray.eq(byteArray)).build();

    // Works, but probably voids any index on BLOBs (Note: there's no hex2blob function and X'?' is bad syntax):
    // String conditionString = "HEX(" + Properties.SimpleByteArray.columnName + ")=?";
    // WhereCondition condition = new WhereCondition.StringCondition(conditionString, SqlUtils.toHex(byteArray));

    String conditionString = Properties.SimpleByteArray.columnName + '=' + SqlUtils.escapeBlobArgument(byteArray);
    WhereCondition condition = new WhereCondition.StringCondition(conditionString);
    Query<TestEntity> query = dao.queryBuilder().where(condition).build();
    TestEntity testEntity2 = query.uniqueOrThrow();
    assertEquals(testEntity.getId(), testEntity2.getId());

    // Unsupported: query.setParameter(0, new byte[]{96, 77, 37, -21, 99});
    // Unsupported: assertNull(query.unique());
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
@Test
public void testMockitoMocks() {
    mock(DaoMaster.class).newSession();
    mock(DaoSession.class).getDatabase();
    mock(Database.class).getRawDatabase();
    mock(DatabaseStatement.class).execute();
    mock(IdentityScope.class).clear();
    mock(AbstractDao.class).queryBuilder();
    mock(MinimalEntityDao.class).queryBuilder();
    mock(MinimalEntity.class).getId();
    mock(Query.class).forCurrentThread();
    mock(QueryBuilder.class).build();
    mock(CountQuery.class).forCurrentThread();
    mock(DeleteQuery.class).forCurrentThread();
    mock(Join.class).getTablePrefix();
    mock(LazyList.class).getLoadedCount();
    mock(WhereCondition.class).appendValuesTo(null);
    mock(Property.class).isNull();
    mock(DaoException.class).getMessage();
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
void selectData(String name, String phoneNum, String sex, final MaterialDialog materialDialog) {

        Logger.t(TAG).i("name=" + name + "\nphoneNum=" + phoneNum + "\nsex=" + sex);
        WhereCondition nameWhereCondition = UserDao.Properties.Name.like("%" + name + "%");
        WhereCondition phoneNumWhereCondition = UserDao.Properties.PhoneNumber.like("%" + phoneNum + "%");
        WhereCondition sexWhereCondition = UserDao.Properties.Sex.eq(sex);

        List<User> users;

        if (TextUtils.isEmpty(sex)) {
            users = mUserDao.queryBuilder().where(nameWhereCondition, phoneNumWhereCondition).list();
        } else {
            users = mUserDao.queryBuilder().where(nameWhereCondition, phoneNumWhereCondition, sexWhereCondition).list();
        }

        loadLatestData(users);
        materialDialog.dismiss();
    }
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/**
 * 根据指定地址名称或经纬度查询地址
 **/
public BaiduAddress get(BaiduAddress baiduAddress) {
    DecimalFormat df = new DecimalFormat("0.0000");
    WhereCondition andCondition = mAddressDao.queryBuilder().and(BaiduAddressDao.Properties.Latitude.like(df.format(baiduAddress.getLatitude()) + "%"),
            BaiduAddressDao.Properties.Longitude.like(df.format(baiduAddress.getLongitude()) + "%"));
    return mAddressDao.queryBuilder().whereOr(BaiduAddressDao.Properties.Address.eq(baiduAddress.getAddress())
            , andCondition).orderDesc(BaiduAddressDao.Properties.FavoritedTime).limit(1).unique();
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
public static boolean isEntityExists(AbstractDao dao, WhereCondition condition) {
    return dao.queryBuilder()
            .where(condition)
            .build()
            .list()
            .size() >= 1;
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "equal ('=')" condition  for this property. */
public WhereCondition eq(Object value) {
    return new PropertyCondition(this, "=?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "not equal ('<>')" condition  for this property. */
public WhereCondition notEq(Object value) {
    return new PropertyCondition(this, "<>?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "LIKE" condition  for this property. */
public WhereCondition like(String value) {
    return new PropertyCondition(this, " LIKE ?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "BETWEEN ... AND ..." condition  for this property. */
public WhereCondition between(Object value1, Object value2) {
    Object[] values = { value1, value2 };
    return new PropertyCondition(this, " BETWEEN ? AND ?", values);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "IN (..., ..., ...)" condition  for this property. */
public WhereCondition in(Object... inValues) {
    StringBuilder condition = new StringBuilder(" IN (");
    SqlUtils.appendPlaceholders(condition, inValues.length).append(')');
    return new PropertyCondition(this, condition.toString(), inValues);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "NOT IN (..., ..., ...)" condition  for this property. */
public WhereCondition notIn(Object... notInValues) {
    StringBuilder condition = new StringBuilder(" NOT IN (");
    SqlUtils.appendPlaceholders(condition, notInValues.length).append(')');
    return new PropertyCondition(this, condition.toString(), notInValues);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "greater than ('>')" condition  for this property. */
public WhereCondition gt(Object value) {
    return new PropertyCondition(this, ">?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "less than ('<')" condition  for this property. */
public WhereCondition lt(Object value) {
    return new PropertyCondition(this, "<?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "greater or equal ('>=')" condition  for this property. */
public WhereCondition ge(Object value) {
    return new PropertyCondition(this, ">=?", value);
}
 

import org.greenrobot.greendao.query.WhereCondition; //导入依赖的package包/类
/** Creates an "less or equal ('<=')" condition  for this property. */
public WhereCondition le(Object value) {
    return new PropertyCondition(this, "<=?", value);
}