Java tutorial
/* * Copyright (C) 2000 - 2015 TagServlet Ltd * * This file is part of Open BlueDragon (OpenBD) CFML Server Engine. * * OpenBD is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * Free Software Foundation,version 3. * * OpenBD is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with OpenBD. If not, see http://www.gnu.org/licenses/ * * Additional permission under GNU GPL version 3 section 7 * * If you modify this Program, or any covered work, by linking or combining * it with any of the JARS listed in the README.txt (or a modified version of * (that library), containing parts covered by the terms of that JAR, the * licensors of this Program grant you additional permission to convey the * resulting work. * README.txt @ http://www.openbluedragon.org/license/README.txt * * http://openbd.org/ */ package com.bluedragon.mongo; import com.mongodb.Block; import com.mongodb.MongoException; import com.mongodb.client.DistinctIterable; import com.mongodb.client.MongoDatabase; import com.naryx.tagfusion.cfm.engine.cfArgStructData; import com.naryx.tagfusion.cfm.engine.cfArrayData; import com.naryx.tagfusion.cfm.engine.cfData; import com.naryx.tagfusion.cfm.engine.cfSession; import com.naryx.tagfusion.cfm.engine.cfStringData; import com.naryx.tagfusion.cfm.engine.cfmRunTimeException; public class MongoCollectionDistinct extends MongoDatabaseList { private static final long serialVersionUID = 1L; public MongoCollectionDistinct() { min = 3; max = 4; setNamedParams(new String[] { "datasource", "collection", "key", "query" }); } public String[] getParamInfo() { return new String[] { "datasource name. Name previously created using MongoRegister", "collection name", "key to find", "optional query" }; } public java.util.Map<String, String> getInfo() { return makeInfo("mongo", "Finds all the distinct values for the key for the collection against the optional query", ReturnType.ARRAY); } public cfData execute(cfSession _session, cfArgStructData argStruct) throws cfmRunTimeException { MongoDatabase db = getMongoDatabase(_session, argStruct); String collection = getNamedStringParam(argStruct, "collection", null); if (collection == null) throwException(_session, "please specify a collection"); String key = getNamedStringParam(argStruct, "key", null); if (key == null) throwException(_session, "please specify a key"); cfData query = getNamedParam(argStruct, "query", null); try { DistinctIterable<String> result; if (query != null) result = db.getCollection(collection).distinct(key, String.class).filter(getDocument(query)); else result = db.getCollection(collection).distinct(key, String.class); cfArrayData arr = cfArrayData.createArray(1); result.forEach(new Block<String>() { @Override public void apply(final String st) { try { arr.addElement(new cfStringData(st)); } catch (cfmRunTimeException e) { } } }); return arr; } catch (MongoException me) { throwException(_session, me.getMessage()); return null; } } }