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; }