private void loadAllEmotions(Event event) { String[] columns = new String[] {EmotionColumns._ID, EmotionColumns.EVENT_ID, EmotionColumns.EMOTION_TYPE}; String where = EmotionColumns.EVENT_ID + "='" + event.getId() + "'"; Cursor listOfEmotions = context.getContentResolver().query(EmotionColumns.CONTENT_URI, columns, where, null, null); if (listOfEmotions.moveToFirst()) { do { String id = listOfEmotions.getString(listOfEmotions.getColumnIndex(EmotionColumns._ID)); switch (listOfEmotions.getInt(listOfEmotions.getColumnIndex(EmotionColumns.EMOTION_TYPE))) { case 1: event.addEmotion(new Emotion(id, EmotionEnum.LIKE)); break; case 2: event.addEmotion(new Emotion(id, EmotionEnum.COOL)); break; case 3: event.addEmotion(new Emotion(id, EmotionEnum.DISLIKE)); break; case 4: event.addEmotion(new Emotion(id, EmotionEnum.SAD)); break; } } while (listOfEmotions.moveToNext()); } listOfEmotions.close(); }
private void loadAllConnectedEventItems(Event event) { String[] eventItemsTableColumns = new String[] { EventItemsColumns.EVENT_ID, EventItemsColumns.EVENT_ITEM_ID, EventItemsColumns.EVENT_ITEM_TYPE }; whereStatement = EventItemsColumns.EVENT_ID + "='" + event.getId() + "'"; String sortOrder = EventItemsColumns.CREATED_DATE + " ASC"; Cursor listOfEventItems = context .getContentResolver() .query( EventItemsColumns.CONTENT_URI, eventItemsTableColumns, whereStatement, null, sortOrder); DatabaseUtils.dumpCursor(listOfEventItems); Log.i("CURSOR", String.valueOf(listOfEventItems.moveToFirst())); if (listOfEventItems.moveToFirst()) { do { String eventItemID = listOfEventItems.getString( listOfEventItems.getColumnIndex(EventItemsColumns.EVENT_ITEM_ID)); int itemType = listOfEventItems.getInt( listOfEventItems.getColumnIndex(EventItemsColumns.EVENT_ITEM_TYPE)); if (itemType == ModelType.SimpleNote.numberOfType()) { addNoteItemToEvent(event, eventItemID); } if (itemType == ModelType.SimplePicture.numberOfType()) { addPictureItemToEvent(event, eventItemID); } if (itemType == ModelType.SimpleRecording.numberOfType()) { addRecordingItemToEvent(event, eventItemID); } if (itemType == ModelType.SimpleVideo.numberOfType()) { addVideoItemToEvent(event, eventItemID); } } while (listOfEventItems.moveToNext()); } listOfEventItems.close(); }
public ArrayList<BaseEvent> LoadAllEventsFromDatabase() { ArrayList<BaseEvent> allEvents = new ArrayList<BaseEvent>(); String[] eventTableColumns = new String[] { EventColumns._ID, EventColumns.EVENT_EXPERIENCEID, EventColumns.EVENT_TITLE, EventColumns.EVENT_LOCATION_LAT, EventColumns.EVENT_LOCATION_LNG, EventColumns.IS_SHARED, EventColumns.CREATOR, EventColumns.MOODX, EventColumns.MOODY }; Cursor c = context .getContentResolver() .query(EventColumns.CONTENT_URI, eventTableColumns, null, null, null); if (c.moveToFirst()) { do { Date createdDate = new Date(c.getLong(c.getColumnIndex(EventColumns.EVENT_TITLE))); Location location = new Location(""); location.setLatitude( Double.parseDouble(c.getString(c.getColumnIndex(EventColumns.EVENT_LOCATION_LAT)))); location.setLongitude( Double.parseDouble(c.getString(c.getColumnIndex(EventColumns.EVENT_LOCATION_LNG)))); if ((Double.parseDouble(c.getString(c.getColumnIndex(EventColumns.MOODX))) == 1000)) { Event event = new Event( c.getString(c.getColumnIndex(EventColumns._ID)), c.getString(c.getColumnIndex(EventColumns.EVENT_EXPERIENCEID)), createdDate, location, new Account(c.getString(c.getColumnIndex(EventColumns.CREATOR)), "com.google")); event.setShared( (c.getInt((c.getColumnIndex(EventColumns.IS_SHARED))) == 1) ? true : false); loadAllEmotions(event); loadAllConnectedEventItems(event); event.setTags(tagManager.getAllTagsConnectedToEvent(event.getId())); allEvents.add(event); } else { MoodEvent moodEvent = new MoodEvent( c.getString(c.getColumnIndex(EventColumns._ID)), c.getString(c.getColumnIndex(EventColumns.EVENT_EXPERIENCEID)), createdDate, location, MoodEnum.getType( (Double.parseDouble(c.getString(c.getColumnIndex(EventColumns.MOODX)))), (Double.parseDouble(c.getString(c.getColumnIndex(EventColumns.MOODY))))), new Account(c.getString(c.getColumnIndex(EventColumns.CREATOR)), "com.google")); allEvents.add(moodEvent); } } while (c.moveToNext()); } c.close(); Log.i("CONTENTLOADER - EVENTS", allEvents.size() + " events loaded"); return allEvents; }