List of usage examples for com.mongodb DBCollection remove
public WriteResult remove(final DBObject query)
From source file:mongodb.JavaDocDelete.java
public static void removeNewDocs(DBCollection collection) { BasicDBObject query = new BasicDBObject("category", "New"); WriteResult result = collection.remove(query); System.out.println("Delete Result: \n" + result.toString()); }
From source file:mongodb.JavaDocUpsert.java
public static void cleanupWord(DBCollection collection) { BasicDBObject query = new BasicDBObject("word", "righty"); collection.remove(query); }
From source file:mongoDB.MongoDbClientAllImagesAsByteArrays.java
License:Open Source License
@Override public int delCommentOnResource(int resourceCreatorID, int resourceID, int manipulationID) { int retVal = 0; if (resourceCreatorID < 0 || resourceID < 0 || manipulationID < 0) return -1; com.mongodb.DB db = null;//from w ww .j av a 2s. c o m try { // get the appropriate database db = mongo.getDB(database); db.requestStart(); if (!manipulationArray) { // consider a separate manipoulations // table DBCollection collection = db.getCollection("manipulation"); DBObject q = new BasicDBObject().append("mid", Integer.toString(manipulationID)).append("rid", Integer.toString(resourceID)); collection.remove(q); } else { DBCollection collection = db.getCollection("resources"); DBObject q = new BasicDBObject().append("_id", resourceID); BasicDBObject updateCommand = new BasicDBObject("Manipulations", new BasicDBObject("mid", Integer.toString(manipulationID))); WriteResult res = collection.update(q, new BasicDBObject("$pull", updateCommand), false, false, writeConcern); if (res.getN() != 1) return -1; } } catch (Exception e) { System.out.println(e.toString()); retVal = -1; } finally { if (db != null) { db.requestDone(); } } return retVal; }
From source file:mongoDB.MongoDbClientAllImagesAsByteArrays.java
License:Open Source License
@Override public void reconstructSchema() { com.mongodb.DB db = null;/*from ww w . j av a2 s. co m*/ try { db = mongo.getDB(database); db.requestStart(); // getting the number of users DBCollection collection = db.getCollection("users"); int numUsers = (int) collection.getCount(); // for every user set their conf Friends and pend Friends to null for (int i = 0; i < numUsers; i++) { DBObject r = new BasicDBObject().append("_id", i); DBObject queryResult = collection.findOne(r); BasicDBObject updateCommand = new BasicDBObject(); updateCommand.put("$set", new BasicDBObject("ConfFriends", new ArrayList<Integer>())); WriteResult res = collection.update(r, updateCommand, false, false, writeConcern); updateCommand = new BasicDBObject(); updateCommand.put("$set", new BasicDBObject("PendFriends", new ArrayList<Integer>())); res = collection.update(r, updateCommand, false, false, writeConcern); } if (manipulationArray) { collection = db.getCollection("resources"); int numResources = (int) collection.getCount(); // for every user set their conf Friends and pend Friends to null for (int i = 0; i < numUsers; i++) { DBObject r = new BasicDBObject().append("_id", i); DBObject queryResult = collection.findOne(r); BasicDBObject updateCommand = new BasicDBObject(); updateCommand.put("$set", new BasicDBObject("Manipulations", new ArrayList<Integer>())); WriteResult res = collection.update(r, updateCommand, false, false, writeConcern); } } else { collection = db.getCollection("manipulation"); //TODO: test this if (Boolean.parseBoolean( props.getProperty(MONGODB_SHARDING_PROPERTY, MONGODB_SHARDING_PROPERTY_DEFAULT)) == true) collection.drop(); //this doesnt work with shards else { DBCursor DBCur = collection.find(); while (DBCur.hasNext()) collection.remove(DBCur.next()); } } db.requestDone(); } catch (Exception ex) { db.requestDone(); ex.printStackTrace(); } }
From source file:mongodb.performance.MongoDBPerformance.java
/** * @param args the command line arguments *///from w w w . ja va 2 s.c o m public static void main(String[] args) throws UnknownHostException, FileNotFoundException, IOException { if (args.length == 0) { System.out.println("Parmetro no informado!"); System.exit(-1); } System.out.println("Parmetro: " + args[0]); MongoClient mongoClient = new MongoClient(); //MongoClient mongoClient = new MongoClient( "54.172.218.64" , 27017 ); DB db = mongoClient.getDB("myDatabase"); DBCollection collection = db.getCollection("ads"); collection.drop(); BulkWriteOperation builder = collection.initializeUnorderedBulkOperation(); FileInputStream fileInputStream = new FileInputStream(".\\resources\\MongoDB" + args[0] + ".txt"); BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(fileInputStream)); // Insert // Time start long start = System.currentTimeMillis(); String line; while ((line = bufferedReader.readLine()) != null) { DBObject bson = (DBObject) JSON.parse(line); builder.insert(bson); } bufferedReader.close(); builder.execute(); //Time end long elapsed = System.currentTimeMillis() - start; System.out.println("[insert] Time elapsed: " + elapsed + " ms"); // Update // Time start start = System.currentTimeMillis(); collection.updateMulti(new BasicDBObject(), new BasicDBObject("$set", new BasicDBObject().append("ano", 2006))); // Time end elapsed = System.currentTimeMillis() - start; System.out.println("[update] Time elapsed: " + elapsed + " ms"); // Select // Time start start = System.currentTimeMillis(); BasicDBObject keys = new BasicDBObject(); keys.put("_id", 1); keys.put("modeloCarro.marca", 1); keys.put("modeloCarro.nome", 1); keys.put("uf", 1); keys.put("placa_carro", 1); keys.put("qtd_portas", 1); keys.put("cambio", 1); keys.put("combustivel", 1); keys.put("cor", 1); keys.put("km", 1); keys.put("valor", 1); keys.put("detalhe", 1); BasicDBObject sort = new BasicDBObject("_id", 1); DBCursor cursor = collection.find(new BasicDBObject(), keys).sort(sort); while (cursor.hasNext()) { cursor.next(); } // Time end elapsed = System.currentTimeMillis() - start; System.out.println("[select] Time elapsed: " + elapsed + " ms"); // Delete // Time start start = System.currentTimeMillis(); collection.remove(new BasicDBObject()); // Time end elapsed = System.currentTimeMillis() - start; System.out.println("[delete] Time elapsed: " + elapsed + " ms"); }
From source file:mongodb.View.java
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: String val = jTable1.getModel().getValueAt(jTable1.getSelectedRow(), 0).toString(); try {/*from w w w .ja v a 2s .c o m*/ DB userDB = DBManager.getDatabase(); DBCollection col = userDB.getCollection("user"); BasicDBObject query = new BasicDBObject("_id", new BasicDBObject("$eq", Integer.parseInt(val))); col.remove(query); // col.D(query, updateObj, false, true); JOptionPane.showMessageDialog(rootPane, "User deleted SucessFully...!"); this.dispose(); new View().setVisible(true); } catch (UnknownHostException ex) { Logger.getLogger(View.class.getName()).log(Level.SEVERE, null, ex); } }
From source file:mongoHandler.Handler.java
public boolean eliminarDocumento(BasicDBObject documentoAEliminar, String nombreColeccion) { try {/*from w w w. j av a 2 s .c om*/ DBCollection coleccion = dataBase.getCollection(nombreColeccion); coleccion.remove(documentoAEliminar); System.out.println("DOCUMENTO ELIMINADO"); return true; } catch (Exception e) { System.out.println("NO SE PUDO ELIMINAR EL DOCUMENTO : " + e.getMessage()); return false; } }
From source file:mx.edu.cide.justiciacotidiana.v1.mongo.MongoInterface.java
License:Open Source License
/** * Elimina un elemento de la coleccin.//from w w w . j a v a 2 s. co m * @param collectionName Nombre de la coleccin donde se eliminar el elemento. * @param item Elemento a eliminar. * @return true si la eliminacin fue exitosa. false en otro caso. */ public boolean deleteItem(String collectionName, BasicDBObject item) { DBCollection tCol = mongoDB.getCollection(collectionName); try { tCol.remove(item); } catch (MongoException ex) { return false; } return true; }
From source file:mypackage.ManupulateMongo.java
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ String respective = request.getParameter("respective"); String db = request.getParameter("dbname"); String coll = request.getParameter("collname"); String sb = respective;/*from www. j a v a 2s .co m*/ int index = sb.indexOf(";"); int length = respective.length(); String key = sb.substring(index + 1, length); HttpSession session = request.getSession(false); MongoClient mongoClient = new MongoClient("localhost", 27017); if (key.equals("db")) { String dbname = respective.substring(0, index); String coll_personal = session.getAttribute("uname") + "DB"; DB mongodb = mongoClient.getDB(dbname); DB mongodb_personal = mongoClient.getDB("mydb"); mongodb.dropDatabase(); DBCollection dBCollection = mongodb_personal.getCollection(coll_personal); BasicDBObject query = new BasicDBObject(); query.put("kapil", dbname); dBCollection.remove(query); out.print("true"); } if (key.equals("coll")) { String collname = respective.substring(0, index); DB mongodb = mongoClient.getDB(db); DBCollection dBCollection = mongodb.getCollection(collname); dBCollection.drop(); out.print("true"); } if (key.equals("doc")) { String docname = respective.substring(0, index); DB mongodb = mongoClient.getDB(db); DBCollection dBCollection = mongodb.getCollection(coll); BasicDBObject query = new BasicDBObject(); query.put("name", docname); dBCollection.remove(query); out.print("true"); } } }
From source file:net.autosauler.ballance.server.model.AbstractStructuredData.java
License:Apache License
/** * Restore./*from www . j a v a 2 s .c o m*/ * * @param dump * the dump */ public void restore(Element dump) { DB db = Database.get(getDomain()); if (db != null) { DBCollection coll = db.getCollection(getTableName()); Log.trace(getTableName()); NodeList recordsets = dump.getElementsByTagName("records"); for (int i = 0; i < recordsets.getLength(); i++) { Element recordset = (Element) recordsets.item(i); if (recordset.getParentNode() == dump) { NodeList records = recordset.getElementsByTagName("record"); if (records.getLength() > 0) { BasicDBObject q = new BasicDBObject(); q.put("domain", getDomain()); Database.retain(); coll.remove(q); for (int j = 0; j < records.getLength(); j++) { Log.trace("record"); BasicDBObject doc = new BasicDBObject(); Element record = (Element) records.item(j); NodeList fields = record.getElementsByTagName("field"); for (int k = 0; k < fields.getLength(); k++) { Element field = (Element) fields.item(k); String name = field.getAttribute("name"); if (name.equals("domain")) { doc.put("domain", getDomain()); } else { int type = struct.getType(name); String sval = field.getAttribute("value"); Log.error("field name=" + name + " value=" + sval); doc.put(name, DataTypes.fromString(type, sval)); } } Log.trace("insert"); coll.insert(doc); } } } } Database.release(); onRestore(dump); } }