Mongodb: Difference between revisions

From Bitpost wiki
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