@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 void save(long rowid) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.beginTransaction();
ContentValues values = new ContentValues();
values.put("not_send_rowid", rowid);
db.insert(TABLE, null, values);
db.setTransactionSuccessful();
db.endTransaction();
}
@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;
}
@Override
public void closeDB() {
dbHelper.close();
}