ORMLite Tips

Posted by On 6月 25, 2015 0 Comment

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

TOPICS