MongoDB的集合关联

MongoDB的集合关联

const mongoose = require('mongoose');
mongoose.connect('mongodb://localhost/playground', { useNewUrlParser: true, useUnifiedTopology: true })
    .then(() => {
        console.log('连接成功');
    })
    .catch(err => {
        console.log('连接失败');
    });
//创建用户集合规则
const userSchema = new mongoose.Schema({
    name: {
        type: String,
        required: true
    }
});
//创建集合规则
const postSchema = new mongoose.Schema({
        title: {
            type: String
        },
        author: {
        	//从id中得到类型  固定写法
            type: mongoose.Schema.Types.ObjectId,
            //从集合User中得到值
            ref: 'User'
        }
    })
    //用户集合
const User = mongoose.model('User', userSchema);
const Post = mongoose.model('Post', postSchema)

//创建用户
User.create({ name: 'itheima' }).then(result => {
    console.log(result);
});
//创建一篇文章
// Post.create({ title: '123', author: '5f41e5c6dddd9e00e42356df' }).then(result => {
//     console.log(result);
// })
//populate表示从author中获取值
Post.find().populate('author').then(result => {
    console.log(result);
})