/*
* Updating a todo
*/
public int updateToDo(Todo todo) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_TODO, todo.getNote());
values.put(KEY_STATUS, todo.getStatus());
// updating row
return db.update(
TABLE_TODO, values, KEY_ID + " = ?", new String[] {String.valueOf(todo.getId())});
}
/*
* Deleting a tag
*/
public void deleteTag(Tag tag, boolean should_delete_all_tag_todos) {
SQLiteDatabase db = this.getWritableDatabase();
// before deleting tag
// check if todos under this tag should also be deleted
if (should_delete_all_tag_todos) {
// get all todos under this tag
List<Todo> allTagToDos = getAllToDosByTag(tag.getTagName());
// delete all todos
for (Todo todo : allTagToDos) {
// delete todo
deleteToDo(todo.getId());
}
}
// now delete the tag
db.delete(TABLE_TAG, KEY_ID + " = ?", new String[] {String.valueOf(tag.getId())});
}