I'm using Node.js program to insert data into a MongoDB database. I have inserted data into a collection named "repl-failOver".
var mongoClient = require("mongodb").MongoClient; mongoClient.connect("mongodb://localhost:30002/test", function(err, db) { if (err) throw err; db.collection("repl-failOver").insert( { "documentNumber" : document++}, function (err, doc) { if (err) throw err; console.log(doc); }); db.close(); });
When I use the Mongo shell and list down the collections in the database using show collections
I am able to see the collection "repl-failOver".
How do I run a find command from the mongo shell for this collection?
The general conventions are: Lowercase names: this avoids case sensitivity issues, as MongoDB collection names are case sensitive. Plural: more obvious to label a collection of something as the plural, e.g. "files" rather than "file"
In MongoDB, you can use the renameCollection() method to rename or change the name of an existing collection. The new name of the collection. Optional, if true then mongod drops the target of renameCollection former to renaming the collection. The default value is false.
As mentioned above, a single database can have multiple collections. The following creates multiple collections. Use the show collections commands to list all the collections in a database. To delete a collection, use the db.
To list all collections in Mongo shell, you can use the function getCollectionNames().
Use this syntax:
db['repl-failOver'].find({})
or
db.getCollection('repl-failOver').find({})
You can find more information in the Executing Queries section of the manual:
If the mongo shell does not accept the name of the collection, for instance if the name contains a space, hyphen, or starts with a number, you can use an alternate syntax to refer to the collection, as in the following:
db["3test"].find() db.getCollection("3test").find()
You are getting this error from accessing collections with specific characters (-
, _
, ). I explained the workaround here, but basically all you need is to do
db.getCollection("repl-failOver").insert(...)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With