ColdFusion and MongoDB

component { 
 this.name = "mongotest77123"; 
 this.serialization.preservecaseforstructkey=true 
 this.enableNullSupport=true 
 
 this.datasources = {  
  "local"= { 
   type="mongodb" 
  }, 
  "mymongodb"= { 
   type="mongodb", 
   host="mongodb://127.0.0.1:27017/", 
   "init"= true 
  } 
 } 
}

public void setMongoDataSource ( required string name, required string type, required string host, string port="27017", string replicaSet, boolean ssl, boolean dnsSeedList, string authMechanism, string username, string password, string authSource, string gssapiServiceName, string readConcern, string readPreference, string w, string wtimeout, boolean j, string connectTimeout, string maxPoolSize, string minPoolSize, string maxConnectionLifeTime, string maxConnectionIdleTime, string maxWaitQueueTimeout, string maxWaitQueueSize, string heartbeatFrequency, string minHeartbeatFrequency 

<cfscript> 
  // Create an object of administrator component and call the login method 
  adminObj = createObject("component","cfide.adminapi.administrator"); 
  adminObj.login("admin"); 
  
  // Create an object of datasource component 
  dsnObj = createObject("component","cfide.adminapi.nosql_datasource"); 
  
  // Setting up the parameter values for mongodb datasource 
  mongoDSN.name  = "mongo1" 
  mongoDSN.type = "mongodb" 
  mongoDSN.host = "127.0.0.1" 
  mongoDSN.port = "27017" 
  mongoDSN.caseSensitivity = "false" 
  
  // Create MongoDB datasource 
  mResponse=dsnObj.setMongoDataSource(mongoDSN.name,mongoDSN.type,mongoDSN.host, 
  mongoDSN.port,mongoDSN.caseSensitivity) 
</cfscript>

public any getDatasources (dsnName)

<cfscript> 
  // Create an object of administrator component and call the login method 
  adminObj = createObject("component","cfide.adminapi.administrator"); 
  adminObj.login("admin"); 
  
  // Create an object of datasource component 
  dsnObj = createObject("component","cfide.adminapi.nosql_datasource"); 
  
  res=dsnObj.getDatasources() 
  writeDump(res) 
</cfscript>

public void deleteMongoDatasource ( required dsnName )

<cfscript> 
  // Create an object of administrator component and call the login method 
  adminObj = createObject("component","cfide.adminapi.administrator"); 
  adminObj.login("admin"); 
  
  // Create an object of datasource component 
  dsnObj = createObject("component","cfide.adminapi.nosql_datasource"); 
  
  // Get datasource 
  res=dsnObj.getDatasources() 
  writedump(res) 
  
  // Delete datasource ds1 
  dsnObj.deleteMongoDatasource(res.ds1.name) 
   
</cfscript>

public Any verifyMongoDatasource ( required dsnName )

<cfscript> 
  // Create an object of administrator component and call the login method 
  adminObj = createObject("component","cfide.adminapi.administrator"); 
  adminObj.login("admin"); 
  
  // Create an object of datasource component 
  dsnObj = createObject("component","cfide.adminapi.nosql_datasource"); 
  
  // Get datasource 
  res=dsnObj.getDatasources() 
  writedump(res) 
  
  // Verify datasource ds1 
  verifyRes=dsnObj.verifyMongoDatasource(res.ds1.name)  
  writeDump(verifyRes) 
</cfscript> 

<cfscript> 
 // mymongodb is the name of the connection to MongoDB, defined in Application.cfc 
  
 db = getMongoService("mymongodb").db("newdb") // create a db 
 db.createCollection("Coll_1") // create a collection 
 db.createCollection("Coll_2") // create another collection 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.createCollection("newcolThree") // create a collection 
 // insert a single document 
 db.newcolThree.insert({ 
  "_id": 1, 
  "name":"John Lennon", 
  "band":"Beatles" 
 }) 
</cfscript> 

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.newcolThree.drop() // drop the collection 
 db.createCollection("newcolThree") // create a collection 
 // insert a single document 
 db.newcolThree.insert({ 
  "_id": 1, 
  "name":"John Lennon", 
  "band":"Beatles" 
 }) 
 // insert another document 
 db.newcolThree.insertOne({ 
  "_id": 2, 
  "name":"Paul McCartney", 
  "band":"Beatles" 
 }) 
 // insert many documents 
 db.newcolThree.insertMany([ 
  { 
   "_id": 3, 
   "name":"George Harrison", 
   "band":"Beatles" 
  }, 
  { 
   "_id": 4, 
   "name":"Ringo Starr", 
   "band":"Beatles" 
  } 
 ]) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 // create a capped collection by passing capped flag as true,  
 // size of collection, 
 // and max number of documents 
 db.createCollection("cappedLogCollection",{capped:true,size:10000,max:1000}) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 ifCapped=db.cappedLogCollection.isCapped() 
 writeOutput("Is collection capped: "& ifCapped) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.convertToCapped.drop() 
 // create an un-capped collection 
 db.createCollection("convertToCapped") // create a collection 
 //convert an existing non-capped collection to a capped collection 
 db.convertToCapped({"convertToCapped":"posts",size:10000}) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.createCollection("colFindDemo") // create a collection 
 db.colFindDemo.insertMany([ 
   
   { "_id" : 1, "name" : "Ian Gillan", "instrument" : "Vocals","born": 1945 }, 
   { "_id" : 2, "name" : "Ian Paice", "instrument" : "Drums", "born" : 1948 }, 
   { "_id" : 3, "name" : "Roger Glover", "instrument" : "Bass", "born" : 1945 }, 
   { "_id" : 4, "name" : "Steve Morse", "instrument" : "Guitar", "born" : 1954 }, 
   { "_id" : 5, "name" : "Don Airey", "instrument" : "Keyboards", "born" : 1948 }, 
   { "_id" : 6, "name" : "Jeff Martin", "instrument" : "Vocals", "born" : 1969 }, 
   { "_id" : 7, "name" : "Jeff Burrows", "instrument" : "Drums", "born" : 1968 }, 
   { "_id" : 8, "name" : "Stuart Chatwood", "instrument" : "Bass", "born" : 1969 } 
   
 ]) 
 // return all documents 
 db.colFindDemo.find() 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.colUpdDemo.drop() 
 db.createCollection("colUpdDemo") // create a collection 
 db.colUpdDemo.insertMany([ 
  { 
    "_id":1, 
    "product_name": "sildenafil citrate", 
    "supplier": "Wisozk Inc", 
    "quantity": 261, 
    "unit_cost": "$10.47" 
  },  
  { 
    "_id":2, 
    "product_name": "Mountain Juniperus ashei", 
    "supplier": "Keebler-Hilpert", 
    "quantity": 292, 
    "unit_cost": "$8.74" 
  },  
  { 
    "_id":3, 
    "product_name": "Dextromathorphan HBr", 
    "supplier": "Schmitt-Weissnat", 
    "quantity": 211, 
    "unit_cost": "$20.53" 
  } 
]) 
 // increment quantity by 10 for _id:1 
 db.colUpdDemo.update({"_id":1},{$inc:{"quantity":10}}) 
 // update unit cost from 8.74 to 10.74 
 db.colUpdDemo.update({"_id":2},{$set:{"unit_cost": "$10.74"}}) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("imdb"); 
 db.members.drop() 
 
 res = db.members.insertMany([ 
     { "_id" : 1, "member" : "abc123", "status" : "A", "points" : 2, "misc1" : "note to self: confirm status", "misc2" : "Need to activate" }, 
     { "_id" : 2, "member" : "xyz123", "status" : "A", "points" : 60, "misc1" : "reminder: ping me at 100pts", "misc2" : "Some random comment" } 
 ]) 
 
 writedump(res) 
 
 db.members.find().foreach((s) => { 
 writedump(s) 
 }) 
 
 writeoutput("apply update pipeline") 
 
 res = db.members.update( 
    { }, 
    [ 
      { $set: { status: "Modified", comments: [ "$misc1", "$misc2" ] } }, 
      { $unset: [ "misc1", "misc2" ] } 
    ], 
    { multi: true } 
 ) 
 
 writedump(res) 
 
 db.members.find().foreach((s) => { 
  writedump(s) 
}) 
 
 db.members.drop() 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.colUpdDemo.drop() 
 db.createCollection("colUpdDemo") // create a collection 
 db.colUpdDemo.insertMany([ 
  { 
    "_id":1, 
    "product_name": "sildenafil citrate", 
    "supplier": "Wisozk Inc", 
    "quantity": 261, 
    "unit_cost": "$10.47", 
    "stock":10000 
  },  
  { 
    "_id":2, 
    "product_name": "Mountain Juniperus ashei", 
    "supplier": "Keebler-Hilpert", 
    "quantity": 292, 
    "unit_cost": "$8.74", 
    "stock":15000 
  },  
  { 
    "_id":3, 
    "product_name": "Dextromathorphan HBr", 
    "supplier": "Schmitt-Weissnat", 
    "quantity": 211, 
    "unit_cost": "$20.53", 
    "stock":20000 
  } 
]) 
    db.colUpdDemo.updateOne({"supplier": "Keebler-Hilpert"},{$set:{"stock":16000}}) 
</cfscript> 

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.colUpdOneDemo.drop() 
 db.createCollection("colUpdOneDemo") // create a collection 
 db.colUpdOneDemo.insertMany([ 
  { "_id" : 1, "name" : "Central Perk Cafe", "Borough" : "Manhattan" }, 
  { "_id" : 2, "name" : "Rock A Feller Bar and Grill", "Borough" : "Queens", "violations" : 2 }, 
  { "_id" : 3, "name" : "Empire State Pub", "Borough" : "Brooklyn", "violations" : 0 } 
 ]) 
 try { 
    db.restaurant.updateOne( 
        { "name" : "Central Perk Cafe New" }, // specify incorrect value 
        { $set: { "violations" : 3 } } 
    ) 
 }  
 catch (any e) { 
    WriteOutput("Error: " & e.message) 
} 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("newdb") // create a db 
       db.colUpdManyDemo.drop() 
       db.createCollection("colUpdManyDemo") // create a collection 
       db.colUpdManyDemo.insertMany([ 
             { 
             "_id":1, 
             "product_name": "sildenafil citrate", 
             "supplier": "Wisozk Inc", 
             "quantity": 261, 
             "unit_cost": "$10.47", 
             "stock":10000 
             },  
             { 
             "_id":2, 
             "product_name": "Mountain Juniperus ashei", 
             "supplier": "Keebler-Hilpert", 
             "quantity": 292, 
             "unit_cost": "$8.74", 
             "stock":15000 
             },  
             { 
             "_id":3, 
             "product_name": "Dextromathorphan HBr", 
             "supplier": "Schmitt-Weissnat", 
             "quantity": 211, 
             "unit_cost": "$20.53", 
             "stock":20000 
             } 
       ]) 
       // update more than one document based on the specified filter 
       db.collection.updateMany( {"quantity" : {$gt: 250 }}, {$set: { "stock" : 50000 } } ); 
</cfscript>

component accessors="true" 
{ 
    property string empName; 
    property numeric age; 
    property string dept; 
}

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    emp = new Employee({empName="James", age=26, dept="000"}); 
    serializedStr = serializeJSON(emp); 
    collection.insertMany([{ 
        key: serializedStr, 
        name: "John Doe" 
    }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
   
    fileDataFromMongo = structFind(result, "key"); 
    fileInJSON =  DeserializeJSON(fileDataFromMongo); 
</cfscript>

{ 
     name="John", 
     age="26" 
}

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    fileToRead = "#ExpandPath('./test.cfc')#"; 
    jsonContent = FileRead(fileToRead); 
    serializedStr = serializeJSON(jsonContent); 
    collection.insertMany([{ 
        key: serializedStr, 
        name: "John Doe" 
    }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
   
    fileDataFromMongo = structFind(result, "key"); 
    fileInJSON =  DeserializeJSON(fileDataFromMongo); 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    percentages =  [22.5 , 33 , 45]; 
    collection.insertMany([{ 
        name: "John Doe", 
 marks:{ 
     total: 15, 
     percentage : percentages 
 } 
   }]); 
    //Read from mongo 
    result = collection.find().first() 
    writedump(result) 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    percent = 3333333444222244.457777778900673 
    collection.insertMany([{ 
        name: "John Doe", 
 marks:{ 
     total: 15, 
     percent = 3333333444222244.457777778900673 
 } 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    writedump(result) 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
     
    collection.insertMany([{ 
        name: "John Doe", 
 marks:{ 
     key: test, 
     name:"John Doe" 
 } 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    writedump(result) 
    fileDataFromMongo = structFind(result, "key"); 
    myFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "test.pdf" 
    FileWrite(file=myFile, data= fileDataFromMongo) 
</cfscript> 
<cfpdf action="extracttext" pages = "1" source="#myFile#" name="myXML" />

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    myquery = QueryExecute('SELECT * FROM artists', [], {datasource = 'cfartgallery'}) 
    jsonqueryresult =  SerializeJSON(myquery) 
</cfscript> 
<cfset Start = 1> 
<cfset End = 1> 
<cfloop query="myquery" startRow = "#Start#" endRow = "#End#"> 
    <cfset address =    #myquery.ADDRESS#> 
</cfloop> 
<cfscript> 
    collection.insertMany([{ 
        key: myquery, 
        name: "John Doe", 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    fileDataFromMongo = structFind(result, "key") 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    fileToRead = "#ExpandPath('./test1.png')#" 
    myfile = FileOpen(fileToRead, "readBinary"); 
    binaryFileContent = FileRead(myfile, 1000); 
    stringContentForBinaryFile = toString(binaryFileContent) 
     
    collection.insertMany([{ 
        key: binaryFileContent, 
        name: "John Doe" 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    fileDataFromMongo = structFind(result, "key"); 
    fileInString = ToString(ToBinary(fileDataFromMongo)) 
</cfscript>

<cfscript>  
    theDir=GetDirectoryFromPath(GetCurrentTemplatePath());  
    theFile=theDir & "courses.xls";  
</cfscript> 
<cfspreadsheet action="read" src="#theFile#" sheetname="courses" name="spreadsheetData"> 
<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    data = spreadsheetData 
         
    collection.insertMany([{ 
        key: data, 
        name: "John Doe" 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    MongoResultSheet = spreadsheetRead(result.key) 
    writedump(MongoResultSheet.ROWCOUNT) 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    myxml = fileRead(expandPath("./supportFiles/test.xml")); 
    mydoc = XmlParse(myxml) 
            
    collection.insertMany([{ 
        key: mydoc , 
        name: "John Doe" 
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    fileDataFromMongo = structFind(result, "key"); 
    fileInXML =  DeserializeXML(fileDataFromMongo) 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    percent = 44 
    collection.insertMany([{ 
       name: "John Doe", 
       marks:{ 
     total: 15, 
     percentage: 66-22 
        }  
   }]); 
    //Read from mongo 
    result = collection.find({"name" : {$eq:   "John Doe"}}).first() 
    if( result.marks.percentage eq percent){ 
           writeoutput("Pass"); 
    } 
</cfscript>

<cfscript> 
    // Retrieve database connection 
    db = getmongoservice("mymongodb").db("cf_local") 
    collection = db.students 
    // Insert many documents 
    res = collection.insertMany([{ 
        enrollno: "110470116021", 
        name: "John Adams", 
        college: GetMongoBsonMinKey() 
    }, 
    { 
        enrollno: "110470116022", 
        name: "Jane Madison", 
        college: GetMongoBsonMaxKey() 
    }]) 
    res = collection.find().toArray() 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("mynewdb") // create a db  
       writeDump(db) 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("mynewdb") // create a db 
       db.createCollection("mynewdbcollection") // create a collection called mynewdbcollection 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("mynewdb") // create a db 
       db.dropDatabase() // Removes the database 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("deeppurple") // create a db 
       db.createCollection("members") // create a collection 
       db.members.insertMany([ 
              
                    { "_id" : 1, "name" : "Ian Gillan", "instrument" : "Vocals","born": 1945 }, 
                    { "_id" : 2, "name" : "Ian Paice", "instrument" : "Drums", "born" : 1948 }, 
                    { "_id" : 3, "name" : "Roger Glover", "instrument" : "Bass", "born" : 1945 }, 
                    { "_id" : 4, "name" : "Steve Morse", "instrument" : "Guitar", "born" : 1954 }, 
                    { "_id" : 5, "name" : "Don Airey", "instrument" : "Keyboards", "born" : 1948 }, 
                    { "_id" : 6, "name" : "Jeff Martin", "instrument" : "Vocals", "born" : 1969 }, 
                    { "_id" : 7, "name" : "Jeff Burrows", "instrument" : "Drums", "born" : 1968 }, 
                    { "_id" : 8, "name" : "Stuart Chatwood", "instrument" : "Bass", "born" : 1969 } 
              
       ]) 
       get_name=db.members.getName() 
       writeOutput("The name of the database is: " & get_name) 
</cfscript>

<cfscript> 
       db = getmongoservice("mymongodb").db("rockband") // create a db 
       db.deeppurple.drop() 
       db.kingcrimson.drop() 
       db.createCollection("deeppurple") // create a collection 
       db.deeppurple.insertMany([ 
              
                    { "_id" : 1, "name" : "Ian Gillan", "instrument" : "Vocals","born": 1945 }, 
                    { "_id" : 2, "name" : "Ian Paice", "instrument" : "Drums", "born" : 1948 }, 
                    { "_id" : 3, "name" : "Roger Glover", "instrument" : "Bass", "born" : 1945 }, 
                    { "_id" : 4, "name" : "Steve Morse", "instrument" : "Guitar", "born" : 1954 }, 
                    { "_id" : 5, "name" : "Don Airey", "instrument" : "Keyboards", "born" : 1948 }, 
                    { "_id" : 6, "name" : "Jeff Martin", "instrument" : "Vocals", "born" : 1969 }, 
                    { "_id" : 7, "name" : "Jeff Burrows", "instrument" : "Drums", "born" : 1968 }, 
                    { "_id" : 8, "name" : "Stuart Chatwood", "instrument" : "Bass", "born" : 1969 } 
              
       ]) 
       db.createCollection("kingcrimson") // create another collection 
       db.kingcrimson.insertMany([ 
             {"_id":1,"name":"Robert Fripp","instrument":"Guitar", 
             "_id":2, "name": "Greg Lake","instrument":"Bass", 
             "_id":3, "name": "Ian McDonald","instrument":"Keyboard", 
             "_id":4, "name": "Michael Giles", "instrument":"Drums"} 
       ]) 
       collection_names=db.getCollectionNames() 
       writeDump(collection_names) 
</cfscript>

<cfscript> 
       // The following returns information for all collections in the rockband database 
       db = getmongoservice("mymongodb").db("rockband") 
       all_collections=db.getCollectionInfos() 
       writeDump(all_collections) 
</cfscript>

<cfscript> 
       // The following returns information for all collections in the rockband database 
       db = getmongoservice("mymongodb").db("rockband") 
       out=db.getCollectionInfos({"born":1948}) 
       writeDump(out) 
</cfscript>

<cfscript> 
  db = getmongoservice("mymongodb").db("db_source") // create a db 
  // Members collection 
  countResponse=db.members.count() 
  writeDump(countResponse) // Returns all documents in the collection 
  // Count all documents that match a query 
  countResponse1=db.members.count( { born: { $gt: 1950 } } ) 
  writeDump(countResponse1) // Returns documents that match the criteria 
</cfscript>

<cfscript> 
  db = getmongoservice("mymongodb").db("db_source") // create a db 
  // Members collection 
  countResponse=db.members.countDocuments() 
  writeDump(countResponse) // Returns all documents in the collection 
  // Count all documents that match a query 
  countResponse1=db.members.countDocuments( { born: { $gt: 1950 } } ) 
  writeDump(countResponse1) // Returns documents that match the criteria 
</cfscript>

<cfscript> 
  db = getmongoservice("mymongodb").db("db_source") // create a db 
  // Members collection 
  countResponse=db.members.countDocuments() 
  writeDump(countResponse) // Returns all documents in the collection 
  // Count all documents that match a query 
  countResponse1=db.members.estimatedDocumentCount( { born: { $gt: 1950 } } ) 
  writeDump(countResponse1) // Returns documents that match the criteria 
</cfscript>

<cfscript> 
    // Retrieve database 
    db = getmongoservice("cosmos").db("mydb") 
    collection = db.collection 
    collection.drop() 
    writeOutput("number of documents in the collection: <b>" & collection.count() & " </b><br/>") 
    writeOutput("<b> Insert a document </b><br/>") 
    // Insert many documents 
    res = collection.insertMany([{ 
        enrollno: "1001", 
        name: "John Doe", 
        college: "Any college", 
        course: { 
            courseName: "Any course", 
            duration: "4 Years" 
        }, 
        address: { 
            city: "Any city", 
            state: "Any state", 
        country: "Any country" 
        } 
    }, 
    { 
    enrollno: "1002", 
    name: "Jane Doe", 
    college: "Some college", 
    course: { 
        courseName: "Some course", 
        duration: "4 Years" 
    }, 
    address: { 
        city: "Some city", 
        state: "Some state", 
        country: "Some country" 
    } 
    }]) 
    //count number of documents in the collection 
    writeOutput("number of documents in the collection: <b>" & collection.count() & " </b><br/>") 
    writeOutput("<b> Delete a document </b><br/>") 
    collection.deleteOne({name: MongoRegExp("John Doe","i")}) 
    writeOutput("number of documents in the collection: <b>" & collection.count() & " </b><br/>") 
</cfscript>

<cfscript> 
   db = getmongoservice("mongodb").db("imdb"); 
   db.orders.drop() 
   db.orders.insertOne({ 
   _id: MongoObjectId("563237a41a4d68582c2509da"), 
   stock: "Brent Crude Futures", 
   qty: 250, 
   type: "buy-limit", 
   limit: 48.90, 
   creationts: ParseDateTime("2015-11-01T12:30:15Z"), 
   expiryts: ParseDateTime("2015-11-01T12:35:15Z"), 
   client: "Crude Traders Inc." 
   }) 
   writeoutput("count: " & db.orders.count() & " <br/>"); 
   res = db.orders.deleteMany( { "client" : "Crude Traders Inc." } ); 
   writedump(Res) 
   writeoutput("count: " & db.orders.count() & " <br/>"); 
   res = db.orders.deleteMany( { "stock" : "Brent Crude Futures", "limit" : { $gt : 48.88 } } ); 
   writedump(Res) 
   res = db.orders.deleteMany( 
   { "client" : "Crude Traders Inc." }, 
   { w : "majority", wtimeout : 100 } 
   ); 
   writedump(Res) 
   writeoutput("collation example") 
   db.mycoll.drop(); 
   res = db.mycoll.insert([{ _id: 1, category: "café", status: "A" }, 
   { _id: 2, category: "cafe", status: "a" }, 
   { _id: 3, category: "cafE", status: "a" }]) 
   writedump(res) 
   res = db.myColl.deleteMany( 
   { category: "cafe", status: "A" }, 
   { collation: { locale: "fr", strength: 1 } } 
   ) 
   writedump(res) 
   db.myColl.find().foreach((s) => { 
   writedump(s) 
   }) 
   db.mycoll.drop(); 
   db.orders.drop() 
</cfscript>

<cfscript> 
    db = getmongoservice("mymongodb").db("imdb"); 
 
    res = db.myColl1.insertMany([ 
        { _id: 1, category: "café", status: 01 }, 
        { _id: 2, category: "cafe", status: 02 }, 
        { _id: 3, category: "cafE", status: 03 } 
    ]) 
    res = db.myColl1.distinct( "category", {}, { collation: { locale: "fr", strength: 1 } } ) 
    writedump(res) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("mynewdb") // create a db 
 db.createCollection("mynewdbcollection") // create a collection called mynewdbcollection 
  
 try { 
  db.mynewdbcollection.drop() // Removes the collection 
  writeOutput("Collection removed sucessfully.") 
 } 
  
 catch (any e){ 
  writeOutput("Unable to remove collection.") 
 } 
 // 
</cfscript>

<cfscript> 
  db = getmongoservice("mymongodb").db("db_source") // create a db 
  // Members collection 
  // Count function 
  explainResponse1=db.members.explain().count({ 
    born:{$gt:1950} 
  }) 
  writeDump(explainResponse1) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 //db.colFindDemo.drop() 
 db.createCollection("colFindDemo") // create a collection 
 db.colFindDemo.insertMany([ 
   
   { "_id" : 1, "name" : "Ian Gillan", "instrument" : "Vocals","born": 1945 }, 
   { "_id" : 2, "name" : "Ian Paice", "instrument" : "Drums", "born" : 1948 }, 
   { "_id" : 3, "name" : "Roger Glover", "instrument" : "Bass", "born" : 1945 }, 
   { "_id" : 4, "name" : "Steve Morse", "instrument" : "Guitar", "born" : 1954 }, 
   { "_id" : 5, "name" : "Don Airey", "instrument" : "Keyboards", "born" : 1948 }, 
   { "_id" : 6, "name" : "Jeff Martin", "instrument" : "Vocals", "born" : 1969 }, 
   { "_id" : 7, "name" : "Jeff Burrows", "instrument" : "Drums", "born" : 1968 }, 
   { "_id" : 8, "name" : "Stuart Chatwood", "instrument" : "Bass", "born" : 1969 } 
   
 ]) 
 // return all documents 
 db.colFindDemo.find() 
 writedump(res) 
</cfscript>

<cfscript> 
 db.colFindDemo.find({"_id":4}) 
</cfscript> 
 
<cfscript> 
 db.colFindDemo.find({"instrument":"Drums"}) 
</cfscript> 
 
<cfscript> 
 df.colFindDemo.find({"_id":{$gt:4}}) // find _ids greater than 4 
</cfscript> 
 
<cfscript> 
 df.colFindDemo.find({"instrument":{$regex:"^B"}}) // find instruments that start with B 
</cfscript> 
 
<cfscript> 
 db.colFindDemo.find({"name":{$in:["Ian Gillan","Ian Paice"]}}) // find documents that match the names 
</cfscript> 
 
<cfscript> 
 db.colFindDemo.find({"born":{$all:[1948]}}) // find documents that match born, which contains the year 1948 
</cfscript> 
 
<cfscript> 
 // find all documents where instrument is Drums or the year of birth is 1948 
 db.colFindDemo.find({$or:[{"instrument":"Drums"},{"born":1948}]}) 
</cfscript>

<cfscript> 
 db = getmongoservice("mymongodb").db("newdb") // create a db 
 db.createCollection("newcolThree") // create a collection 
 // insert a single document 
 db.newcolThree.insert({ 
  "_id": 1, 
  "name":"John Lennon", 
  "band":"Beatles" 
 }) 
</cfscript>