Example usage for com.mongodb DBCollection count

Introduction

In this page you can find the example usage for com.mongodb DBCollection count.

Prototype

public long count(@Nullable final DBObject query) 

Source Link

Document

Same as #getCount(DBObject)

Usage

From source file:applango.common.services.DB.mongo.mongoDB.java

public static int countFailureLogins(Applango applango, DBCollection collection) {
    logger.info("Count how many failure logins for userId : " + applango.getUsername());
    String jsonCustomer = " {$and : [{'userId' : '" + applango.getUsername() + "'} , {'status':'failure'} ] }";
    DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
    return (int) collection.count(dbObjectRecordQuery);
}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static int countSuccessfulLogins(Applango applango, DBCollection collection) {
    logger.info("Count how many successful logins for userId : " + applango.getUsername());
    String jsonCustomer = " {$and : [{'userId' : '" + applango.getUsername() + "'} , {'status':'success'} ] }";
    DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
    return (int) collection.count(dbObjectRecordQuery);
}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static int loginsThisMonth(Applango applango, DBCollection collection) {
    //        logger.info("Count how many successful logins for userId : " + applango.getUsername());
    String jsonCustomer = " {$or : [{'customerId' : 'fff'}, {'loginTime' : {$gte : '(\"2014-01-01 08:15:04.000Z\")'}} ] }";
    DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
    return (int) collection.count(dbObjectRecordQuery);
}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static DBObject removeRecordsFromDB(Applango applango, DBCollection coll) {
    logger.info("Remove all records with customerId : " + applango.getUsername());
    String jsonCustomer = "{'customerId' : '" + applango.getCustomerForoAuth() + "'}";
    DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
    if (!(coll.count(dbObjectRecordQuery) == 0)) {
        coll.remove(dbObjectRecordQuery, WriteConcern.ACKNOWLEDGED);

    }//from w  ww.j av  a 2  s.  c o m
    return dbObjectRecordQuery;
}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static String getSpecialToken(Applango applango, DBCollection coll) {
    logger.info("Get the email token of : " + applango.getUsername());
    String token;/*from  www.j a  v  a  2  s  .co  m*/
    int maxWait = 10;
    try {
        String jsonCustomer = "{'userId' : '" + applango.getUsername() + "'}";
        DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
        while ((coll.count(dbObjectRecordQuery) == 0) && maxWait > 0) {
            sleep(1000);
            maxWait--;
        }
        token = coll.find(dbObjectRecordQuery).next().get("specialToken").toString();
    } catch (Exception ex) {
        token = null;
        logger.error(ex.getMessage());
    }
    return token;

}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static int getNumberOfUsersWithoutEndDate(DBCollection appInfoConnection, Applango applango) {
    String jsonCustomerWithoutEndDate = "{$and : [{'customerId' : '" + applango.getUserForoAuth()
            + "'}, {endDate : null}, {beginDate : {$ne:null} }] }";
    DBObject query = (DBObject) JSON.parse(jsonCustomerWithoutEndDate);
    return (int) appInfoConnection.count(query);

}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static int getNumberOfLoginUsersInLastWeek(DBCollection appInfoConnection, Applango applango) {
    String loginOverTheLastWeek = "( { distinct :\"loginInfo\"" + ",key: \"externalId\""
            + ", query : { $and: [ {loginTime: {gte: new Date(ISODate().getTime()-1000*60*60*24*7)}}, {customerId : \"automationCustomer\""
            + "}] } })";
    DBObject query = (DBObject) JSON.parse(loginOverTheLastWeek);
    return (int) appInfoConnection.count(query);

}

---

From source file:applango.common.services.DB.mongo.mongoDB.java

public static String getActivityWeight(DBCollection coll, String weightName) {
    String activityWeight;/*from   w  ww  . java 2 s . c  o  m*/
    int maxWait = 10;
    try {
        String jsonCustomer = "{$and : [{'weightName' : '" + weightName
                + "'}, {'customerId': 'automationCustomer'} ]}";
        DBObject dbObjectRecordQuery = (DBObject) JSON.parse(jsonCustomer);
        while ((coll.count(dbObjectRecordQuery) == 0) && maxWait > 0) {
            sleep(1000);
            maxWait--;
        }
        activityWeight = coll.find(dbObjectRecordQuery).next().get("activityWeight").toString();
    } catch (Exception ex) {
        activityWeight = null;
        logger.error(ex.getMessage());
    }
    return activityWeight;
}

---

From source file:com.ebay.cloud.cms.dal.persistence.MongoExecutor.java

License:Apache License

public static long count(PersistenceContext context, MetaClass metadata, DBObject queryObject) {
    long start = System.currentTimeMillis();
    long countResult = 0;
    String msg = "success";
    DBCollection dbCollection = context.getDBCollection(metadata);
    try {/* w  w w .  j a  v  a 2 s  . c  o  m*/
        countResult = dbCollection.count(queryObject);
    } catch (Throwable t) {
        msg = t.getMessage();
        handleMongoException(t);
    } finally {
        logMongoAction(context, "count", start, dbCollection, queryObject, null, null, null, msg);
    }
    return countResult;
}

---

From source file:com.edgytech.umongo.RouterPanel.java

License:Apache License

public void regenConfigDB(ButtonBase button) throws UnknownHostException {
    MongoClient cmongo = getRouterNode().getMongoClient();
    String servers = getStringFieldValue(Item.regenServers);
    final String db = getStringFieldValue(Item.regenDB);
    final String col = getStringFieldValue(Item.regenCollection);
    final String ns = db + "." + col;
    final DBObject shardKey = ((DocBuilderField) getBoundUnit(Item.regenShardKey)).getDBObject();
    final boolean unique = getBooleanFieldValue(Item.regenKeyUnique);
    final BasicDBObject result = new BasicDBObject();
    result.put("ns", ns);
    result.put("shardKey", shardKey);
    result.put("unique", unique);

    // create direct mongo for each replica set
    String[] serverList = servers.split("\n");
    List<ServerAddress> list = new ArrayList<ServerAddress>();
    String txt = "";
    String primaryShard = null;//from   w w w .  j a va2 s. com
    final BasicDBObject shardList = new BasicDBObject();
    HashMap<MongoClient, String> mongoToShard = new HashMap<MongoClient, String>();
    sLoop: for (String server : serverList) {
        server = server.trim();
        String[] tokens = server.split("/");
        if (tokens.length != 2) {
            new InfoDialog(null, "Error", null, "Server format must be like 'hostname:port/shard', one by line")
                    .show();
            return;
        }
        server = tokens[0];
        String shard = tokens[1];
        if (primaryShard == null) {
            primaryShard = shard;
        }
        ServerAddress addr = new ServerAddress(server);

        // filter out if replset already exists
        for (MongoClient replset : mongoToShard.keySet()) {
            if (replset.getServerAddressList().contains(addr)) {
                continue sLoop;
            }
        }

        list.clear();
        list.add(addr);
        MongoClient mongo = new MongoClient(list);
        //            UMongo.instance.addMongoClient(mongo, null);
        // make request to force server detection
        mongo.getDatabaseNames();
        mongoToShard.put(mongo, shard);

        String desc = null;
        if (!mongo.getDatabaseNames().contains(db) || !mongo.getDB(db).getCollectionNames().contains(col)) {
            desc = "Collection not present!";
        } else {
            // try to see if shard key has index
            DBObject index = mongo.getDB(db).getCollection("system.indexes")
                    .findOne(new BasicDBObject("key", shardKey));
            if (index != null) {
                desc = "shard key found";
            } else {
                desc = "shard key NOT found!";
            }
        }
        txt += mongo.toString() + " shard=" + shard + " - " + desc + "\n";
        BasicDBObject shardObj = new BasicDBObject("servers", mongo.toString());
        shardObj.put("status", desc);
        if (shardList.containsField(shard)) {
            new InfoDialog(null, "Error", null, "Duplicate Shard name " + shard).show();
            return;
        }
        shardList.put(shard, shardObj);
    }
    result.put("shards", shardList);

    FormDialog dia = (FormDialog) getBoundUnit(Item.regenRSList);
    dia.setStringFieldValue(Item.regenRSListArea, txt);
    if (!dia.show()) {
        return;
    }

    DB config = cmongo.getDB("config");

    // add database record
    BasicDBObject doc = new BasicDBObject("_id", db);
    doc.put("partitioned", true);
    doc.put("primary", primaryShard);
    config.getCollection("databases").save(doc);

    // add collection record
    doc = new BasicDBObject("_id", ns);
    doc.put("lastmod", new Date());
    doc.put("dropped", false);
    doc.put("key", shardKey);
    doc.put("unique", unique);
    config.getCollection("collections").save(doc);

    final DBCollection chunks = config.getCollection("chunks");
    long count = chunks.count(new BasicDBObject("ns", ns));
    if (count > 0) {
        dia = (FormDialog) getBoundUnit(Item.regenDeleteChunks);
        if (dia.show()) {
            chunks.remove(new BasicDBObject("ns", ns));
        } else {
            return;
        }
    }

    // add temp collection to sort chunks with shard key
    final DBCollection tmpchunks = config.getCollection("_tmpchunks_" + col);
    tmpchunks.drop();
    // should be safe environment, and dup keys should be ignored
    tmpchunks.setWriteConcern(WriteConcern.NORMAL);
    // can use shardKey as unique _id
    //        tmpchunks.ensureIndex(shardKey, "shardKey", true);

    // create filter for shard fields
    final DBObject shardKeyFilter = new BasicDBObject();
    //        final DBObject shardKeyDescend = new BasicDBObject();
    boolean hasId = false;
    for (String key : shardKey.keySet()) {
        shardKeyFilter.put(key, 1);
        if (key.equals("_id")) {
            hasId = true;
        }
    }
    if (!hasId) {
        shardKeyFilter.put("_id", 0);
    }

    dia = (FormDialog) getBoundUnit(Item.regenConfirm);
    if (!dia.show()) {
        return;
    }

    // now fetch all records from each shard
    final AtomicInteger todo = new AtomicInteger(mongoToShard.size());
    for (Map.Entry<MongoClient, String> entry : mongoToShard.entrySet()) {
        final MongoClient mongo = entry.getKey();
        final String shard = entry.getValue();
        new DbJob() {

            @Override
            public Object doRun() throws Exception {
                BasicDBObject shardObj = (BasicDBObject) shardList.get(shard);
                long count = mongo.getDB(db).getCollection(col).count();
                shardObj.put("count", count);
                DBCursor cur = mongo.getDB(db).getCollection(col).find(new BasicDBObject(), shardKeyFilter);
                long i = 0;
                int inserted = 0;
                long start = System.currentTimeMillis();
                while (cur.hasNext() && !isCancelled()) {
                    BasicDBObject key = (BasicDBObject) cur.next();
                    setProgress((int) ((++i * 100.0f) / count));
                    try {
                        BasicDBObject entry = new BasicDBObject("_id", key);
                        entry.put("_shard", shard);
                        tmpchunks.insert(entry);
                        ++inserted;
                    } catch (Exception e) {
                        getLogger().log(Level.WARNING, e.getMessage(), e);
                    }
                }

                if (isCancelled()) {
                    shardObj.put("cancelled", true);
                }
                shardObj.put("inserted", inserted);
                shardObj.put("scanTime", System.currentTimeMillis() - start);
                todo.decrementAndGet();
                return null;
            }

            @Override
            public String getNS() {
                return tmpchunks.getFullName();
            }

            @Override
            public String getShortName() {
                return "Scanning " + shard;
            }

            @Override
            public boolean isDeterminate() {
                return true;
            }
        }.addJob();

    }

    new DbJob() {

        @Override
        public Object doRun() throws Exception {
            // wait for all shards to be done
            long start = System.currentTimeMillis();
            while (todo.get() > 0 && !isCancelled()) {
                Thread.sleep(2000);
            }

            if (isCancelled()) {
                result.put("cancelled", true);
                return result;
            }

            // find highest current timestamp
            DBCursor cur = chunks.find().sort(new BasicDBObject("lastmod", -1)).batchSize(-1);
            BasicDBObject chunk = (BasicDBObject) (cur.hasNext() ? cur.next() : null);
            BSONTimestamp ts = (BSONTimestamp) (chunk != null ? chunk.get("lastmod") : null);

            // now infer chunk ranges
            long count = tmpchunks.count();
            result.put("uniqueKeys", count);
            int numChunks = 0;
            cur = tmpchunks.find().sort(new BasicDBObject("_id", 1));
            BasicDBObject prev = (BasicDBObject) cur.next();
            BasicDBObject next = null;
            // snap prev to minkey
            BasicDBObject theid = (BasicDBObject) prev.get("_id");
            for (String key : shardKey.keySet()) {
                theid.put(key, new MinKey());
            }
            String currentShard = prev.getString("_shard");

            int i = 1;
            while (cur.hasNext()) {
                next = (BasicDBObject) cur.next();
                setProgress((int) ((++i * 100.0f) / count));
                String newShard = next.getString("_shard");
                if (newShard.equals(currentShard))
                    continue;

                // add chunk
                ts = getNextTimestamp(ts);
                chunk = getChunk(ns, shardKey, prev, next, ts);
                chunks.insert(chunk);
                prev = next;
                currentShard = prev.getString("_shard");
                ++numChunks;
            }

            // build max
            next = new BasicDBObject();
            for (String key : shardKey.keySet()) {
                next.put(key, new MaxKey());
            }
            next = new BasicDBObject("_id", next);
            ts = getNextTimestamp(ts);
            chunk = getChunk(ns, shardKey, prev, next, ts);
            chunks.insert(chunk);
            ++numChunks;
            result.put("numChunks", numChunks);
            result.put("totalTime", System.currentTimeMillis() - start);
            return result;
        }

        @Override
        public String getNS() {
            return chunks.getFullName();
        }

        @Override
        public String getShortName() {
            return "Creating Chunks";
        }

        @Override
        public boolean isDeterminate() {
            return true;
        }
    }.addJob();
}

---

• «
• 1
• 2
• 3
• 4
• »