/**
* Get friend key associated with event id
*
* @param context Context with permissions to access Notification db
* @param eventId Id of event
* @return Event title or null if not found.
*/
public static String getFriendKey(final Context context, long eventId) {
Cursor cursor = null;
String freindKey = null;
try {
cursor =
queryEvents(
context,
new String[] {Notification.EventColumns.FRIEND_KEY},
EVENT_ID + " = " + eventId,
null,
null);
if (cursor != null && cursor.moveToFirst()) {
int titleIndex = cursor.getColumnIndex(Notification.EventColumns.FRIEND_KEY);
freindKey = cursor.getString(titleIndex);
}
} catch (SQLException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query events", e);
}
} catch (SecurityException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query events", e);
}
} catch (IllegalArgumentException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query events", e);
}
} finally {
if (cursor != null) {
cursor.close();
}
}
return freindKey;
}
/**
* Get source ids associated with extension.
*
* @param context Context with permissions to access Notification db
* @return Source ids, empty array if not found
*/
public static ArrayList<Integer> getSourceIds(final Context context, boolean enabled) {
ArrayList<Integer> sourceIds = new ArrayList<Integer>();
Cursor cursor = null;
String where = Notification.SourceColumns.ENABLED + "=" + (enabled ? "1" : "0");
try {
cursor =
querySources(context, new String[] {Notification.SourceColumns._ID}, where, null, null);
while (cursor != null && cursor.moveToNext()) {
sourceIds.add(cursor.getInt(cursor.getColumnIndex(Notification.SourceColumns._ID)));
}
} catch (SQLException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query source", e);
}
} catch (SecurityException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query source", e);
}
} catch (IllegalArgumentException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query source", e);
}
} finally {
if (cursor != null) {
cursor.close();
}
}
return sourceIds;
}
/**
* Get all source ids associated with extension
*
* @param context Context with permissions to access Notification db
* @return All source ids, empty array if not found
*/
public static ArrayList<Long> getSourceIds(final Context context) {
ArrayList<Long> sourceIds = new ArrayList<Long>();
Cursor cursor = null;
try {
cursor =
querySources(context, new String[] {Notification.SourceColumns._ID}, null, null, null);
if (cursor != null && cursor.moveToFirst()) {
do {
sourceIds.add(cursor.getLong(cursor.getColumnIndex(Notification.SourceColumns._ID)));
} while (cursor.moveToNext());
}
} catch (SQLException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query sources", e);
}
} catch (SecurityException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query sources", e);
}
} catch (IllegalArgumentException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to query sources", e);
}
} finally {
if (cursor != null) {
cursor.close();
}
}
return sourceIds;
}
/**
* Add new event to Event table
*
* @param context Context with permissions to access Notification db
* @param eventValues A reference to the notification com.sonyericsson.extras
* .liveware.aef.notification.Notification.
* @return Uri to the created event
*/
public static Uri addEvent(final Context context, final ContentValues eventValues) {
try {
return context.getContentResolver().insert(Notification.Event.URI, eventValues);
} catch (SQLException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to add event", e);
}
} catch (SecurityException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to add event", e);
}
} catch (IllegalArgumentException e) {
if (Dbg.DEBUG) {
Dbg.w("Failed to add event", e);
}
}
return null;
}