node如何使用mongoose?

段良弼
2023-12-01

npm i mongoose

// 一、通过mongoose建立一个数据表
import mongoose from 'mongoose' // 引入
const Schema = mongoose.Schema; // 初始化一个对象
// 创建实例
const UserSchema = new Schema({
  username: {
    type: String,
    unique: true,
    require: true
  },
  password: {
    type: String,
    require: true
  },
  email: {
    type: String,
    require: true
  }
});
export default mongoose.model('User', UserSchema)



// 二、在接口中使用数据表
1、 引入
const Person = require('../dbs/models/user')

增加
router.post('/add', async (ctx) => {
  const { name, age } = ctx.request.body
  const person  = new Person({ name, age })
  try {
    await person.save()
    code = 0
  } catch(e) {
    code = -1
  }
  ctx.body = {
    code: code
  }
})

删除
router.post('/remove', async (ctx) => {
  const result = await Person.where({name: ctx.request.body.name}).remove()
  ctx.body = {
    code: 0
  }
})


改
router.post('/update', async (ctx) => {
  const result = await Person.where({ name:ctx.request.body.name }).update({ age: ctx.request.body.age })
  ctx.body = {
    code: 0
  }
})


查
router.get('/get', async (cyx) => {
   const { name, age } = ctx.request.body
   const result = await Person.findOne({name})
   const results = await Person.find({name})
   ctx.body = {
    code: 0,
    result,
    results
   }
})

 类似资料: