Mongoose仅保存ObjectId而非对象数据问题排查请求

我正尝试通过将User模型中的用户角色从user修改为coach，来将普通用户转为教练。但遇到问题：Mongoose仅保存ObjectId而非完整的对象数据，请求排查并解决。

User模型 #

const mongoose = require('mongoose')
const Schema = mongoose.Schema

const UserSchema = new Schema({
    firstname : {
        type : String,
        required : true
    },
    lastname : {
        type : String,
        required : true
    },
    email : {
        type : String,
        required : true,
        unique : true
    },
    verified : {
        type : Boolean,
        default : false
    },
    password : {
        type : String,
        required : true,
        minLength : 3
    },
    role : {
        type : String,
        enum : ['admin', 'coach', 'user'],
        default : 'user'
    }
})

module.exports = mongoose.model('User', UserSchema)

Coach模型 #

const mongoose = require('mongoose')
const Schema = mongoose.Schema

const CoachSchema = new Schema({
    coach : {
        type : mongoose.Schema.Types.ObjectId,
        ref : 'User'
    },
    team : {
        type : mongoose.Schema.Types.ObjectId,
        ref : 'Team'
    }
    
})

module.exports = mongoose.model('Coach', CoachSchema)

Coach控制器 #

const Coach = require('../models/Coach')
const User = require('../models/User')
const Team = require('../models/Teams')


exports.createCoach = async (req, res)=>{
    try {
        const userId = req.params.id
        const coach_data = await User.findById(userId)
        const {password, verified, ...other} = coach_data._doc
        console.log(other);
        const team = req.body.team
        const team_data = await Team.findById(team)

        const user = await User.findById(userId)
        if(!user) return res.status(400).json({
            error : 'User not found'
        })
        
        const coach = new Coach({
            coach : other,
            team : team_data
        })

        if(user.role === 'coach') return res.status(404).json({
            error : 'User is already a coach'
        })

        const updateUser = await User.findOneAndUpdate({ _id : userId}, {
            role : 'coach'
        },
        {
            new : true
        }
        )

        await coach.save()
        res.status(200).json('User has been made coach')

    } catch (error) {
        console.log(error);
        res.status(500).json(error)
    }
}

exports.getAllCoaches = async(req, res)=>{
    try {
        const coaches = await Coach.find()

        res.status(200).json(coaches)
    } catch (error) {
        res.status(500).json(error)
    }
}

Coach路由 #

const router = require('express').Router()
const coachController = require('../controllers/coachController')

router.post('/create-coach/:id', coachController.createCoach)
router.get('/get-coaches', coachController.getAllCoaches)

module.exports = router

核心原因 #

1. 模型字段类型限制：Coach模型中coach字段被定义为ObjectId类型，仅能存储User文档的ID，无法保存完整用户对象。
2. 控制器代码逻辑错误：创建Coach实例时传入的是用户对象的部分属性，但Mongoose会自动将其转换为ObjectId（受模型字段类型约束），最终仅存储ID。
3. 查询未关联数据：getAllCoaches方法仅查询Coach集合，未使用populate关联User和Team数据，导致返回结果只有ObjectId。

解决方案（推荐标准MongoDB关联方案） #

1. 修改创建Coach的逻辑 #

直接传入用户ID和团队ID创建关联记录，无需传递完整对象：

exports.createCoach = async (req, res)=>{
    try {
        const userId = req.params.id
        const teamId = req.body.team

        // 检查用户存在性
        const user = await User.findById(userId)
        if(!user) return res.status(400).json({ error : 'User not found' })
        
        // 检查用户是否已是教练
        if(user.role === 'coach') return res.status(404).json({ error : 'User is already a coach' })

        // 检查团队存在性
        const teamExists = await Team.exists({_id: teamId})
        if(!teamExists) return res.status(400).json({ error : 'Team not found' })

        // 创建Coach关联记录
        const coach = new Coach({
            coach: userId,
            team: teamId
        })

        // 更新用户角色
        await User.findOneAndUpdate(
            { _id: userId },
            { role: 'coach' },
            { new: true }
        )

        await coach.save()
        res.status(200).json('User has been made coach')

    } catch (error) {
        console.log(error);
        res.status(500).json(error)
    }
}

2. 修改查询Coach的逻辑 #

使用populate方法关联查询User和Team数据，同时排除敏感字段：

exports.getAllCoaches = async(req, res)=>{
    try {
        // 填充关联的User和Team数据，排除用户密码、验证状态字段
        const coaches = await Coach.find()
            .populate('coach', '-password -verified')
            .populate('team')

        res.status(200).json(coaches)
    } catch (error) {
        res.status(500).json(error)
    }
}

替代方案（不推荐，数据冗余） #

如果确实需要在Coach集合中存储完整用户数据，可修改Coach模型的coach字段类型为Schema.Types.Mixed，但会导致数据冗余，后续用户信息更新时需同步修改Coach集合中的数据，维护成本高：

// 修改后的Coach模型
const CoachSchema = new Schema({
    coach: {
        type: Schema.Types.Mixed,
        required: true
    },
    team: {
        type: mongoose.Schema.Types.ObjectId,
        ref: 'Team'
    }
})

内容的提问来源于stack exchange，提问作者Royalty