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

The following examples show how to use android.database.Cursor#getFloat() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source Project: framework File: OCursorListAdapter.java License: GNU Affero General Public License v3.0

6 votes

private Object getValue(Cursor c, String column) {
    Object value = false;
    int index = c.getColumnIndex(column);
    switch (c.getType(index)) {
        case Cursor.FIELD_TYPE_NULL:
            value = false;
            break;
        case Cursor.FIELD_TYPE_BLOB:
        case Cursor.FIELD_TYPE_STRING:
            value = c.getString(index);
            break;
        case Cursor.FIELD_TYPE_FLOAT:
            value = c.getFloat(index);
            break;
        case Cursor.FIELD_TYPE_INTEGER:
            value = c.getInt(index);
            break;
    }
    return value;
}

Example 2

Source Project: open File: RouteFragment.java License: GNU General Public License v3.0

6 votes

public float getAverageSpeed() {
    if (db == null) {
        return 0;
    }

    Cursor cursor = db.
            rawQuery("SELECT AVG(" + COLUMN_SPEED + ") as avg_speed "
                    + "from (select " + COLUMN_SPEED + " from "
                    + TABLE_LOCATIONS
                    + " where "
                    + COLUMN_ROUTE_ID
                    + " = '"
                    + routeId
                    + "' ORDER BY time DESC LIMIT "
                    + getNumberOfLocationsForAverageSpeed()
                    + ")", null);
    cursor.moveToFirst();
    return cursor.getFloat(0);
}

Example 3

Source Project: Telegram-FOSS File: DefaultDownloadIndex.java License: GNU General Public License v2.0

6 votes

private static Download getDownloadForCurrentRow(Cursor cursor) {
  DownloadRequest request =
      new DownloadRequest(
          /* id= */ cursor.getString(COLUMN_INDEX_ID),
          /* type= */ cursor.getString(COLUMN_INDEX_TYPE),
          /* uri= */ Uri.parse(cursor.getString(COLUMN_INDEX_URI)),
          /* streamKeys= */ decodeStreamKeys(cursor.getString(COLUMN_INDEX_STREAM_KEYS)),
          /* customCacheKey= */ cursor.getString(COLUMN_INDEX_CUSTOM_CACHE_KEY),
          /* data= */ cursor.getBlob(COLUMN_INDEX_DATA));
  DownloadProgress downloadProgress = new DownloadProgress();
  downloadProgress.bytesDownloaded = cursor.getLong(COLUMN_INDEX_BYTES_DOWNLOADED);
  downloadProgress.percentDownloaded = cursor.getFloat(COLUMN_INDEX_PERCENT_DOWNLOADED);
  return new Download(
      request,
      /* state= */ cursor.getInt(COLUMN_INDEX_STATE),
      /* startTimeMs= */ cursor.getLong(COLUMN_INDEX_START_TIME_MS),
      /* updateTimeMs= */ cursor.getLong(COLUMN_INDEX_UPDATE_TIME_MS),
      /* contentLength= */ cursor.getLong(COLUMN_INDEX_CONTENT_LENGTH),
      /* stopReason= */ cursor.getInt(COLUMN_INDEX_STOP_REASON),
      /* failureReason= */ cursor.getInt(COLUMN_INDEX_FAILURE_REASON),
      downloadProgress);
}

Example 4

Source Project: storio File: PrimitiveMethodsFactoryMethodStorIOSQLiteGetResolver.java License: Apache License 2.0

6 votes

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public PrimitiveMethodsFactoryMethod mapFromCursor(@NonNull StorIOSQLite storIOSQLite, @NonNull Cursor cursor) {

    boolean field1 = cursor.getInt(cursor.getColumnIndex("field1")) == 1;
    short field2 = cursor.getShort(cursor.getColumnIndex("field2"));
    int field3 = cursor.getInt(cursor.getColumnIndex("field3"));
    long field4 = cursor.getLong(cursor.getColumnIndex("field4"));
    float field5 = cursor.getFloat(cursor.getColumnIndex("field5"));
    double field6 = cursor.getDouble(cursor.getColumnIndex("field6"));
    String field7 = cursor.getString(cursor.getColumnIndex("field7"));
    byte[] field8 = cursor.getBlob(cursor.getColumnIndex("field8"));

    PrimitiveMethodsFactoryMethod object = PrimitiveMethodsFactoryMethod.create(field1, field2, field3, field4, field5, field6, field7, field8);

    return object;
}

Example 5

Source Project: BaseProject File: Progress.java License: Apache License 2.0

6 votes

public static Progress parseCursorToBean(Cursor cursor) {
    Progress progress = new Progress();
    progress.tag = cursor.getString(cursor.getColumnIndex(Progress.TAG));
    progress.url = cursor.getString(cursor.getColumnIndex(Progress.URL));
    progress.folder = cursor.getString(cursor.getColumnIndex(Progress.FOLDER));
    progress.filePath = cursor.getString(cursor.getColumnIndex(Progress.FILE_PATH));
    progress.fileName = cursor.getString(cursor.getColumnIndex(Progress.FILE_NAME));
    progress.fraction = cursor.getFloat(cursor.getColumnIndex(Progress.FRACTION));
    progress.totalSize = cursor.getLong(cursor.getColumnIndex(Progress.TOTAL_SIZE));
    progress.currentSize = cursor.getLong(cursor.getColumnIndex(Progress.CURRENT_SIZE));
    progress.status = cursor.getInt(cursor.getColumnIndex(Progress.STATUS));
    progress.priority = cursor.getInt(cursor.getColumnIndex(Progress.PRIORITY));
    progress.date = cursor.getLong(cursor.getColumnIndex(Progress.DATE));
    progress.request = (Request<?, ? extends Request>) IOUtils.toObject(cursor.getBlob(cursor.getColumnIndex(Progress.REQUEST)));
    progress.extra1 = (Serializable) IOUtils.toObject(cursor.getBlob(cursor.getColumnIndex(Progress.EXTRA1)));
    progress.extra2 = (Serializable) IOUtils.toObject(cursor.getBlob(cursor.getColumnIndex(Progress.EXTRA2)));
    progress.extra3 = (Serializable) IOUtils.toObject(cursor.getBlob(cursor.getColumnIndex(Progress.EXTRA3)));
    return progress;
}

Example 6

Source Project: storio File: BoxedTypesMethodsFactoryMethodStorIOSQLiteGetResolver.java License: Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public BoxedTypesMethodsFactoryMethod mapFromCursor(@NonNull StorIOSQLite storIOSQLite, @NonNull Cursor cursor) {

    Boolean field1 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field1"))) {
        field1 = cursor.getInt(cursor.getColumnIndex("field1")) == 1;
    }
    Short field2 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field2"))) {
        field2 = cursor.getShort(cursor.getColumnIndex("field2"));
    }
    Integer field3 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field3"))) {
        field3 = cursor.getInt(cursor.getColumnIndex("field3"));
    }
    Long field4 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field4"))) {
        field4 = cursor.getLong(cursor.getColumnIndex("field4"));
    }
    Float field5 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field5"))) {
        field5 = cursor.getFloat(cursor.getColumnIndex("field5"));
    }
    Double field6 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field6"))) {
        field6 = cursor.getDouble(cursor.getColumnIndex("field6"));
    }

    BoxedTypesMethodsFactoryMethod object = BoxedTypesMethodsFactoryMethod.create(field1, field2, field3, field4, field5, field6);

    return object;
}

Example 7

Source Project: EhViewer File: SqlUtils.java License: Apache License 2.0

5 votes

public static float getFloat(Cursor cursor, String column, float defValue) {
    try {
        int index = cursor.getColumnIndex(column);
        if (index != -1) {
            return cursor.getFloat(index);
        }
    } catch (Throwable e) { /* Ignore */ }
    return defValue;
}

Example 8

Source Project: storio File: BoxedTypesFieldsIgnoreNullStorIOContentResolverGetResolver.java License: Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public BoxedTypesFieldsIgnoreNull mapFromCursor(@NonNull StorIOContentResolver storIOContentResolver, @NonNull Cursor cursor) {
    BoxedTypesFieldsIgnoreNull object = new BoxedTypesFieldsIgnoreNull();

    if (!cursor.isNull(cursor.getColumnIndex("field1"))) {
        object.field1 = cursor.getInt(cursor.getColumnIndex("field1")) == 1;
    }
    if (!cursor.isNull(cursor.getColumnIndex("field2"))) {
        object.field2 = cursor.getShort(cursor.getColumnIndex("field2"));
    }
    if (!cursor.isNull(cursor.getColumnIndex("field3"))) {
        object.field3 = cursor.getInt(cursor.getColumnIndex("field3"));
    }
    if (!cursor.isNull(cursor.getColumnIndex("field4"))) {
        object.field4 = cursor.getLong(cursor.getColumnIndex("field4"));
    }
    if (!cursor.isNull(cursor.getColumnIndex("field5"))) {
        object.field5 = cursor.getFloat(cursor.getColumnIndex("field5"));
    }
    if (!cursor.isNull(cursor.getColumnIndex("field6"))) {
        object.field6 = cursor.getDouble(cursor.getColumnIndex("field6"));
    }

    return object;
}

Example 9

Source Project: opentasks-provider File: FloatFieldAdapter.java License: Apache License 2.0

5 votes

@Override
public Float getFrom(Cursor cursor)
{
	int columnIdx = cursor.getColumnIndex(mFieldName);
	if (columnIdx < 0)
	{
		throw new IllegalArgumentException("The column '" + mFieldName + "' is missing in cursor.");
	}
	return cursor.isNull(columnIdx) ? null : cursor.getFloat(columnIdx);
}

Example 10

Source Project: opentasks File: FloatFieldAdapter.java License: Apache License 2.0

5 votes

@Override
public Float getFrom(Cursor cursor)
{
    int columnIdx = cursor.getColumnIndex(mFieldName);
    if (columnIdx < 0)
    {
        throw new IllegalArgumentException("The column '" + mFieldName + "' is missing in cursor.");
    }
    return cursor.isNull(columnIdx) ? null : cursor.getFloat(columnIdx);
}

Example 11

Source Project: storio File: BoxedTypesPrivateFieldsIgnoreNullStorIOContentResolverGetResolver.java License: Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public BoxedTypesPrivateFieldsIgnoreNull mapFromCursor(@NonNull StorIOContentResolver storIOContentResolver, @NonNull Cursor cursor) {

    Boolean field1 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field1"))) {
        field1 = cursor.getInt(cursor.getColumnIndex("field1")) == 1;
    }
    Short field2 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field2"))) {
        field2 = cursor.getShort(cursor.getColumnIndex("field2"));
    }
    Integer field3 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field3"))) {
        field3 = cursor.getInt(cursor.getColumnIndex("field3"));
    }
    Long field4 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field4"))) {
        field4 = cursor.getLong(cursor.getColumnIndex("field4"));
    }
    Float field5 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field5"))) {
        field5 = cursor.getFloat(cursor.getColumnIndex("field5"));
    }
    Double field6 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field6"))) {
        field6 = cursor.getDouble(cursor.getColumnIndex("field6"));
    }

    BoxedTypesPrivateFieldsIgnoreNull object = new BoxedTypesPrivateFieldsIgnoreNull(field1, field2, field3, field4, field5, field6);

    return object;
}

Example 12

Source Project: BeMusic File: MediaUtils.java License: Apache License 2.0

5 votes

private static List<Song> getAudioList (Cursor cursor) {
    List<Song> audioList = null;
    if (cursor.getCount() > 0) {
        audioList = new ArrayList<Song>();
        for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
            Bundle bundle = new Bundle ();
            for (int i = 0; i < AUDIO_KEYS.length; i++) {
                final String key = AUDIO_KEYS[i];
                final int columnIndex = cursor.getColumnIndex(key);
                final int type = cursor.getType(columnIndex);
                switch (type) {
                    case Cursor.FIELD_TYPE_BLOB:
                        break;
                    case Cursor.FIELD_TYPE_FLOAT:
                        float floatValue = cursor.getFloat(columnIndex);
                        bundle.putFloat(key, floatValue);
                        break;
                    case Cursor.FIELD_TYPE_INTEGER:
                        int intValue = cursor.getInt(columnIndex);
                        bundle.putInt(key, intValue);
                        break;
                    case Cursor.FIELD_TYPE_NULL:
                        break;
                    case Cursor.FIELD_TYPE_STRING:
                        String strValue = cursor.getString(columnIndex);
                        bundle.putString(key, strValue);
                        break;
                }
            }
            Song audio = new Song(bundle);
            audioList.add(audio);
        }
    }

    cursor.close();
    return audioList;
}

Example 13

Source Project: storio File: BoxedTypesMethodsConstructorIgnoreNullStorIOContentResolverGetResolver.java License: Apache License 2.0

5 votes

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public BoxedTypesMethodsConstructorIgnoreNull mapFromCursor(@NonNull StorIOContentResolver storIOContentResolver, @NonNull Cursor cursor) {

    Boolean field1 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field1"))) {
        field1 = cursor.getInt(cursor.getColumnIndex("field1")) == 1;
    }
    Short field2 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field2"))) {
        field2 = cursor.getShort(cursor.getColumnIndex("field2"));
    }
    Integer field3 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field3"))) {
        field3 = cursor.getInt(cursor.getColumnIndex("field3"));
    }
    Long field4 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field4"))) {
        field4 = cursor.getLong(cursor.getColumnIndex("field4"));
    }
    Float field5 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field5"))) {
        field5 = cursor.getFloat(cursor.getColumnIndex("field5"));
    }
    Double field6 = null;
    if (!cursor.isNull(cursor.getColumnIndex("field6"))) {
        field6 = cursor.getDouble(cursor.getColumnIndex("field6"));
    }

    BoxedTypesMethodsConstructorIgnoreNull object = new BoxedTypesMethodsConstructorIgnoreNull(field1, field2, field3, field4, field5, field6);

    return object;
}

Example 14

Source Project: NoiseCapture File: Storage.java License: GNU General Public License v3.0

4 votes

public LeqValue(Cursor cursor) {
    this(cursor.getInt(cursor.getColumnIndex(COLUMN_LEQ_ID)),
            cursor.getInt(cursor.getColumnIndex(COLUMN_FREQUENCY)),
            cursor.getFloat(cursor.getColumnIndex(COLUMN_SPL)));
}

Example 15

Source Project: android-open-project-demo File: FloatColumnConverter.java License: Apache License 2.0

4 votes

@Override
public Float getFieldValue(final Cursor cursor, int index) {
    return cursor.isNull(index) ? null : cursor.getFloat(index);
}

Example 16

Source Project: your-local-weather File: LocationsFileDbHelper.java License: GNU General Public License v3.0

4 votes

public Location getLocationById(long id) {
    SQLiteDatabase db = getReadableDatabase();

    String[] projection = {
            LocationsContract.Locations.COLUMN_NAME_ADDRESS,
            LocationsContract.Locations.COLUMN_NAME_ORDER_ID,
            LocationsContract.Locations.COLUMN_NAME_LONGITUDE,
            LocationsContract.Locations.COLUMN_NAME_LATITUDE,
            LocationsContract.Locations.COLUMN_NAME_LOCALE,
            LocationsContract.Locations.COLUMN_NAME_LOCATION_NICKNAME,
            LocationsContract.Locations.COLUMN_NAME_LOCATION_ACCURACY,
            LocationsContract.Locations.COLUMN_NAME_ENABLED,
            LocationsContract.Locations.COLUMN_NAME_LAST_UPDATE_TIME_IN_MS,
            LocationsContract.Locations.COLUMN_NAME_LOCATION_UPDATE_SOURCE,
            LocationsContract.Locations.COLUMN_NAME_ADDRESS_FOUND
    };

    Cursor cursor = null;
    try {
        cursor = db.query(
            LocationsContract.Locations.TABLE_NAME,
            projection,
            LocationsContract.Locations._ID + "=" + id,
            null,
            null,
            null,
            null
        );

        if (!cursor.moveToNext()) {
            return null;
        }

        byte[] cachedAddressBytes = cursor.getBlob(
                cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_ADDRESS));
        Address address = null;
        if (cachedAddressBytes != null) {
            address = LocationsDbHelper.getAddressFromBytes(cachedAddressBytes);
        }

        int orderId = cursor.getInt(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_ORDER_ID));
        double longitude = cursor.getDouble(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LONGITUDE));
        double latitude = cursor.getDouble(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LATITUDE));
        String locale = cursor.getString(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LOCALE));
        String nickname = cursor.getString(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LOCATION_NICKNAME));
        float accuracy = cursor.getFloat(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LOCATION_ACCURACY));
        long locationUpdateTime = cursor.getLong(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LAST_UPDATE_TIME_IN_MS));
        String locationSource = cursor.getString(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_LOCATION_UPDATE_SOURCE));
        boolean addressFound = 1 == cursor.getInt(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_ADDRESS_FOUND));
        boolean enabled = 1 == cursor.getInt(cursor.getColumnIndexOrThrow(LocationsContract.Locations.COLUMN_NAME_ENABLED));

        if (locale == null) {
            locale = PreferenceUtil.getLanguage(context);
        }

        return new Location(
                id,
                orderId,
                nickname,
                locale,
                longitude,
                latitude,
                accuracy,
                locationSource,
                locationUpdateTime,
                addressFound,
                enabled,
                address);
    } finally {
        if (cursor != null) {
            cursor.close();
        }
    }
}

Example 17

Source Project: cathode File: Cursors.java License: Apache License 2.0

4 votes

public static float getFloat(Cursor cursor, String column) {
  return cursor.getFloat(cursor.getColumnIndexOrThrow(column));
}

Example 18

Source Project: GPSLogger File: DatabaseHandler.java License: GNU General Public License v3.0

4 votes

public List<LocationExtended> getPlacemarksList(long TrackID, long startNumber, long endNumber) {

        List<LocationExtended> placemarkList = new ArrayList<>();

        String selectQuery = "SELECT  * FROM " + TABLE_PLACEMARKS + " WHERE "
                + KEY_TRACK_ID + " = " + TrackID + " AND "
                + KEY_LOCATION_NUMBER + " BETWEEN " + startNumber + " AND " + endNumber
                + " ORDER BY " + KEY_LOCATION_NUMBER;

        //Log.w("myApp", "[#] DatabaseHandler.java - getLocationList(" + TrackID + ", " + startNumber + ", " +endNumber + ") ==> " + selectQuery);

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
        double lcdata_double;
        float lcdata_float;

        if (cursor != null) {
            // looping through all rows and adding to list
            if (cursor.moveToFirst()) {
                do {
                    Location lc = new Location("DB");
                    lc.setLatitude(cursor.getDouble(3));
                    lc.setLongitude(cursor.getDouble(4));

                    lcdata_double = cursor.getDouble(5);
                    if (lcdata_double != NOT_AVAILABLE) lc.setAltitude(lcdata_double);
                    //else lc.removeAltitude();

                    lcdata_float = cursor.getFloat(6);
                    if (lcdata_float != NOT_AVAILABLE) lc.setSpeed(lcdata_float);
                    //else lc.removeSpeed();

                    lcdata_float = cursor.getFloat(7);
                    if (lcdata_float != NOT_AVAILABLE) lc.setAccuracy(lcdata_float);
                    //else lc.removeAccuracy();

                    lcdata_float = cursor.getFloat(8);
                    if (lcdata_float != NOT_AVAILABLE) lc.setBearing(lcdata_float);
                    //else lc.removeBearing();

                    lc.setTime(cursor.getLong(9));

                    LocationExtended extdloc = new LocationExtended(lc);
                    extdloc.setNumberOfSatellites(cursor.getInt(10));
                    extdloc.setNumberOfSatellitesUsedInFix(cursor.getInt(13));
                    extdloc.setDescription(cursor.getString(12));

                    placemarkList.add(extdloc); // Add Location to list
                } while (cursor.moveToNext());
            }
            cursor.close();
        }
        return placemarkList;
    }

Example 19

Source Project: sprinkles File: FloatSerializer.java License: Apache License 2.0

4 votes

@Override
public Float unpack(Cursor c, String name) {
    return c.getFloat(c.getColumnIndexOrThrow(name));
}

Example 20

Source Project: twitt4droid File: SQLiteUtils.java License: Apache License 2.0

2 votes

/**
 * Gets the float value of the given column.
 * 
 * @param cursor a Cursor.
 * @param columnName the column name.
 * @return the column value if exists; otherwise {@code null}.
 */
static Float getFloat(Cursor cursor, String columnName) {
    return containsColumn(cursor, columnName) && !cursor.isNull(cursor.getColumnIndex(columnName))
            ? cursor.getFloat(cursor.getColumnIndex(columnName))
            : null;
}