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