readme.md

MongoDB

Start

1. create instance of mongodb with docker, setting user and password with exposing port 27017

docker run -d --name mongo-server \
   -e MONGO_INITDB_ROOT_USERNAME=memo \
   -e MONGO_INITDB_ROOT_PASSWORD=secret \
   -p 27017:27017 \
   mongo

2. install cli tool mongosh

brew install mongosh

3. connect to mongo

mongosh "mongodb://memo:secret@127.0.0.1:27017/"

Databases

show databases
show dbs
use memo

Collections

show collections

db.getCollectionNames()
db.getCollectionInfos({'name': 'memo'})

find records

simple select (all, by id)

db.getCollection('memo').find({});
db.getCollection('memo').find({'_id': 'fdbf3b6008b064101a6bb0edcf58e67a'});

select with projection (expand)

db.getCollection('memo').find(
{
  '_id': {
    $in: [
	'fdbf3b6008b064101a6bb0edcf58e67a',
	'66e225a7ada99fe8fd9d15f938a94ce3'
	]
  },
  'data.goods.type': 'fmcg',
  'data.goods.goodId': '6dd6d7a8c1e282f486fe7877486c7f82'
}, {'data.goods.goodId': 1, 'data.goods.price': 1});

aggregate records

count

db.getCollection('memo').find({'_id': 12345678}).itcount()

pipeline with filter(match), unwind (denormalize), project

db.getCollection('memo').aggregate([

{$match: {'_id': {
	$in: [
		'fdbf3b6008b064101a6bb0edcf58e67a',
		'2c5be738c6102ba9a33b4d4729e24eff'
		]
	}
}},

{$unwind: {
  path: '$data.goods'
}},

{$match: {
  'data.goods.available': false
}},

{$project: {
  '_id': 1,
  'data.goods.goodId': 1,
  'data.goods.name': 1,
  'data.goods.price': 1,
}}

]);

insert

simple insert

db.getCollection('memo').insert({'_id': 12345678})
db['memo'].insert({'_id': 12345678})
db.memo.insert({'_id': 12345678})

insert one record db.collections.insertOne(documnent, options)

db.getCollection('memo').insertOne({
  '_id': 'fdbf3b6008b064101a6bb0edcf58e67a',
  'data': {
    'goods': [
      {
        'goodId': '6dd6d7a8c1e282f486fe7877486c7f82',
        'type': 'fmcg',
        'name': 'milk',
        'price': 10,
        'available': true
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'potato',
        'price': 15,
        'available': false
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'soy milk',
        'price': 9,
        'available': false
      }
    ]
  }
});

insert many records db.collection.insertMany(documents, options)

db.getCollection('memo').insertMany([
{
  '_id': '2c5be738c6102ba9a33b4d4729e24eff',
  'data': {
    'goods': [
      {
        'goodId': '6dd6d7a8c1e282f486fe7877486c7f82',
        'type': 'fmcg',
        'name': 'milk',
        'price': 10,
        'available': true
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'potato',
        'price': 15,
        'available': false
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'soy milk',
        'price': 9,
        'available': false
      }
    ]
  }
},
{
  '_id': '66e225a7ada99fe8fd9d15f938a94ce3',
  'data': {
    'goods': [
      {
        'goodId': '6dd6d7a8c1e282f486fe7877486c7f82',
        'type': 'fmcg',
        'name': 'milk',
        'price': 10,
        'available': true
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'potato',
        'price': 15,
        'available': false
      },
      {
        'goodId': 'd1c8034bdf0733018fceb39ca251e1f5',
        'type': 'fmcg',
        'name': 'soy milk',
        'price': 9,
        'available': false
      }
    ]
  }
}
]);

update

update multiple nested arrays with filter applied

db.getCollection('memo').update(
  {
     '_id': {
        $in: [
          'fdbf3b6008b064101a6bb0edcf58e67a',
          '2c5be738c6102ba9a33b4d4729e24eff'
        ]
     },
     'data.goods.goodId': '6dd6d7a8c1e282f486fe7877486c7f82'
  },
  {
    "$set": {'data.goods.$.available': true}
  },
  { multi: true }
);

delete

simple delete by math

db.getCollection('memo').remove({'_id': 12345678})

other

get connection string

db.getMongo()