Mongodb: Difference between revisions
No edit summary |
|||
Line 24: | Line 24: | ||
# This will drop the bookstore db | # This will drop the bookstore db | ||
mongo bookstore --eval "printjson(db.dropDatabase())" | mongo bookstore --eval "printjson(db.dropDatabase())" | ||
==== Convert a single node to a replica set ==== | |||
This is apparently required for transactions to work...? | |||
* CONVERTING TO SINGLE-NODE REPLICA SET: | |||
sudo emacs -nw /etc/mongod.conf | |||
# ----------------------- | |||
# MBM enable replication | |||
replication: | |||
replSetName: esrs1 | |||
# ----------------------- | |||
sudo service mongod restart | |||
sudo mongo | |||
rs.initiate() | |||
# hit return after a moment to ensure it becomes PRIMARY |
Revision as of 15:32, 26 May 2021
Installation
mh-install-mongodb
UI tools =
- MongoDB_Admin
git clone https://github.com/hatamiarash7/MongoDB_Admin cd MongoDB_Admin npm start &
- Robo 3T
~/apps/robo3t/bin/robo3t &
Querying
- OR
{"$or": [{"firstName": "Michael"}, {"firstName": "Tom"}]}
- To remove all documents that do not have a certain value:
db.inventory.remove( { type : { $ne: "food" } } )
- To remove all documents that do not have a range of values:
db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )
Run a script or statement from command line
# This will drop the bookstore db mongo bookstore --eval "printjson(db.dropDatabase())"
Convert a single node to a replica set
This is apparently required for transactions to work...?
- CONVERTING TO SINGLE-NODE REPLICA SET:
sudo emacs -nw /etc/mongod.conf # ----------------------- # MBM enable replication replication: replSetName: esrs1 # ----------------------- sudo service mongod restart sudo mongo rs.initiate() # hit return after a moment to ensure it becomes PRIMARY