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

public static String queryForString(Context context, Uri self, String column,
        String defaultValue) {
    final ContentResolver resolver = context.getContentResolver();

    Cursor c = null;
    try {
        c = resolver.query(self, new String[] { column }, null, null, null);
        if (c != null && c.moveToFirst() && !c.isNull(0)) {
            return c.getString(0);
        } else {
            return defaultValue;
        }
    } catch (Exception e) {
        return defaultValue;
    } finally {
        closeQuietly(c);
    }
}
 

@Deprecated
protected Object getObject(Cursor cursor, Class fieldType, int index) {
    if (null == cursor) {
        return null;
    }
    if (String.class == fieldType) {
        return cursor.getString(index);
    } else if (TypeUtil.isLongIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getLong(index);
    } else if (TypeUtil.isIntegerIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getInt(index);
    } else if (TypeUtil.isShortIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getShort(index);
    } else if (TypeUtil.isDoubleIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getDouble(index);
    } else if (TypeUtil.isFloatIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getFloat(index);
    } else if (TypeUtil.isBlobIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : cursor.getBlob(index);
    } else if (TypeUtil.isBooleanIncludePrimitive(fieldType)) {
        return cursor.isNull(index) ? null : (cursor.getInt(index) == 1);
    }
    return null;
}
 

public static OC_User lastUserActiveFromDB(DBSQL db)
{
    Cursor cursor = db.prepareRawQuery(String.format("SELECT U.userid AS userid FROM %s AS U LEFT JOIN %s AS S ON S.userid = U.userid ORDER BY S.startTime DESC LIMIT 1",
            DBSQL.TABLE_USERS,DBSQL.TABLE_SESSIONS), null);
    int userId = -1;
    int columnIndex = cursor.getColumnIndex("userid");
    if(cursor.moveToFirst() && !cursor.isNull(columnIndex))
    {
        userId = cursor.getInt(columnIndex);
    }
    cursor.close();
    OC_User user = null;

    if(userId > -1)
        user = OC_User.UserFromDBForID(db, userId);

    return user;

}
 

/**
 * @inheritdoc
 */
@Override
public Green_AccountBean readEntity(Cursor cursor, int offset) {
    Green_AccountBean entity = new Green_AccountBean( //
            cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // uid
            cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // user_name
            cursor.isNull(offset + 2) ? null : cursor.getString(offset + 2), // user_password
            cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3), // cookie
            cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4), // oauth_token
            cursor.isNull(offset + 5) ? null : cursor.getLong(offset + 5), // oauth_token_expires_time
            cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6), // access_token_hack
            cursor.isNull(offset + 7) ? null : cursor.getLong(offset + 7), // expires_time_hack
            cursor.isNull(offset + 8) ? null : cursor.getString(offset + 8), // g_sid
            cursor.isNull(offset + 9) ? null : cursor.getInt(offset + 9), // navigation_position
            cursor.isNull(offset + 10) ? null : cursor.getString(offset + 10) // user_info_json
    );
    return entity;
}
 

private @Nullable
File getAttachmentDataFile(@NonNull AttachmentId attachmentId,
                           @NonNull String dataType) {
    SQLiteDatabase database = databaseHelper.getReadableDatabase();
    Cursor cursor = null;

    try {
        cursor = database.query(TABLE_NAME, new String[]{dataType}, PART_ID_WHERE, attachmentId.toStrings(),
                null, null, null);

        if (cursor != null && cursor.moveToFirst()) {
            if (cursor.isNull(0)) {
                return null;
            }

            return new File(cursor.getString(0));
        } else {
            return null;
        }
    } finally {
        if (cursor != null)
            cursor.close();
    }

}
 

/**
 * {@inheritDoc}
 */
@Override
@NonNull
public BoxedTypesPrivateFieldsIgnoreNull 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"));
    }

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

    return object;
}
 

public Location getLocation(long id) {
    SQLiteDatabase db = this.getReadableDatabase();
    String query = "SELECT * FROM location";
    query += " WHERE ID = " + id;

    Cursor cursor = null;
    try {
        cursor = db.rawQuery(query, new String[0]);
        if (cursor.moveToNext()) {
            int colTime = cursor.getColumnIndex("time");
            int colLatitude = cursor.getColumnIndex("latitude");
            int colLongitude = cursor.getColumnIndex("longitude");
            int colAltitude = cursor.getColumnIndex("altitude");
            int colAccuracy = cursor.getColumnIndex("accuracy");
            int colName = cursor.getColumnIndex("name");
            int colDeleted = cursor.getColumnIndex("deleted");

            Location location = new Location(cursor.getString(colName)); // hack
            location.setTime(cursor.isNull(colDeleted) ? cursor.getLong(colTime) : Long.MAX_VALUE);
            location.setLatitude(cursor.getDouble(colLatitude));
            location.setLongitude(cursor.getDouble(colLongitude));
            if (!cursor.isNull(colAltitude))
                location.setAltitude(cursor.getDouble(colAltitude));
            if (!cursor.isNull(colAccuracy))
                location.setAccuracy(cursor.getFloat(colAccuracy));
            return location;
        } else
            return null;
    } finally {
        if (cursor != null)
            cursor.close();
    }
}
 

/** @inheritdoc */
@Override
public JokeCache readEntity(Cursor cursor, int offset) {
    JokeCache entity = new JokeCache( //
        cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id
        cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // result
        cursor.isNull(offset + 2) ? null : cursor.getInt(offset + 2), // page
        cursor.isNull(offset + 3) ? null : cursor.getLong(offset + 3) // time
    );
    return entity;
}
 

/** @inheritdoc */
@Override
public VideoCache readEntity(Cursor cursor, int offset) {
    VideoCache entity = new VideoCache( //
        cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id
        cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // result
        cursor.isNull(offset + 2) ? null : cursor.getInt(offset + 2), // page
        cursor.isNull(offset + 3) ? null : cursor.getLong(offset + 3) // time
    );
    return entity;
}
 

/**
 * @inheritdoc
 */
@Override
public Groups readEntity(Cursor cursor, int offset) {
    Groups entity = new Groups( //
            cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0), // jid
            cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // name
            cursor.isNull(offset + 2) ? null : cursor.getBlob(offset + 2) // participants
    );
    return entity;
}
 

/** @inheritdoc */
@Override
public MusicInfo readEntity(Cursor cursor, int offset) {
    MusicInfo entity = new MusicInfo( //
        cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // songId
        cursor.isNull(offset + 1) ? null : cursor.getLong(offset + 1), // albumId
        cursor.isNull(offset + 2) ? null : cursor.getLong(offset + 2), // artistId
        cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3), // title
        cursor.isNull(offset + 4) ? null : cursor.getString(offset + 4), // artist
        cursor.isNull(offset + 5) ? null : cursor.getInt(offset + 5), // duration
        cursor.isNull(offset + 6) ? null : cursor.getString(offset + 6), // path
        cursor.isNull(offset + 7) ? null : cursor.getShort(offset + 7) != 0 // favorite
    );
    return entity;
}
 

@Override
public LiveCategory readEntity(Cursor cursor, int offset) {
    LiveCategory entity = new LiveCategory( //
        cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id
        cursor.isNull(offset + 1) ? null : cursor.getString(offset + 1), // name
        cursor.getInt(offset + 2), // is_default
        cursor.isNull(offset + 3) ? null : cursor.getString(offset + 3), // slug
        cursor.getInt(offset + 4), // type
        cursor.getInt(offset + 5) // screen
    );
    return entity;
}
 

@Override
public JoinLettersWithAllophones readEntity(Cursor cursor, int offset) {
    JoinLettersWithAllophones entity = new JoinLettersWithAllophones( //
        cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0), // id
        cursor.getLong(offset + 1), // letterId
        cursor.getLong(offset + 2) // allophoneId
    );
    return entity;
}
 

@Override
public Long readKey(Cursor cursor, int offset) {
    return cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0);
}
 

@Override
public Long readKey(Cursor cursor, int offset) {
    return cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0);
}
 

/**
 * @inheritdoc
 */
@Override
public Long readKey(Cursor cursor, int offset) {
    return cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0);
}
 

@Override
public String readKey(Cursor cursor, int offset) {
    return cursor.isNull(offset + 0) ? null : cursor.getString(offset + 0);
}
 

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

@Override
public Long readKey(Cursor cursor, int offset) {
    return cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0);
}
 

/**
 * @param cursor un objeto Cursor.
 * @param columnName el nombre de la columna.
 * @return el valor de la columna. Si no existe la columna o el valor de la columna es
 *         {@code null} entonces {@code null}.
 */
static String getString(Cursor cursor, String columnName) {
    return containsColumn(cursor, columnName) && !cursor.isNull(cursor.getColumnIndex(columnName))
            ? cursor.getString(cursor.getColumnIndex(columnName))
            : null;
}