mongo command line queries code example
Example 1: mongo shell commands
show dbs # <=> Print a list of all databases on the server.
use <db> # <=> Switch current database to <db>
show collections # <=> Print a list of all collections for current database.
db.people.insert({name:"Ashwin",gender:"m"}) # <=> Inserts a new "person" collection with a new object in that collection
db.people.find(<any attributes or none>) # <=> Find all persons in the collection
db.people.update({name:"Ashwin"},{gender:"f"}) # <=> Updates the selected (1st parameter) person with new value(2nd parameter)
db.people.remove({name:"Ashwin"}) # <=> Remove where name is "Ashwin"
db.people.drop() # <=> Delete the "people" collection
Example 2: mongodb cmds
MongoDB
mongod --dbpath /users/yulin/Documents/data/db
mongo (once mongod is ran OPEN ANOTHER TERMINAL THconnect to MongoDB)
ctrl-l to clear screen
show dbs
use {put db name here}
show collections
use {put collection name here} ex. - use quizzes
use dbs ( or cd .. -- to go back dbs level)
or just stay @ db level
db.createCollection(“quizzes”)
db.quizzes.find().pretty()
db.quizzes.insert({“title”: 1}) (crud stuff)
db.quizzes.find({“title”: 1})
db.quizzes.remove({}) (remove all)
db.quizzes.remove({title: 1})
db.quizzes.update ({title: 1}, {title, 2}) (update by replaceing the entire object)
db.quizzes.update ({name: “yulin”}, {$set:{title: “Quiz 2”}}) (update by appending object)
db.quizzes.find({avg: {$gt: 85}}) (greater than)
db.quizzes.find({avg: {$gte: 85}}) (greater than or equal to)
db.quizzes.find({avg: {$lte: 85}}) (less than)