ORMLite Tips
count
Use countOf method of Dao
ORMDatabaseHelper helper = new ORMDatabaseHelper(getContext()); ConnectionSource cs = new AndroidConnectionSource(helper); Dao<Item, Integer> dao = DaoManager.createDao(cs, DBRecordHistory.class); long c = dao.countOf();
Order By
Use orderBy query
QueryBuilder<DBRecordHistory, Integer> query = dao.queryBuilder().orderBy("date", false); List<DBRecordHistory> list = dao.query(query.prepare());
※Skip dao creation part
limit
QueryBuilder<DBRecordHistory, Integer> query = dao.queryBuilder().orderBy("date", true).limit(1L); List<DBRecordHistory> list = dao.query(query.prepare());
like
Use Where and like method
QueryBuilder<DBRecordHistory, Integer> query = dao.queryBuilder().orderBy("date", false); Where<DBRecordHistory, Integer> where = query.where(); where.like("search_word", "%" + key + "%"); return dao.query(where.prepare());
Please add % between keyword