public FilesLoader(final Context context, final File path, final String[] extensions) {
super(context);
this.path = path;
this.extensions = extensions;
extensions_regex =
extensions != null
? Pattern.compile(
ArrayUtils.toString(extensions, '|', false), Pattern.CASE_INSENSITIVE)
: null;
}
@Override
public Cursor query(
Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
final String table = getTableNameForContentUri(uri);
if (table == null) return null;
final String projection_string =
projection != null ? ArrayUtils.buildString(projection, ',', false) : "*";
if (TABLE_DIRECT_MESSAGES_CONVERSATION.equals(table)) {
// read-only here.
final List<String> segments = uri.getPathSegments();
if (segments.size() != 3) return null;
final StringBuilder sql_builder = new StringBuilder();
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_INBOX);
sql_builder.append(" WHERE " + DirectMessages.ACCOUNT_ID + " = " + segments.get(1));
sql_builder.append(" AND " + DirectMessages.SENDER_ID + " = " + segments.get(2));
if (selection != null) {
sql_builder.append(" AND " + selection);
}
sql_builder.append(" UNION ");
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_OUTBOX);
sql_builder.append(" WHERE " + DirectMessages.ACCOUNT_ID + " = " + segments.get(1));
sql_builder.append(" AND " + DirectMessages.RECIPIENT_ID + " = " + segments.get(2));
if (selection != null) {
sql_builder.append(" AND " + selection);
}
sql_builder.append(
" ORDER BY "
+ (sortOrder != null ? sortOrder : DirectMessages.Conversation.DEFAULT_SORT_ORDER));
try {
return database.rawQuery(sql_builder.toString(), selectionArgs);
} catch (final SQLiteException e) {
mErrorToastHandler.sendMessage(mErrorToastHandler.obtainMessage(0, e));
}
} else if (TABLE_DIRECT_MESSAGES_CONVERSATION_SCREEN_NAME.equals(table)) {
// read-only here.
final List<String> segments = uri.getPathSegments();
if (segments.size() != 3) return null;
final StringBuilder sql_builder = new StringBuilder();
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_INBOX);
sql_builder.append(" WHERE " + DirectMessages.ACCOUNT_ID + " = " + segments.get(1));
sql_builder.append(
" AND " + DirectMessages.SENDER_SCREEN_NAME + " = '" + segments.get(2) + "'");
if (selection != null) {
sql_builder.append(" AND " + selection);
}
sql_builder.append(" UNION ");
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_OUTBOX);
sql_builder.append(" WHERE " + DirectMessages.ACCOUNT_ID + " = " + segments.get(1));
sql_builder.append(
" AND " + DirectMessages.RECIPIENT_SCREEN_NAME + " = '" + segments.get(2) + "'");
if (selection != null) {
sql_builder.append(" AND " + selection);
}
sql_builder.append(
" ORDER BY "
+ (sortOrder != null ? sortOrder : DirectMessages.Conversation.DEFAULT_SORT_ORDER));
try {
return database.rawQuery(sql_builder.toString(), selectionArgs);
} catch (final SQLiteException e) {
mErrorToastHandler.sendMessage(mErrorToastHandler.obtainMessage(0, e));
}
} else if (TABLE_DIRECT_MESSAGES.equals(table)) {
// read-only here.
final StringBuilder sql_builder = new StringBuilder();
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_INBOX);
if (selection != null) {
sql_builder.append(" WHERE " + selection);
}
sql_builder.append(" UNION ");
sql_builder.append("SELECT " + projection_string);
sql_builder.append(" FROM " + TABLE_DIRECT_MESSAGES_OUTBOX);
if (selection != null) {
sql_builder.append(" WHERE " + selection);
}
sql_builder.append(
" ORDER BY " + (sortOrder != null ? sortOrder : DirectMessages.DEFAULT_SORT_ORDER));
try {
return database.rawQuery(sql_builder.toString(), selectionArgs);
} catch (final SQLiteException e) {
mErrorToastHandler.sendMessage(mErrorToastHandler.obtainMessage(0, e));
}
} else if (TABLE_DIRECT_MESSAGES_CONVERSATIONS_ENTRY.equals(table)) {
try {
return database.rawQuery(
DirectMessages.ConversationsEntry.buildSQL(parseInt(uri.getLastPathSegment())), null);
} catch (final SQLiteException e) {
mErrorToastHandler.sendMessage(mErrorToastHandler.obtainMessage(0, e));
}
} else {
try {
return database.query(table, projection, selection, selectionArgs, null, null, sortOrder);
} catch (final SQLiteException e) {
mErrorToastHandler.sendMessage(mErrorToastHandler.obtainMessage(0, e));
}
}
return null;
}