mongodb數(shù)據(jù)庫的使用

CntChen 發(fā)布于2019-06-26 17:01 / 1172人閱讀

最近在學(xué)習(xí)node，所以聽說node和mongodb更配哦。。所以我就來學(xué)習(xí)mongodb了

一、mongodb的開啟和關(guān)閉 1. 查找mongod是否可用

which mongod

2. 啟動mongodb

指定path 和log日志
mongod --dbpath /data2/db --port=27017 --fork /data2/db/log/mongod.log

3. 關(guān)閉數(shù)據(jù)庫

mongod --shutdown

二、mongodb的操作 1. 連接服務(wù)器

mongod 115.29.137.34:27017

2. 使用數(shù)據(jù)庫

(不存在的數(shù)據(jù)庫也可以使用,插入數(shù)據(jù)之后會自動保存)
use mydb

3. 權(quán)限登陸

db.auth("username","password")

4. 展示數(shù)據(jù)庫列表

show dbs

5. 插入數(shù)據(jù)

(類似于mysql的表)
db.users.insert({"name":"xiaomo"})
db.users.insert({"name":"xiaoming","age":25})
db.users.insert({"name":"xiaoming","age":24,"sex":"女"})

6. 查詢集合

(前提是use了一個(gè)數(shù)據(jù)庫)
有一個(gè)System.indexes 是索引
show collections

7. 不帶條件查詢

db.users.find()

8. 帶條件查詢

(參數(shù)是一個(gè)對象)
db.users.find({"name":"xiaomo"})

9. 更新數(shù)據(jù)

(有三個(gè)參數(shù),1:查詢條件,2:更新的內(nèi)容 3：更新的配置)
db.users.update({"name":"xiaomo",{$set:{"name:"xm}}) 修改滿足條件的第一條數(shù)據(jù)
db.users.update({"name":"xiaomo",{$set:{"name:"xm}},{multi:true}) 修改所有滿足條件的數(shù)據(jù)

10. 保存數(shù)據(jù)

(只有一個(gè)參數(shù)，必須要傳id，后面是要修改的數(shù)據(jù))
db.users.save({"id":"objectId(574710a97a3afd63cde56a49)","age":30})

11. 刪除數(shù)據(jù)

(1:條件 2 是否刪除所有符合條件的)
db.users.remove({"name":"xiaomoing"},true)

12. 刪除集合

db.users.drop()

三、使用mongoose操作數(shù)據(jù)庫 1. 模塊的介紹

連接mongdodb的驅(qū)動

2. 配置和鏈接

npm install --save mongoose

  var mongoose = require("mongoose");
  
  var uri = "mongodb://xiaomo:xiaomo@115.29.137.34:27017/admin";
  mongoose.connect(uri);

3. Model 和Shema

 // model.js
var Schema = mongoose.Schema,
    ObjectId = Schema.ObjectId;

var BlogPost = new Schema({
    author    : ObjectId,
    title     : String,
    body      : String,
    date      : Date
});

//Model
mongoose.model("blog",Schema);

var Comment = new Schema({
  name: { type: String, default: "hahaha" },
  age: { type: Number, min: 18, index: true },
  bio: { type: String, match: /[a-z]/ },
  date: { type: Date, default: Date.now }
});

// a setter
Comment.path("name").set(function (v) {
  return capitalize(v);
});

// middleware
Comment.pre("save", function (next) {
  notify(this.get("email"));
  next();
});

4. 創(chuàng)建文檔

  //insert.js
  var mongoose ＝ require("mongoose");
  require("./model.js"); //執(zhí)行
  var Blog = mongoose.model("blog");
  var blog = new Blog({
      name:"xiaomo",
      age:25,
      bio:"don"t know",
      date:new Date
    });

  book.save(function(err){
      console.log("save status:"+err);
    });

5. 刪除文檔

  var mongoose = require("mongoose");
  require("./model.js");
  var Blog = mongoose.model("blog");
  Blog.findOne({"name":"xiaomo"},function(err,doc){
    if(err){
    console.log(err)
    return;
    }
    if(doc){
    doc.reomove();
  }
    })

6. 簡單查詢

  var mongoose = require("mongoose");
  require("./model.js");
  var Blog = mongoose.model("blog");
  Blog.find({},function(err,doc){
    if(err){
    console.log(err)
    return;
    }
    console.log("result",doc)
    })

第一個(gè)滿足條件的結(jié)果

  var mongoose = require("mongoose");
  require("./model.js");
  var Blog = mongoose.model("blog");
  Blog.findOne({"name":"xiaomo"},function(err,doc){
    if(err){
    console.log(err)
    return;
    }
    console.log("result",doc)
    })

7. 條件語句

 // condation.js
  var mongoose = require("mongoose");
  require("./model.js");
  var Blog = mongoose.model("blog");
  //名字是xiaomo或者xiaoming 可以用$or和$and
  var condation = {
    $or  $and:[
    {"name":"xiaomo"},
    {"name":"xiaoming"}
    ]
  }
  Blog.find(condation,function(err,doc){
    if(err){
    console.log(err)
    return;
    }
    console.log("result",doc)
    })

三、在項(xiàng)目中使用mongoose 1. 生成項(xiàng)目

koa koatest -e koatest

2. 安裝依賴

cd koatest && npm install

3. 安裝mongoose

npm install --save mongoose

4. 創(chuàng)建模型

  // models/users.server.model.js
  var mongoose = require("mongoose");
  var UserSchema = new mongoose.Schema({
      uid:Number,
      username:String,
      createTime:Date,
      lastLogin:Date
    })
  module.exports = mongoose.model("User",UserSchema);

5. 創(chuàng)建配置文件

  // config/config.js
  module.exports={
    mongodb:"mongodb://xiaomo:xiaomo@115.29.137.34:27017/admin"
  }
  //config/mongoose.js
  var mongoose = require("mongoose");
  var config = require("./config.js");

  module.exports=function(){
    var db = mongoose.connect(config.mongodb);
    require("./../models/users.server.model.js");
    return db;
  }

6. 操作mongdodb 代碼

  //routers/users.js
  var router = require("koa-router")();
  var mongoose = require("mongoose");
  var User = mongoose.model("User");
  router.get("/", function *(next) {
      //add
      var user = new User({
        uid:
        })
      this.body = yield User.find({});
  });
  module.exports = router;