List of usage examples for com.mongodb BasicDBObject append
@Override public BasicDBObject append(final String key, final Object val)
From source file:com.emuneee.camerasyncmanager.util.DatabaseUtil.java
License:Apache License
/** * Converts camera to BasicDBObject/*w ww. j a v a2s . c om*/ * @param camera * @return */ public BasicDBObject cameraToDBObject(Camera camera) { BasicDBObject dbObj = new BasicDBObject(); dbObj.append("_id", camera.getId()); dbObj.append("title", camera.getTitle()); dbObj.append("latitude", camera.getLatitude()); dbObj.append("longitude", camera.getLongitude()); dbObj.append("city", camera.getCity()); dbObj.append("area", camera.getArea()); dbObj.append("state", camera.getState()); dbObj.append("zipcode", camera.getZipCode()); dbObj.append("country", camera.getCountry()); dbObj.append("url", camera.getUrl()); dbObj.append("created", camera.getCreated()); dbObj.append("updated", camera.getUpdated()); return dbObj; }
From source file:com.entrib.mongoslate.visitor.stmt.translator.select.SelectStatementTranslator.java
License:Apache License
/** * Distinct keyword if used gets ignored. * * For the select_clause find all the column names where aggr function is used * /* w w w . j ava 2 s .c o m*/ * if alias clause is used * * @param selectStatement * @return */ private Aggregation buildMongoAggregation(SelectStatement selectStatement) { Aggregation aggregation = new Aggregation(); BasicDBObject aggregate = new BasicDBObject(); aggregate.append(AGGREGATE, selectStatement.getCollection().getValueAsString()); BasicDBList pipeline = new BasicDBList(); aggregate.append(PIPELINE, pipeline); Expression whereClause = selectStatement.getLogicalExpression(); if (whereClause != null) { BasicDBObject query = (BasicDBObject) selectStatement.getLogicalExpression() .accept(expressionTranslatorVisitor); pipeline.add(new BasicDBObject("$match", query)); } // if group by clause is used, go through tag list expressions // through each tag and prepare the $group pipeline object LimitExpression limitExpression = selectStatement.getLimitExpression(); if (limitExpression != null) { BasicDBObject skipAndLimit = (BasicDBObject) limitExpression.accept(expressionTranslatorVisitor); pipeline.add(new BasicDBObject("$skip", ((IntValue) skipAndLimit.get("skip")).getValueAsObject())); pipeline.add(new BasicDBObject("$limit", ((IntValue) skipAndLimit.get("skip")).getValueAsObject())); } return aggregation; }
From source file:com.example.rest.DbConnection.java
public void insertValueDb(User user) throws Exception { BasicDBObject document = new BasicDBObject(); BasicDBObject searchQuery = new BasicDBObject(); document.append("DriverLicense", user.getDriverLicense()); document.append("FirstName", user.getFirstName()); document.append("LastName", user.getLastName()); document.append("DOB", user.getDob()); document.append("Address", user.getAddress()); //System.out.println(document); searchQuery.append("DriverLicense", user.getDriverLicense()); DBCursor cursor = table.find(searchQuery); if (!cursor.hasNext()) { table.insert(document);//from w w w . j av a2 s . c o m } else throw new Exception("Details already exist"); }
From source file:com.example.rest.DbConnection.java
public User getData(int number) { BasicDBObject searchQuery = new BasicDBObject(); User retUser = null;//from w w w . j ava 2 s .c om searchQuery.append("DriverLicense", number); DBCursor cursor = table.find(searchQuery); while (cursor.hasNext()) { DBObject obj = cursor.next(); retUser = new User((int) obj.get("DriverLicense")); retUser.setFirstName((String) obj.get("FirstName")); retUser.setLastName((String) obj.get("LastName")); retUser.setDob((String) obj.get("DOB")); retUser.setAddress((String) obj.get("Address")); //retUser = (User) cursor.next(); } return retUser; }
From source file:com.example.rest.DbConnection.java
public void removeData(int number) { BasicDBObject removeQuery = new BasicDBObject(); removeQuery.append("DriverLicense", number); DBCursor cursor = table.find(removeQuery); if (cursor.hasNext()) { table.remove(removeQuery);/* www. j a v a 2 s . c om*/ } }
From source file:com.example.rest.DbConnection.java
public void addOrder(OrderData order) { BasicDBObject document = new BasicDBObject(); document.append("DriverLicense", order.getDriverLicense()); document.append("OrderDetails", order.getOrder()); orderTable.insert(document);// www .ja va 2 s. c om }
From source file:com.example.rest.DbConnection.java
public String getOrder(int number) { BasicDBObject document = new BasicDBObject(); String order = null;/*from w w w .j ava2s. c o m*/ document.append("DriverLicense", number); DBCursor cursor = orderTable.find(document); if (cursor.hasNext()) { DBObject obj = cursor.next(); order = (String) obj.get("OrderDetails"); } return order; }
From source file:com.example.rest.DbConnection.java
public void deleteOrder(int number) { BasicDBObject document = new BasicDBObject(); document.append("DriverLicense", number); DBCursor cursor = orderTable.find(document); if (cursor.hasNext()) { orderTable.remove(document);/*from w w w .j a va 2 s . c o m*/ } }
From source file:com.ff.reportgenerator.mongodb.DynamicDatabase.java
public String query(Hashtable conditions) { List<DBObject> list = null; DB myDB = getDB(DB_NAME);// w w w . jav a2 s. c o m DBCollection coll = myDB.getCollection("projects"); BasicDBObject cond = new BasicDBObject(); Set<String> keySet = conditions.keySet(); Iterator<String> it = keySet.iterator(); while (it.hasNext()) { String key = it.next(); String value = (String) conditions.get(key); if (value == null || value.equals("All")) { continue; } Pattern pattern = null; if (key.equals("Project_Phase")) { if (value.equals("Ongoing")) { BasicDBList dlist = new BasicDBList(); dlist.add(new BasicDBObject(key, new BasicDBObject("$ne", "Completed"))); dlist.add(new BasicDBObject(key, new BasicDBObject("$ne", "Eng-Complete"))); dlist.add(new BasicDBObject(key, new BasicDBObject("$ne", "Canceled"))); dlist.add(new BasicDBObject(key, new BasicDBObject("$ne", "Publication"))); cond.append("$and", dlist); } else if (value.equals("Complete")) { ArrayList<String> slist = new ArrayList(); slist.add("Completed"); slist.add("Eng-Complete"); slist.add("Publication"); cond.append(key, new BasicDBObject("$in", slist)); //Limited to FY15 projects //pattern = Pattern.compile("^.*15-\\[.*$", Pattern.CASE_INSENSITIVE); //Limited to FY16 projects pattern = Pattern.compile("^.*16-.*$", Pattern.CASE_INSENSITIVE); cond.append("ISVe_Goal", pattern); } } else if (key.equals("Keywords") && value.equals("Non-OPI")) { // not like 'OPI' pattern = Pattern.compile("^((?!OPI).)*$", Pattern.CASE_INSENSITIVE); cond.append(key, pattern); } else { // like '*OPI*' pattern = Pattern.compile("^.*" + value + ".*$", Pattern.CASE_INSENSITIVE); cond.append(key, pattern); } System.out.println(key + ":" + value); } DBCursor ret = coll.find(cond); BasicDBObject sort = new BasicDBObject("PROJECT_ID", 1); ret.sort(sort); try { list = ret.toArray(); } finally { ret.close(); } //System.out.println(list.toString()); return list.toString(); }
From source file:com.fileoperations.CopyClass.java
public Boolean forSingleFile() { try {/*from www .ja v a 2 s. com*/ if (name.contains(".")) { BasicDBObject query = new BasicDBObject(); query.put("_id", parentPath + pathMerger + name); DBCursor cursor = collection.find(query); if (cursor.hasNext()) { BasicDBObject checknewquery = new BasicDBObject(); checknewquery.put("_id", newPath + pathMerger + name); DBCursor tempCursor = collection.find(checknewquery); if (tempCursor.hasNext()) { return false; } DBObject copyFile = cursor.next(); GridFS fileDB = new GridFS(mymongo.getDB(), userCollectionName); InputStream data = fileDB.findOne(query).getInputStream(); BasicDBObject document = new BasicDBObject(); document.append("_id", newPath + pathMerger + name); document.append("folder", "0"); document.append("parent", newPath); document.append("name", name); document.append("type", copyFile.get("type").toString()); collection.insert(document); GridFSInputFile inputFile = fileDB.createFile(data); inputFile.setId(newPath + pathMerger + name); inputFile.put("path", newPath); inputFile.setFilename(name); inputFile.save(); return true; } else { return false; } } else { return false; } } finally { mymongo.closeConnection(); } }