android.database.Cursor#getColumnIndexOrThrow

Source File: MusicUtils.java From LyricHere with Apache License 2.0

6 votes

public static long[] getSongListForCursor(Cursor cursor) {
    if (cursor == null) {
        return sEmptyList;
    }
    int len = cursor.getCount();
    long[] list = new long[len];
    cursor.moveToFirst();
    int colidx = -1;
    try {
        colidx = cursor.getColumnIndexOrThrow(MediaStore.Audio.Playlists.Members.AUDIO_ID);
    } catch (IllegalArgumentException ex) {
        colidx = cursor.getColumnIndexOrThrow(MediaStore.Audio.Media._ID);
    }
    for (int i = 0; i < len; i++) {
        list[i] = cursor.getLong(colidx);
        cursor.moveToNext();
    }
    return list;
}

Source File: Global.java From Favorite-Android-Client with Apache License 2.0

6 votes

public static String getDataColumn(Context context, Uri uri,
		String selection, String[] selectionArgs) {

	Cursor cursor = null;
	final String column = "_data";
	final String[] projection = { column };

	try {
		cursor = context.getContentResolver().query(uri, projection,
				selection, selectionArgs, null);
		if (cursor != null && cursor.moveToFirst()) {
			final int column_index = cursor.getColumnIndexOrThrow(column);
			return cursor.getString(column_index);
		}
	} finally {
		if (cursor != null)
			cursor.close();
	}
	return null;
}

Source File: MusicPlayerRemote.java From Phonograph with GNU General Public License v3.0

6 votes

@Nullable
private static String getFilePathFromUri(Context context, Uri uri)
{
    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection, null, null,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } catch (Exception e) {
        Log.e(TAG, e.getMessage());
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}

Source File: AppUtils.java From BmapLite with Apache License 2.0

6 votes

/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context       The context.
 * @param uri           The Uri to query.
 * @param selection     (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {column};

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}

Source File: AgentWebUtils.java From AgentWeb with Apache License 2.0

6 votes

static String getDataColumn(Context context, Uri uri, String selection, String[] selectionArgs) {
	Cursor cursor = null;
	String[] projection = {MediaStore.Images.Media.DATA};
	try {
		cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs, null);
		if (cursor != null && cursor.moveToFirst()) {
			int index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
			return cursor.getString(index);
		}
	} finally {
		if (cursor != null) {
			cursor.close();
		}
	}
	return null;
}

Source File: MusicUtils.java From mobile-manager-tool with MIT License

6 votes

/**
 * @param cursor
 * @return
 */
public static long[] getSongListForCursor(Cursor cursor) {
    if (cursor == null) {
        return sEmptyList;
    }
    int len = cursor.getCount();
    long[] list = new long[len];
    cursor.moveToFirst();
    int colidx = -1;
    try {
        colidx = cursor.getColumnIndexOrThrow(Playlists.Members.AUDIO_ID);
    } catch (IllegalArgumentException ex) {
        colidx = cursor.getColumnIndexOrThrow(BaseColumns._ID);
    }
    for (int i = 0; i < len; i++) {
        list[i] = cursor.getLong(colidx);
        cursor.moveToNext();
    }
    return list;
}

Source File: Gifflen.java From Pixiv-Shaft with MIT License

6 votes

/**
 * 从Uri获取图片的绝对路径
 *
 * @param context    上下文对象.
 * @param contentUri 传入的Uri数组.
 * @return 文件绝对路径.
 */
public String getRealPathFromURI(Context context, Uri contentUri) {
    Cursor cursor = null;
    try {
        String[] projection = {MediaStore.Images.Media.DATA};
        cursor = context.getContentResolver().query(contentUri, projection, null, null, null);
        if (cursor != null) {
            int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
            cursor.moveToFirst();
            return cursor.getString(column_index);
        }

    } finally {
        if (cursor != null) {
            cursor.close();
        }
    }
    return "";
}

Source File: CommonUtil.java From sctalk with Apache License 2.0

6 votes

/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 * 
 * @param context The context.
 * @param uri The Uri to query.
 * @param selection (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 */
public static String getDataColumn(Context context, Uri uri,
        String selection, String[] selectionArgs) {

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection,
                selection, selectionArgs, null);
        if (cursor != null && cursor.moveToFirst()) {
            final int index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(index);
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }
    return null;
}

Source File: FirestackStorage.java From react-native-firestack with MIT License

6 votes

@ReactMethod
public void getRealPathFromURI(final String uri, final Callback callback) {
  try {
    Context context = getReactApplicationContext();
    String [] proj = {MediaStore.Images.Media.DATA};
    Cursor cursor = context.getContentResolver().query(Uri.parse(uri), proj,  null, null, null);
    int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
    cursor.moveToFirst();
    String path = cursor.getString(column_index); 
    cursor.close();

    callback.invoke(null, path);
  } catch (Exception ex) {
    ex.printStackTrace();
    callback.invoke(makeErrorPayload(1, ex));
  }
}

Source File: SqlStorage.java From commcare-android with Apache License 2.0

6 votes

@Override
public void bulkReadMetadata(LinkedHashSet cuedCases, String[] metaDataIds, HashMap metadataMap) {
    List<Pair<String, String[]>> whereParamList = TableBuilder.sqlList(cuedCases);
    String[] scrubbedNames = scrubMetadataNames(metaDataIds);
    String[] projection = getProjectedFieldsWithId(false, scrubbedNames);

    for (Pair<String, String[]> querySet : whereParamList) {
        Cursor c = helper.getHandle().query(table, projection, DatabaseHelper.ID_COL + " IN " + querySet.first, querySet.second, null, null, null);
        try {
            if (c.getCount() == 0) {
                return;
            } else {
                c.moveToFirst();
                int idIndex = c.getColumnIndexOrThrow(DatabaseHelper.ID_COL);
                while (!c.isAfterLast()) {
                    String[] metaRead = readMetaDataFromCursor(c, scrubbedNames);
                    metadataMap.put(c.getInt(idIndex), metaRead);
                    c.moveToNext();
                }
            }
        } finally {
            c.close();
        }
    }
}

Source File: ContentResolverUtils.java From ImagePicker with Apache License 2.0

6 votes

/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context       The context.
 * @param uri           The Uri to query.
 * @param selection     (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {
    Cursor cursor = null;
    final String column = MediaStore.MediaColumns.DATA;
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            final int index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(index);
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        if (cursor != null) {
            cursor.close();
        }
    }
    return null;
}

Source File: ImageValidator.java From Learning-Resources with MIT License

6 votes

/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context       The context.
 * @param uri           The Uri to query.
 * @param selection     (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 */
public static String getDataColumn(Context context, Uri uri, String selection,
                                   String[] selectionArgs) {
    Cursor cursor = null;
    final String column = "_data";// android.provider.MediaStore.Files.FileColumns.DATA
    final String[] projection = {
            column
    };

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs,
                null);
        if (cursor != null && cursor.moveToFirst()) {
            final int index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(index);
        }
    } finally {
        if (cursor != null) {
            cursor.close();
        }
    }
    return null;
}

Source File: UriHelper.java From libcommon with Apache License 2.0

6 votes

/**
 * Get the value of the data column for this Uri. This is useful for
 * MediaStore Uris, and other file-based ContentProviders.
 *
 * @param context The context.
 * @param uri The Uri to query.
 * @param selection (Optional) Filter used in the query.
 * @param selectionArgs (Optional) Selection arguments used in the query.
 * @return The value of the _data column, which is typically a file path.
 */
@Nullable
public static String getDataColumn(@NonNull final Context context,
	@NonNull final Uri uri, final String selection, final String[] selectionArgs) {

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = { column };

    try {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs, null);
        if ((cursor != null) && cursor.moveToFirst()) {
            final int column_index = cursor.getColumnIndexOrThrow(column);
            return cursor.getString(column_index);
        }
    } finally {
        if (cursor != null) {
            cursor.close();
		}
    }
    return null;
}

Source File: MainActivity.java From BotLibre with Eclipse Public License 1.0

6 votes

public static String getDataColumn(Context context, Uri uri, String selection, String[] selectionArgs) {
	Cursor cursor = null;
	final String column = "_data";
	final String[] projection = { column };
	try {
		cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs, null);
		if (cursor != null && cursor.moveToFirst()) {
			final int index = cursor.getColumnIndexOrThrow(column);
			return cursor.getString(index);
		}
	} finally {
		if (cursor != null)
			cursor.close();
	}
	return null;
}

Source File: UriToPathResolver.java From aptoide-client-v8 with GNU General Public License v3.0

5 votes

public String getMediaStoragePath(Uri contentUri) {
  if (contentUri == null) {
    throw new NullPointerException("content Uri is null");
  }

  Cursor cursor = null;
  try {
    final String columnName = MediaStore.Images.Media.DATA;
    String[] projection = { columnName };
    cursor = contentResolver.query(contentUri, projection, null, null, null);
    if (cursor != null) {
      int column_index = cursor.getColumnIndexOrThrow(columnName);
      cursor.moveToFirst();
      return cursor.getString(column_index);
    }
  } catch (Exception ex) {
    Logger.getInstance()
        .e(TAG, ex);
  } finally {
    if (cursor != null && !cursor.isClosed()) {
      cursor.close();
    }
  }

  // default situation
  return contentUri.toString();
}

Source File: AndroidUtilities.java From TelePlus-Android with GNU General Public License v2.0

5 votes

public static String getDataColumn(Context context, Uri uri, String selection, String[] selectionArgs)
{

    Cursor cursor = null;
    final String column = "_data";
    final String[] projection = {
            column
    };

    try
    {
        cursor = context.getContentResolver().query(uri, projection, selection, selectionArgs, null);
        if (cursor != null && cursor.moveToFirst())
        {
            final int column_index = cursor.getColumnIndexOrThrow(column);
            String value = cursor.getString(column_index);
            if (value.startsWith("content://") || !value.startsWith("/") && !value.startsWith("file://"))
            {
                return null;
            }
            return value;
        }
    }
    catch (Exception ignore)
    {

    }
    finally
    {
        if (cursor != null)
        {
            cursor.close();
        }
    }
    return null;
}

Source File: CursorAdapter.java From letv with Apache License 2.0

5 votes

public Cursor swapCursor(Cursor newCursor) {
    if (newCursor == this.mCursor) {
        return null;
    }
    Cursor oldCursor = this.mCursor;
    if (oldCursor != null) {
        if (this.mChangeObserver != null) {
            oldCursor.unregisterContentObserver(this.mChangeObserver);
        }
        if (this.mDataSetObserver != null) {
            oldCursor.unregisterDataSetObserver(this.mDataSetObserver);
        }
    }
    this.mCursor = newCursor;
    if (newCursor != null) {
        if (this.mChangeObserver != null) {
            newCursor.registerContentObserver(this.mChangeObserver);
        }
        if (this.mDataSetObserver != null) {
            newCursor.registerDataSetObserver(this.mDataSetObserver);
        }
        this.mRowIDColumn = newCursor.getColumnIndexOrThrow("_id");
        this.mDataValid = true;
        notifyDataSetChanged();
        return oldCursor;
    }
    this.mRowIDColumn = -1;
    this.mDataValid = false;
    notifyDataSetInvalidated();
    return oldCursor;
}

Source File: TweetCursorReader.java From Onosendai with Apache License 2.0

4 votes

public String readUserSubtitle (final Cursor c) {
	if (c == null) return null;
	if (this.colUserSubtitle < 0) this.colUserSubtitle = c.getColumnIndexOrThrow(DbAdapter.TBL_TW_USERSUBTITLE);
	return c.getString(this.colUserSubtitle);
}

Source File: AutofillDao_Impl.java From android-AutofillFramework with Apache License 2.0

4 votes

private void __fetchRelationshipResourceIdHeuristicAscomExampleAndroidAutofillServiceModelResourceIdHeuristic(final ArrayMap<String, ArrayList<ResourceIdHeuristic>> _map) {
  final Set<String> __mapKeySet = _map.keySet();
  if (__mapKeySet.isEmpty()) {
    return;
  }
  StringBuilder _stringBuilder = StringUtil.newStringBuilder();
  _stringBuilder.append("SELECT resourceIdHeuristic,packageName,fieldTypeName FROM `ResourceIdHeuristic` WHERE fieldTypeName IN (");
  final int _inputSize = __mapKeySet.size();
  StringUtil.appendPlaceholders(_stringBuilder, _inputSize);
  _stringBuilder.append(")");
  final String _sql = _stringBuilder.toString();
  final int _argCount = 0 + _inputSize;
  final RoomSQLiteQuery _stmt = RoomSQLiteQuery.acquire(_sql, _argCount);
  int _argIndex = 1;
  for (String _item : __mapKeySet) {
    if (_item == null) {
      _stmt.bindNull(_argIndex);
    } else {
      _stmt.bindString(_argIndex, _item);
    }
    _argIndex ++;
  }
  final Cursor _cursor = __db.query(_stmt);
  try {
    final int _itemKeyIndex = _cursor.getColumnIndex("fieldTypeName");
    if (_itemKeyIndex == -1) {
      return;
    }
    final int _cursorIndexOfMResourceIdHeuristic = _cursor.getColumnIndexOrThrow("resourceIdHeuristic");
    final int _cursorIndexOfMPackageName = _cursor.getColumnIndexOrThrow("packageName");
    final int _cursorIndexOfMFieldTypeName = _cursor.getColumnIndexOrThrow("fieldTypeName");
    while(_cursor.moveToNext()) {
      if (!_cursor.isNull(_itemKeyIndex)) {
        final String _tmpKey = _cursor.getString(_itemKeyIndex);
        ArrayList<ResourceIdHeuristic> _tmpCollection = _map.get(_tmpKey);
        if (_tmpCollection != null) {
          final ResourceIdHeuristic _item_1;
          final String _tmpMResourceIdHeuristic;
          _tmpMResourceIdHeuristic = _cursor.getString(_cursorIndexOfMResourceIdHeuristic);
          final String _tmpMPackageName;
          _tmpMPackageName = _cursor.getString(_cursorIndexOfMPackageName);
          final String _tmpMFieldTypeName;
          _tmpMFieldTypeName = _cursor.getString(_cursorIndexOfMFieldTypeName);
          _item_1 = new ResourceIdHeuristic(_tmpMResourceIdHeuristic,_tmpMFieldTypeName,_tmpMPackageName);
          _tmpCollection.add(_item_1);
        }
      }
    }
  } finally {
    _cursor.close();
  }
}

Source File: MediaStoreServiceImpl.java From AndroidMvc with Apache License 2.0

4 votes

/**
 * Extract an imageDTO from given cursor position from its current position.
 * @param cursor
 * @return
 */
protected ImageDTO extractOneImageFromCurrentCursor(Cursor cursor) {
    int api = android.os.Build.VERSION.SDK_INT;
    if(imageIdCol == -1) {
        imageIdCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media._ID);
        imageTitleCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.TITLE);
        imageDisplayNameCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DISPLAY_NAME);
        imageDescriptionCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DESCRIPTION);
        imageBucketIdCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.BUCKET_ID);
        imageBucketDisplayNameCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.BUCKET_DISPLAY_NAME);
        imageDataCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
        imageMimeCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.MIME_TYPE);
        imageSizeCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.SIZE);
        imageOrientationCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.ORIENTATION);
        imageDateAddedCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATE_ADDED);
        imageDateTakenCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATE_TAKEN);
        imageDateModifyCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATE_MODIFIED);
        latitudeCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.LATITUDE);
        longitudeCol = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.LONGITUDE);
        if (api >= 16) {
            widthCol = cursor.getColumnIndexOrThrow(MediaStore_Media_WIDTH);
            heightCol = cursor.getColumnIndexOrThrow(MediaStore_Media_HEIGHT);
        }
    }

    ImageDTO image = new ImageDTO();
    image.setId(cursor.getLong(imageIdCol));
    image.setTitle(cursor.getString(imageTitleCol));
    image.setDisplayName(cursor.getString(imageDisplayNameCol));
    image.setDescription(cursor.getString(imageDescriptionCol));
    image.setBucketId(cursor.getString(imageBucketIdCol));
    image.setBucketDisplayName(cursor.getString(imageBucketDisplayNameCol));
    image.setUri(cursor.getString(imageDataCol));
    image.setMimeType(cursor.getString(imageMimeCol));
    image.setSize(cursor.getLong(imageSizeCol));
    image.setOrientation(translateOrientation(cursor.getInt(imageOrientationCol)));
    image.setAddedDate(new Date(cursor.getLong(imageDateAddedCol)));
    image.setTakenDate(new Date(cursor.getLong(imageDateTakenCol)));
    image.setModifyDate(new Date(cursor.getLong(imageDateModifyCol)));
    image.setLatitude(cursor.getDouble(latitudeCol));
    image.setLongitude(cursor.getDouble(longitudeCol));
    if (api >= 16) {
        image.setWidth(cursor.getInt(widthCol));
        image.setHeight(cursor.getInt(heightCol));
    }

    return image;
}

Java Code Examples for android.database.Cursor#getColumnIndexOrThrow()