vendredi 13 mars 2015

How to use count in ormlite


List<HoraireDb> horaires_reels = null;
try {
Dao<HoraireDb, Integer> dao = App.getHelper().getHoraireDao();
QueryBuilder<HoraireDb, Integer> builder = dao.queryBuilder();
Where where = builder.where();
where.eq("isprevis", false);
where.and();
where.eq("idactivite", Param.getIdActivite(App.getContext()));
where.and();
where.eq("jour",moment);
where.and();
where.isNotNull("debut");
where.and();
where.isNotNull("fin");
where.and();
where.ne("etat", "D");
where.and();
where.isNull("idabsence");
where.and();
where.lt("fin",moment);

horaires_reels = dao.query(builder.prepare());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


i want to return an int just the number of rows, because returning a list take much time, i want to know there's any way to use countof() for my code ???


i found in stackoverflow this answer but didn't work for me :


int numRows = dao.queryBuilder().where().eq("name", "Joe Smith").countOf();


Aucun commentaire:

Enregistrer un commentaire