@Override
public boolean mHasNotSend() {
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("SELECT COUNT(1) FROM " + TABLE, null);
cursor.moveToFirst();
boolean isSend = cursor.getLong(0) > 0 ? true : false;
cursor.close();
return isSend;
}
@Override
public List<String> findAll() {
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("SELECT not_send_rowid FROM BLIT_OVERLAY_NOTSEND", null);
List<String> rowids = new ArrayList<String>();
long rowid = 0;
while (cursor.moveToNext()) {
rowid = cursor.getLong(0);
rowids.add(rowid + "");
}
return rowids;
}
