使用Postman发送POST请求时遭遇CastError问题求助

我用Postman发送POST请求创建预约时遇到了CastError，为什么patient和provider字段不能直接传字符串？那份Mongoose文档是不是我该看的？我试过两种转换ID的方案，但用了之后服务器崩溃：

const id = mongoose.Types.ObjectId(req.body.patient)

// 或者

import { ObjectId } from "mongodb";
const convertedId = ObjectId(req.body.patient)

我发送的请求内容：

{
    "patient": "StackOverFlow",
    "provider": "MariaMorales",
    "startTime": "1660572900250",
     "endTime": "1660573800250"
}

收到的报错信息：

{
    "message": {
        "errors": {
            "patient": {
                "stringValue": "\"StackOverFlow\"",
                "valueType": "string",
                "kind": "ObjectId",
                "value": "StackOverFlow",
                "path": "patient",
                "reason": {},
                "name": "CastError",
                "message": "Cast to ObjectId failed for value \"StackOverFlow\" (type string) at path \"patient\" because of \"BSONTypeError\""
            }
        },
        "_message": "Appointment validation failed",
        "name": "ValidationError",
        "message": "Appointment validation failed: patient: Cast to ObjectId failed for value \"StackOverFlow\" (type string) at path \"patient\" because of \"BSONTypeError\""
    }
}

相关Model代码：

// Appointment.ts
import mongoose, { Schema } from 'mongoose';

export interface isAppointment {
    // patient: string;
    // provider: string;
    startTime: Date;
    endTime: Date;
}

const AppointmentSchema: Schema = new Schema({
    patient: { type: Schema.Types.ObjectId, ref: 'Patient' },
    provider: { type: Schema.Types.ObjectId, ref: 'Provider' },
    startTime: { type: Date, required: true },
    endTime: { type: Date, required: true }
});

export default mongoose.model<isAppointment>('Appointment', AppointmentSchema);

// Patient.ts
import mongoose, { Schema } from 'mongoose';

export interface isPatient {
    _id: string;
    name: string;
    surname: string;
}

const PatientSchema: Schema = new Schema(
    {
        _id: { type: String, required: true },
        name: { type: String, required: true },
        surname: { type: String, required: true }
    },
    { timestamps: true }
);

export default mongoose.model<isPatient>('Patient', PatientSchema);

Controller函数代码：

import { Request, Response, NextFunction } from 'express';
import Appointment from '../models/Appointment';

const createAppointment = async (req: Request, res: Response, next: NextFunction) => {
    try {
        const appointment = new Appointment(req.body);
        await appointment.save();
        return res.status(200).json(appointment);
    } catch (error) {
        res.status(500).json({ message: error });
    }
};

export default { createAppointment };

1. 为什么不能直接传字符串？ #

你的Appointment模型中，patient和provider字段定义为Schema.Types.ObjectId类型——这是Mongoose用于关联其他集合的MongoDB原生ObjectID类型，要求值必须是符合ObjectID格式的字符串（例如60d21b4667d0d8992e610c85）。但你传入的"StackOverFlow"、"MariaMorales"是普通字符串，并非合法ObjectID，因此Mongoose在尝试类型转换时失败，抛出CastError。

同时你的Patient模型将_id定义为String类型，和Appointment的字段类型要求不匹配，这是核心矛盾点。

2. 那篇Mongoose文档是否有用？ #

是的，该文档讲解了Mongoose的查询类型转换逻辑，能帮你理解转换失败的底层原因，但解决问题需要从模型类型匹配性入手。

3. 为什么转换ID的方案会导致服务器崩溃？ #

用mongoose.Types.ObjectId()或ObjectId()转换"StackOverFlow"这种非合法ObjectID格式的字符串时，会直接抛出未捕获的异常，而你的Controller没有处理这种转换错误，最终导致服务器崩溃。

4. 正确解决方案 #

有两种可行思路：

• 思路一：统一ID类型
  若要保留Appointment中patient的ObjectId类型，需修改Patient模型，将_id改为MongoDB默认的ObjectID类型（删除_id的显式定义，Mongoose会自动生成ObjectID）：

  // 修改后的PatientSchema
  const PatientSchema: Schema = new Schema(
      {
          name: { type: String, required: true },
          surname: { type: String, required: true }
      },
      { timestamps: true }
  );
  

  后续创建Patient时，将MongoDB自动生成的ObjectID作为patient值传给预约接口即可。

• 思路二：修改Appointment字段类型
  既然Patient使用自定义字符串作为_id，直接将Appointment中的patient和provider类型改为String，与Patient的_id类型匹配：

  // 修改后的AppointmentSchema
  const AppointmentSchema: Schema = new Schema({
      patient: { type: String, ref: 'Patient' },
      provider: { type: String, ref: 'Provider' },
      startTime: { type: Date, required: true },
      endTime: { type: Date, required: true }
  });
  

  这样直接传"StackOverFlow"这类字符串就能通过验证，无需额外转换。

另外，请求中的startTime和endTime是字符串格式的时间戳，建议在Controller中手动转换为Date类型，避免潜在问题：

const createAppointment = async (req: Request, res: Response, next: NextFunction) => {
    try {
        const appointmentData = {
            ...req.body,
            startTime: new Date(parseInt(req.body.startTime)),
            endTime: new Date(parseInt(req.body.endTime))
        };
        const appointment = new Appointment(appointmentData);
        await appointment.save();
        return res.status(200).json(appointment);
    } catch (error) {
        res.status(400).json({ message: error }); // 用400状态码表示客户端请求错误更准确
    }
};

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