public static List<Task> getAll() {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
SQLiteDatabase db = databaseHelper.getReadableDatabase();
Cursor cursor =
db.query(TaskContract.TABLE, TaskContract.COLUMNS, null, null, null, null, TaskContract.ID);
List<Task> values = TaskContract.getTasks(cursor);
db.close();
databaseHelper.close();
return values;
}
public static void save(Task task) {
DatabaseHelper databaseHelper = DatabaseHelper.getInstance();
SQLiteDatabase db = databaseHelper.getWritableDatabase();
ContentValues values = TaskContract.getContentValues(task);
if (task.getId() == null) {
db.insert(TaskContract.TABLE, null, values);
} else {
String where = TaskContract.ID + " = ? ";
String[] params = {task.getId().toString()};
db.update(TaskContract.TABLE, values, where, params);
}
db.close();
databaseHelper.close();
}