List of usage examples for com.mongodb.client MongoCollection find
FindIterable<TDocument> find();
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); }