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
}
})