Example usage for com.mongodb BasicDBObject append

List of usage examples for com.mongodb BasicDBObject append

Introduction

In this page you can find the example usage for com.mongodb BasicDBObject append.

Prototype

@Override
public BasicDBObject append(final String key, final Object val) 

Source Link

Document

Add a key/value pair to this object

Usage

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();
    }
}