public static List<StatEntry> listEntries(Context ctx, int limit, int offset) {
DbHelper helper = new DbHelper(ctx);
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.query("stat", null, null, null, null, null, "date desc", offset + "," + limit);
List<StatEntry> res = new ArrayList<StatEntry>();
if (c.moveToFirst()) {
int dateIdx = c.getColumnIndex("date");
int digitsIdx = c.getColumnIndex("digits");
int successIdx = c.getColumnIndex("success");
int memMillisIdx = c.getColumnIndex("mem_millis");
int recallMillisIdx = c.getColumnIndex("recall_millis");
int event = c.getColumnIndex("event");
do {
StatEntry e = new StatEntry();
e.setDate(new Date(c.getLong(dateIdx)));
e.setDigits(c.getInt(digitsIdx));
e.setSuccess(c.getInt(successIdx));
e.setMemMillis(c.getInt(memMillisIdx));
e.setRecallMillis(c.getInt(recallMillisIdx));
e.setEvent(c.getInt(event));
res.add(e);
} while (c.moveToNext());
}
c.close();
helper.close();
return res;
}
