mongodb搭建和使用

mongodb搭建和使用

Mongo安装和启动

在linux环境下搭建单节点mongodb,步骤如下：
1.解压

tar -xzvf mongodb-linux-x86_64-3.4.6.tgz -C /usr/local/

2.改名

mv mongodb-linux-x86_64-3.4.6 mongodb

3.建立目录

mkdir -p /usr/local/mongodb/conf
mkdir -p /usr/local/mongodb/config
mkdir -p /usr/local/mongodb/config/data
mkdir -p /usr/local/mongodb/config/log

4.配置环境变量
vim /etc/profile

export MONGODB_HOME=/usr/local/mongodb
export PATH=$MONGODB_HOME/bin:$PATH

source /etc/profile
5. config server配置
vi /usr/local/mongodb/conf/config.conf

pidfilepath = /usr/local/mongodb/config/log/configsrv.pid
dbpath = /usr/local/mongodb/config/data
logpath = /usr/local/mongodb/config/log/congigsrv.log
logappend = true
bind_ip = 192.168.1.100   #(bind_ip参数，将本地IP赋予此参数。赋予后使用Server IP登入可以，但此时使用localhost 失败。为了同时兼容2种登入方式，将参数的赋值调整为：bind_ip=localhost,192.XXX.XXX.XXX 或设置为0.0.0.0)
port = 21000
fork = true   # （后台启动）
#设置最大连接数
maxConns=20000
auth=true

6.后台启动Mongo

mongod -f /usr/local/mongodb/conf/config.conf

新增用户

     use admin
     db.createUser(
     {
      user:"admin",
      pwd:"123456",
      roles:["root"], 
     mechanisms : ["SCRAM-SHA-1"] 
    }
       )                                                                                                             
    db.createUser(
        {
          user: "yyd",
           pwd: "yyd",
           roles: [  { role: "readWrite", db: "test" } ]  #读写帐号
         }
     )

登录数据库

登录数据库

新增数据

新增数据

查询数据

查询数据

更新数据

更新数据

删除数据

删除数据

shell 命令

//创建用户
use test
db.createUser(
    {
        user: "admin",
        pwd: "123456",
        roles: ["root"],
        mechanisms: ["SCRAM-SHA-1"]
    }
)
db.createUser(
    {
        user: "yyd",
        pwd: "yyd",
        roles: [{ role: "readWrite", db: "test" }]
    }
)

//多个新增 单个新增使用对象
db.getCollection("def_student").insertMany([{ "name": "wo", "age": "19" }])

//查询
// i 大小写不敏感   
// m 查询匹配中使用了锚，例如^（代表开头）和$（代表结尾），以及匹配n后的字符串  
// x 忽视所有空白字符,要求$regex与$option合用
// s 允许点字符（.）匹配所有的字符，包括换行符。要求$regex与$option合用
db.getCollection("def_student").find(
    {
        "$or": [{ "name": "test" }, { "name": "test1" }],
        "name": { "$regex": "test", "$options": "" },
        "birth": { "$gte": "2020-04-19 14:34:50", "$lte": "2020-04-22 13:34:50" },
        "age": { "$in": ["18", "19", "20"] },
        "num": 1.2,
        "arr": { "$elemMatch": { "or": [{ "name": "test" }, { "name": "test1" }] } }
    },
    {"age":0,"name":0}
).sort(
    {
        "age": -1, //desc
        "num": 1   //asc 
    }
).skip(10).limit(10)

// { $set: { "num": 1.9 } }
// { "$addToSet" : { "param6" : { "$each" : [ { "k1" : "v3"} , { "k2" : "v"}] }, "param7" : [ { "k1" : "v3"} , { "k2" : "v"}] } }
// { "$pull" : { "param1" : { "k1" : "v1" } } }
db.getCollection("def_student").update(
    { _id: ObjectId("63a158a32e7ceb44d0bb141c") },
    { "$pull": { "param2": { "k1": "v3" } } }
)
//aggregate
db.getCollection("def_student").aggregate(
    [
        { "$match": { "name": { "$regex": "test", "$options": "i" } } },
        {
            "$group":
                {
                    "_id": { "name": "$name", "age": "$age" },
                    "sum": { "$sum": "$num" },
                    "avg": { "$avg": "$num" },
                    "count": { "$sum": 1 },
                    "num_addToSet": { "$addToSet": "$num" },
                    "num_push": { "$push": "$num" },
                    "num_first": { "$first": "$num" },
                    "num_last": { "$last": "$num" },
                    "num_min": { "$min": "$num" },
                    "num_max": { "$max": "$num" }
                }
        },
        { "$sort": { "num": -1 } },
        { "$skip": { "$numberLong": "0" } },
        { "$limit": { "$numberLong": "100" } }
    ]
)