Java QueryBuilder类代码示例

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override
public Observable<List<Folder>> create(final List<Folder> folders) {
    return Observable.create(new Observable.OnSubscribe<List<Folder>>() {
        @Override
        public void call(Subscriber<? super List<Folder>> subscriber) {
            Date now = new Date();
            for (Folder folder : folders) {
                folder.setCreatedAt(now);
            }

            long result = mLiteOrm.save(folders);
            if (result > 0) {
                List<Folder> allNewFolders = mLiteOrm.query(
                        QueryBuilder.create(Folder.class).appendOrderAscBy(Folder.COLUMN_NAME)
                );
                subscriber.onNext(allNewFolders);
            } else {
                subscriber.onError(new Exception("Create folders failed"));
            }
            subscriber.onCompleted();
        }
    });
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
private void testQueryAnyUwant() {

        long nums = liteOrm.queryCount(Address.class);
        OrmLog.i(this, "Address All Count : " + nums);

        QueryBuilder<Address> qb = new QueryBuilder<Address>(Address.class)
                .columns(new String[]{Address.COL_ADDRESS})
                .appendOrderAscBy(Address.COL_ADDRESS)
                .appendOrderDescBy(Address.COL_ID)
                .distinct(true)
                .where(Address.COL_ADDRESS + "=?", new String[]{"香港路"});

        nums = liteOrm.queryCount(qb);
        OrmLog.i(this, "Address All Count : " + nums);
        List<Address> addrList = liteOrm.query(qb);
        for (Address uu : addrList) {
            OrmLog.i(this, "Query Address: " + uu);
        }

    }
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
void loadDataFromCache() {
    if (items.size() == 0) {
        items.addAll(Stores.db.query(
            QueryBuilder.create(Feed.class)
                .whereEquals(Feed.CATEGORY, category)
                .appendOrderDescBy(Feed.PUBLISHED_AT)
                .distinct(true)
                .limit(0, 20)
            )
        );
        adapter.notifyDataSetChanged();
    }
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override
public Observable<Song> setSongAsFavorite(final Song song, final boolean isFavorite) {
    return Observable.create(new Observable.OnSubscribe<Song>() {
        @Override
        public void call(Subscriber<? super Song> subscriber) {
            List<PlayList> playLists = mLiteOrm.query(
                    QueryBuilder.create(PlayList.class).whereEquals(PlayList.COLUMN_FAVORITE, String.valueOf(true))
            );
            if (playLists.isEmpty()) {
                PlayList defaultFavorite = DBUtils.generateFavoritePlayList(mContext);
                playLists.add(defaultFavorite);
            }
            PlayList favorite = playLists.get(0);
            song.setFavorite(isFavorite);
            favorite.setUpdatedAt(new Date());
            if (isFavorite) {
                // Insert song to the beginning of the list
                favorite.addSong(song, 0);
            } else {
                favorite.removeSong(song);
            }
            mLiteOrm.insert(song, ConflictAlgorithm.Replace);
            long result = mLiteOrm.insert(favorite, ConflictAlgorithm.Replace);
            if (result > 0) {
                subscriber.onNext(song);
            } else {
                if (isFavorite) {
                    subscriber.onError(new Exception("Set song as favorite failed"));
                } else {
                    subscriber.onError(new Exception("Set song as unfavorite failed"));
                }
            }
            subscriber.onCompleted();
        }
    });
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    ButterKnife.bind(this);
    mMeizhiList = new ArrayList<>();
    QueryBuilder query = new QueryBuilder(Meizhi.class);
    query.appendOrderDescBy("publishedAt");
    query.limit(0, 10);
    mMeizhiList.addAll(App.sDb.query(query));

    setupRecyclerView();
    setupUmeng();
    AlarmManagers.register(this);
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
/**
 * 查询所有并按照指定列的值降序排列
 */
public <T> Observable<ArrayList<T>> queryAllDesc(final Class<T> cls, final String column) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<>(cls).appendOrderDescBy(column)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
/**
 * 查询 指定字段 的值并去除重复
 *
 * @param cls   要查询的对象类型
 * @param columns 字段名称
 * @return 查询结果集合
 */
public <T> Observable<ArrayList<T>> querySpecificColumnsAndDistinct(final Class<T> cls, final String[] columns) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<>(cls).columns(columns).distinct(true)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
/**
 * 查询 某字段 等于 value 的值
 *
 * @param cls   要查询的对象类型
 * @param where 字段名称
 * @param value 字段的值
 * @return 查询结果集合
 */
public <T> Observable<ArrayList<T>> queryByWhere(final Class<T> cls, final String where, final String[] value) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<>(cls).where(where + "=?", value)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
/**
 * 查询 某字段 等于 value 的值并按照指定列的值升序排列
 */
public <T> Observable<ArrayList<T>> queryByWhereAsc(final Class<T> cls, final String where, final String[] value, final String column) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<>(cls).where(where + "=?", value).appendOrderAscBy(column)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
public <T> Observable<ArrayList<T>> queryByLike(final Class<T> cls, final String where, final String[] value) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<>(cls).where(where + " LIKE ?", value)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
/**
 * 查询 某字段 等于 value 的值  可以指定从1-20，就是分页
 */
public <T> Observable<ArrayList<T>> queryByWhereLength(final Class<T> cls, final String where, final String[] value, final int start, final int length) {
    return Observable.defer(new Func0<Observable<ArrayList<T>>>() {
        @Override
        public Observable<ArrayList<T>> call() {
            return Observable.just(liteOrm.query(new QueryBuilder<T>(cls).where(where + "=?", value).limit(start, length)));
        }
    }).subscribeOn(Schedulers.io());
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override
public String getLoseKey() {
    QueryBuilder query = new QueryBuilder(CacheEntry.class);
    query.orderBy(CacheEntry.COL_USE_COUNT).appendOrderAscBy(CacheEntry.COL_LAST_USE_TIME);
    query.limit(0, 1);
    List<CacheEntry> list = getDb().query(query);
    if (list != null && list.size() >0) {
        return list.get(0).getKey();
    } else {
        return null;
    }
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override
public String getLoseKey() {
    QueryBuilder query = new QueryBuilder(CacheEntry.class);
    query.orderBy(CacheEntry.COL_LAST_USE_TIME);
    query.limit(0, 1);
    List<CacheEntry> list = getDb().query(query);
    if (list != null && list.size() >0) {
        return list.get(0).getKey();
    } else {
        return null;
    }
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
@Override
public String getLoseKey() {
    QueryBuilder query = new QueryBuilder(CacheEntry.class);
    query.orderBy(CacheEntry.COL_CREATE_TIME);
    query.limit(0, 1);
    List<CacheEntry> list = getDb().query(query);
    if (list != null && list.size() >0) {
        return list.get(0).getKey();
    } else {
        return null;
    }
}
 

import com.litesuits.orm.db.assit.QueryBuilder; //导入依赖的package包/类
private void checkWhetherCollected() {
    QueryBuilder query = new QueryBuilder(GirlCollect.class).where("girlUrl = ?", new String[]{mMeizhiUrl});
    long nums = MyApp.mLiteOrm.queryCount(query);
    if (nums == 1) {
        mFavFAB.setImageResource(R.mipmap.ab_fav_active);
        mIsGirlCollected = true;
    } else {
        mIsGirlCollected = false;
    }
}