protected static List<Action> getAlarmActions( SleepAsAndroidConstants.SLEEP_AS_ANDROID_ALARM_EVENT event) throws Exception { ArrayList<Action> actions = new ArrayList<>(); String[] columns = { SleepAsAndroidActionTable.COLUMN_ALARM_TYPE_ID, SleepAsAndroidActionTable.COLUMN_ACTION_ID }; Cursor cursor = DatabaseHandler.database.query( SleepAsAndroidActionTable.TABLE_NAME, columns, SleepAsAndroidActionTable.COLUMN_ALARM_TYPE_ID + "==" + event.getId(), null, null, null, null); cursor.moveToFirst(); while (!cursor.isAfterLast()) { Long actionId = cursor.getLong(1); actions.add(ActionHandler.get(actionId)); cursor.moveToNext(); } cursor.close(); return actions; }
private static void addAlarmActions( SleepAsAndroidConstants.SLEEP_AS_ANDROID_ALARM_EVENT event, ArrayList<Action> actions) throws Exception { // add actions to database ArrayList<Long> actionIds = ActionHandler.add(actions); // add AlarmTriggered <-> action relation for (Long actionId : actionIds) { ContentValues values = new ContentValues(); values.put(SleepAsAndroidActionTable.COLUMN_ALARM_TYPE_ID, event.getId()); values.put(SleepAsAndroidActionTable.COLUMN_ACTION_ID, actionId); DatabaseHandler.database.insert(SleepAsAndroidActionTable.TABLE_NAME, null, values); } }