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