package com.mongodb.education;
import com.mongodb.*;
import java.net.UnknownHostException;
public class App
{
public static void main( String[] args ) throws UnknownHostException {
MongoClient mongoClient = new MongoClient();
DB students = mongoClient.getDB("students");
DBCollection grades = students.getCollection("grades");
DBCursor cursor = grades.find(new BasicDBObject("type", "homework")).sort(new BasicDBObject("student_id", 1).append("score", -1));
DBObject previousDocument = null;
DBObject currentDocument = null;
while(cursor.hasNext()) {
currentDocument = cursor.next();
if(previousDocument != null && !previousDocument.get("student_id").equals(currentDocument.get("student_id"))) {
//changing student id -> previous document contains the lower grade
System.out.println("Found lowest grade: " + previousDocument);
grades.remove(previousDocument);
}
previousDocument = currentDocument;
}
System.out.println("Found lowest grade: " + currentDocument);
grades.remove(currentDocument);
}
}