Example usage for com.mongodb.client MongoCollection find

List of usage examples for com.mongodb.client MongoCollection find

Introduction

In this page you can find the example usage for com.mongodb.client MongoCollection find.

Prototype

FindIterable<TDocument> find();

Source Link

Document

Finds all documents in the collection.

Usage

From source file:dto.Dto.java

public String getLastStudentId() {
    Conexion c = new Conexion();
    MongoCollection<Document> col = c.getConnection("usuarios");

    Document doc = col.find().sort(Sorts.orderBy(Sorts.descending("_id"))).first();

    if (doc == null) {
        return "0";
    } else {/*  ww  w. ja  v  a  2 s . co  m*/
        return (doc.getString("_id"));
    }
}

From source file:dto.Dto.java

public String getLastActaId() {
    Conexion c = new Conexion();
    MongoCollection<Document> col = c.getConnection("actas");

    Document doc = col.find().sort(Sorts.orderBy(Sorts.descending("_id"))).first();

    if (doc == null) {
        return "0";
    } else {/*from   w  ww .j  av  a2  s.  c  om*/
        return (doc.getString("_id"));
    }
}

From source file:dto.Dto.java

public String getLastAsesoriaId() {
    Conexion c = new Conexion();
    MongoCollection<Document> col = c.getConnection("asesorias");

    Document doc = col.find().sort(Sorts.orderBy(Sorts.descending("_id"))).first();

    if (doc == null) {
        return "0";
    } else {/*from   w w  w  .  ja v a2 s  .co  m*/
        return (doc.getString("_id"));
    }
}

From source file:dto.Dto.java

public String getLastTeacherId() {
    Conexion c = new Conexion();
    MongoCollection<Document> col = c.getConnection("profesores");

    Document doc = col.find().sort(Sorts.orderBy(Sorts.descending("_id"))).first();

    if (doc == null) {
        return "0";
    } else {//from w w w .jav  a2  s. c o  m
        return (doc.getString("_id"));
    }
}

From source file:dto.Dto.java

public String getLastTesisId() {
    Conexion c = new Conexion();
    MongoCollection<Document> col = c.getConnection("tesis_alumno_asesor");

    Document doc = col.find().sort(Sorts.orderBy(Sorts.descending("_id"))).first();

    if (doc == null) {
        return "0";
    } else {/*from   w ww .jav a2  s. c o  m*/
        System.out.println(doc.getString("_id"));
        return (doc.getString("_id"));

    }
}

From source file:dto.Dto.java

public String listarTesis() {
    String cadena = "";
    MongoCollection<Document> col = c.getConnection("universo_tesis");
    MongoCursor<Document> cursor = col.find().sort(Sorts.orderBy(Sorts.descending("ao"))).iterator();
    Document doc;//from  w  w w . j av  a 2  s  .c  om
    try {
        while (cursor.hasNext()) {
            doc = cursor.next();
            cadena += "<tr>" + "<td width='20%'>" + doc.getString("titulo").toUpperCase().trim() + "</td>"
                    + "<td width='20%'>" + doc.getString("ao") + "</td>" + "<td width='20%'>"
                    + doc.getString("estado").toUpperCase().trim() + "</td>" + "</tr>";
        }
    } catch (Exception e) {
        System.out.println("listarTesis universo: " + e);
    } finally {
        cursor.close();
    }
    return cadena;
}

From source file:dto.Dto.java

public String listarAsesores() {
    String cadena = "";
    MongoCollection<Document> col = c.getConnection("profesores");
    MongoCursor<Document> cursor = col.find().iterator();
    Document doc;//from w ww . ja  v a 2s .c om
    try {
        while (cursor.hasNext()) {
            doc = cursor.next();
            cadena += "<option value='" + doc.getString("_id") + "'>" + doc.getString("nombre") + "</option>";
        }
    } catch (Exception e) {
        System.out.println("listarTesisAsesores: " + e);
    } finally {
        cursor.close();
    }
    return cadena;
}

From source file:dummydata.DummyData.java

private static Map GenerateNodeMacAddress() {
    MongoClient mongoClient = new MongoClient("129.217.152.20", 27017);
    MongoDatabase db = mongoClient.getDatabase("autophy-dev");
    MongoCollection<Document> collection = db.getCollection("macAddrs");
    FindIterable<Document> iterable = collection.find();
    Document document = iterable.first();
    document.remove("_id");
    Map<String, String> documentMap = (Map) document;
    return documentMap;
}

From source file:examples.tour.QuickTour.java

License:Apache License

/**
 * Run this main method to see the output of this quick example.
 *
 * @param args takes an optional single argument for the connection string
 *//*w w w  .j  av a 2s . c o m*/
public static void main(final String[] args) {
    MongoClient mongoClient;

    if (args.length == 0) {
        // connect to the local database server
        mongoClient = new MongoClient();
    } else {
        mongoClient = new MongoClient(new MongoClientURI(args[0]));
    }

    // get handle to "mydb" database
    MongoDatabase database = mongoClient.getDatabase("mydb");

    // get a handle to the "test" collection
    MongoCollection<Document> collection = database.getCollection("test");

    // drop all the data in it
    collection.drop();

    // make a document and insert it
    Document doc = new Document("name", "MongoDB").append("type", "database").append("count", 1).append("info",
            new Document("x", 203).append("y", 102));

    collection.insertOne(doc);

    // get it (since it's the only one in there since we dropped the rest earlier on)
    Document myDoc = collection.find().first();
    System.out.println(myDoc.toJson());

    // now, lets add lots of little documents to the collection so we can explore queries and cursors
    List<Document> documents = new ArrayList<Document>();
    for (int i = 0; i < 100; i++) {
        documents.add(new Document("i", i));
    }
    collection.insertMany(documents);
    System.out.println(
            "total # of documents after inserting 100 small ones (should be 101) " + collection.count());

    // find first
    myDoc = collection.find().first();
    System.out.println(myDoc.toJson());

    // lets get all the documents in the collection and print them out
    MongoCursor<Document> cursor = collection.find().iterator();
    try {
        while (cursor.hasNext()) {
            System.out.println(cursor.next().toJson());
        }
    } finally {
        cursor.close();
    }

    for (Document cur : collection.find()) {
        System.out.println(cur.toJson());
    }

    // now use a query to get 1 document out
    myDoc = collection.find(eq("i", 71)).first();
    System.out.println(myDoc.toJson());

    // now use a range query to get a larger subset
    cursor = collection.find(gt("i", 50)).iterator();

    try {
        while (cursor.hasNext()) {
            System.out.println(cursor.next().toJson());
        }
    } finally {
        cursor.close();
    }

    // range query with multiple constraints
    cursor = collection.find(and(gt("i", 50), lte("i", 100))).iterator();

    try {
        while (cursor.hasNext()) {
            System.out.println(cursor.next().toJson());
        }
    } finally {
        cursor.close();
    }

    // Query Filters
    myDoc = collection.find(eq("i", 71)).first();
    System.out.println(myDoc.toJson());

    // now use a range query to get a larger subset
    Block<Document> printBlock = new Block<Document>() {

        public void apply(final Document document) {
            System.out.println(document.toJson());
        }
    };
    collection.find(gt("i", 50)).forEach(printBlock);

    // filter where; 50 < i <= 100
    collection.find(and(gt("i", 50), lte("i", 100))).forEach(printBlock);

    // Sorting
    myDoc = collection.find(exists("i")).sort(descending("i")).first();
    System.out.println(myDoc.toJson());

    // Projection
    myDoc = collection.find().projection(excludeId()).first();
    System.out.println(myDoc.toJson());

    // Aggregation
    collection
            .aggregate(
                    asList(match(gt("i", 0)), project(Document.parse("{ITimes10: {$multiply: ['$i', 10]}}"))))
            .forEach(printBlock);

    myDoc = collection.aggregate(singletonList(group(null, sum("total", "$i")))).first();
    System.out.println(myDoc.toJson());

    // Update One
    collection.updateOne(eq("i", 10), set("i", 110));

    // Update Many
    UpdateResult updateResult = collection.updateMany(lt("i", 100), inc("i", 100));
    System.out.println(updateResult.getModifiedCount());

    // Delete One
    collection.deleteOne(eq("i", 110));

    // Delete Many
    DeleteResult deleteResult = collection.deleteMany(gte("i", 100));
    System.out.println(deleteResult.getDeletedCount());

    collection.drop();

    // ordered bulk writes
    List<WriteModel<Document>> writes = new ArrayList<WriteModel<Document>>();
    writes.add(new InsertOneModel<Document>(new Document("_id", 4)));
    writes.add(new InsertOneModel<Document>(new Document("_id", 5)));
    writes.add(new InsertOneModel<Document>(new Document("_id", 6)));
    writes.add(
            new UpdateOneModel<Document>(new Document("_id", 1), new Document("$set", new Document("x", 2))));
    writes.add(new DeleteOneModel<Document>(new Document("_id", 2)));
    writes.add(new ReplaceOneModel<Document>(new Document("_id", 3), new Document("_id", 3).append("x", 4)));

    collection.bulkWrite(writes);

    collection.drop();

    collection.bulkWrite(writes, new BulkWriteOptions().ordered(false));
    //collection.find().forEach(printBlock);

    // Clean up
    database.drop();

    // release resources
    mongoClient.close();
}

From source file:flipkart.mongo.replicator.node.ReplicationTask.java

License:Apache License

@Override
public void run() {
    String shardId = rsConfig.shardName;
    Node masterNode = rsConfig.getMasterNode().get();
    MongoClient client = MongoConnector.getMongoClient(Lists.newArrayList(masterNode));

    MongoDatabase database = client.getDatabase("local");
    lastCp = taskContext.checkPointHandler.getCheckPoint(shardId);

    logger.info(String.format("######## START REPLICATOR FOR MongoURI: %s. LastCheckpoint: %s #######",
            client.getAddress(), lastCp));
    MongoCollection<Document> collection = database.getCollection("oplog.rs");
    FindIterable<Document> iterable;
    MongoCursor<Document> cursor;
    do {//from w ww.j  ava  2 s . c  om
        if (lastCp == null) {
            iterable = collection.find();
        } else {
            iterable = collection.find(new Document("ts", new Document("$gt", lastCp)));
        }
        cursor = iterable.sort(new Document("$natural", 1)).noCursorTimeout(true)
                .cursorType(CursorType.TailableAwait).batchSize(3000).iterator();
        try {
            executeCursor(cursor);
            Thread.sleep(WAIT_FOR_NEXT_ITERATION);
        } catch (MongoCursorNotFoundException e) {
            logger.info("Cursor has been closed. About to open a new cursor. ID: "
                    + cursor.getServerCursor().getId());
        } catch (Exception e) {
            logger.error("Exception while replicating", e);
            throw new RuntimeException(e);
        } finally {
            cursor.close();
        }
    } while (true);
}