how to retrieve specific row data from parse database for android

Question

I have a Parse Dashboard account, In which I have a class called PointsCollected. For that class i have fields as device,pointsObtained.

My Question is I need to retrieve the points based on the device. I am getting the device id from telephone manager. But how to make a query to retrieve the points based on device id, And if no rows found it show add a row with zero points in the database.

Answer 1

You can do this if you put the user in the same table.

ParseQuery<ParseObject> query = ParseQuery.getQuery("PointsCollected");
    query.whereEqualTo("currentUser", currentUset.getObjectId());
    // this will find the user.
    // then find the first instance
    query.findFirstInBackground(new FindCallback<ParseObject>() {
        public void done(List<ParseObject> object, ParseException e) {
            if (e == null) {
                textView.setText(object.getString("device"));
            } else {
                Log.d(TAG, "Error: " + e.getMessage());
            }
        }
    });

This is the new idea.... This should work.

    // At the end we want to get the points.
    final int points; 

    //First, lets get the ID of the device and store that into a veriable.
    TelephonyManager telephonyManager = (TelephonyManager)getSystemService(Context.TELEPHONY_SERVICE);
    final String deviceId = telephonyManager.getDeviceId().toString();

    //Then lets query the PointsCollected database.
    ParseQuery<ParseObject> query = ParseQuery.getQuery("PointsCollected");
    // Then we want to see where the DeviceID (from the variable) matches the device from the database.
    // "device" is the row in the database.
    // deviceID is the varible that is storing that users device ID.
    query.whereEqualTo("device", deviceId);
    //Then we get the first instance...
    query.getFirstInBackground(new GetCallback<ParseObject>() {
        public void done(ParseObject object, ParseException e) {
             // you want to do a check on the ParseException here as well. 
            if (object == null) {
                Log.d("nothing found", "let's go ahead and create a new object.");
                //ADD THE OBJECT AS A NEW OBJECT!!!!
            } else {

                points = object.getInt("pointsObtained");
                Log.d("points found", points + "");
            }
        }
    });