public static void delete(long id) { DatabaseHelper databaseHelper = DatabaseHelper.getInstance(); SQLiteDatabase db = databaseHelper.getWritableDatabase(); String where = TaskContract.ID + " = ? "; String[] params = {String.valueOf(id)}; db.delete(TaskContract.TABLE, where, params); db.close(); databaseHelper.close(); }
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 long getTaskByWebId(long webId) { DatabaseHelper databaseHelper = DatabaseHelper.getInstance(); SQLiteDatabase db = databaseHelper.getReadableDatabase(); String where = TaskContract.IDWEB + " = ? "; String[] params = {String.valueOf(webId)}; Cursor cursor = db.query(TaskContract.TABLE, TaskContract.COLUMNS, where, params, null, null, null); long idWebRetorno = TaskContract.getTask(cursor).get_id(); db.close(); databaseHelper.close(); return idWebRetorno; }
public static Label getLabelByTaskId(long id) { DatabaseHelper databaseHelper = DatabaseHelper.getInstance(); SQLiteDatabase db = databaseHelper.getReadableDatabase(); String where = TaskContract._ID + " = ? "; String[] params = {String.valueOf(id)}; Cursor cursor = db.query(TaskContract.TABLE, TaskContract.COLUMNS, where, params, null, null, null); Label label = TaskContract.getTask(cursor).getLabel(); db.close(); databaseHelper.close(); return label; }
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(); }