Ⅰ宗兼、MongoDB

一、安裝數(shù)據(jù)庫

https://docs.mongodb.com/manual/administration/install-community/

二慈参、啟動數(shù)據(jù)庫

1比藻、windows

mongod --dbpath d:/data/db
mongo

2册烈、mac

mongod --config /usr/local/etc/mongod.conf
mongo

三弥姻、數(shù)據(jù)庫操作

use gp145
db/db.getName()
show dbs
db.createCollection('movies')
db.stats()
db.version()
db.getMongo() //connection to 127.0.0.1:27017
db.dropDatabase()

四强经、集合操作

db.createCollection('users')
db.getCollectionNames()

五睡陪、文檔的操作

5.1 添加

db.users.insertOne({username: 'yangli', password: 'abc123'})
db.users.insertOne({username: 'haozeliang', email: 'hzl@126.com'})
db.users.insertOne({"username": 1, password: 123})
db.users.insertMany([{username: 'gaojie', password: 'gj', email: 'gj@126.com'}, {username: 'xinyi', password: 123, email: 123}])
db.users.insert([{username: 'yangli'}, {useranme: 'zeliang'}])
db.users.save()

5.2 修改

db.users.update({username: 'yangli'}, {username: 'yl'})

// 1、如果第二個參數(shù)是一個對象夕凝，后邊兩個參數(shù)無效
// 2宝穗、如果第二個參數(shù)是通過$set設(shè)置的話， 后兩個參數(shù)才有效
// 3码秉、后兩個參數(shù)的第一個參數(shù)：true/如果數(shù)據(jù)查詢不到逮矛，就創(chuàng)建 false/如果數(shù)據(jù)查詢不到，就什么都不做
// 4转砖、后兩個參數(shù)第第二個參數(shù)：true/更新多條须鼎，false/更新一條
db.users.update({username: 'gp145'}, {$set: {username: 'yl'}}, true, true)
// 5、如果使用updateMany, 就不需要傳遞后兩個參數(shù)第二個了
db.users.updateMany({username: 'yl'}, {$set: {username: 'yangli'}})
 db.collection.update(
   <query>,
   <update>,
   {
     upsert: <boolean>,
     multi: <boolean>,
     writeConcern: <document>,
     collation: <document>,
     arrayFilters: [ <filterdocument1>, ... ],
     hint:  <document|string>  // Available starting in MongoDB 4.2
   }
)

參考文檔：https://docs.mongodb.com/manual/reference/method/db.collection.update/#db.collection.update

5.3 刪除

db.users.remove({username: 'xinyi'}, true)

參考文檔：https://docs.mongodb.com/manual/reference/method/db.collection.remove/

5.4 查找

db.movies.find({}, {nm: 1, _id: 0, rt: 1})
db.movies.find({}, {nm: 1, _id: 0, rt: 1}).sort({rt: -1})
db.movies.find({}, {nm: 1, _id: 0, rt: 1}).limit(10)
db.movies.find({}, {nm: 1, _id: 0, rt: 1}).sort({rt: -1}).limit(10)
db.movies.find({}, {nm: 1, _id: 0, rt: 1}).sort({rt: -1}).limit(3).skip(6)
db.movies.find({rt: {$gte: '2019-10-14'}}, {nm: 1, _id: 0, rt: 1})
db.movies.find({rt: {$gte: '2019-10-14'}}, {nm: 1, _id: 0, rt: 1})
db.movies.find({rt: {$gte: '2019-10-14'}}, {nm: 1, _id: 0, rt: 1}).count()
db.movies.find({rt: {$lte: '2019-10-14'}}, {nm: 1, _id: 0, rt: 1}).count()
db.movies.find({nm: /小/}, {nm: 1, _id: 0, rt: 1}).sort({rt: -1})

六府蔗、數(shù)據(jù)庫管理工具

robo 3T

Ⅱ晋控、Mongoose

1、數(shù)據(jù)庫連接

const mongoose = require('mongoose')
mongoose.connect('mongodb://localhost:27017/lagou-admin', { useUnifiedTopology: true, useNewUrlParser: true })

const Users = mongoose.model('users', {
  username: String,
  password: String
})

module.exports = {
  Users
}

2姓赤、Route

var express = require('express')
var router = express.Router()

const { signup, hasUsername } = require('../controllers/users')

router.post('/signup', hasUsername, signup)

module.exports = router

3赡译、Model

const { Users } = require('../utils/db')

const save = (data) => {
  const users = new Users(data)
  return users.save()
}

const findOne = (conditions) => {
  return Users.findOne(conditions)
}

module.exports = {
  save,
  findOne
}

4、View

art-template + express

{
  "ret": true,
  "data": {{data}}
}

5不铆、Controller

const usersModel = require('../models/users')

const signup = async function(req, res, next) {
  res.set('Content-Type', 'application/json; charset=utf-8')

  let { username, password } = req.body

  let result = await usersModel.save({
    username,
    password: hash
  })

  if (result) {
    res.render('succ', {
      data: JSON.stringify({
        message: '用戶注冊成功.'
      })
    })
  } else {
    res.render('fail', {
      data: JSON.stringify({
        message: '用戶注冊失敗.'
      })
    })
  }
}

const hasUsername = async function(req, res, next) {
  res.set('Content-Type', 'application/json; charset=utf-8')
  let { username } = req.body
  let result = await usersModel.findOne({username})
  if (result) {
    res.render('fail', {
      data: JSON.stringify({
        message: '用戶名已經(jīng)存在.'
      })
    })
  } else {
    next()
  }
}

module.exports = {
  signup,
  hasUsername
}