TypeScript+MongoDB原生包关联查询报错：populate属性不存在

错误原因 #

你当前使用的是原生MongoDB Node.js驱动，而populate()是Mongoose（MongoDB的ODM框架）专属的关联查询方法，原生驱动并没有这个API，因此触发Property 'populate' does not exist on type的类型错误。另外你的投影字段里写的id是错误的，MongoDB默认主键为_id，需要修正。

解决方案一：使用原生驱动的$lookup聚合操作实现关联查询 #

MongoDB原生驱动可以通过聚合管道中的$lookup阶段实现集合关联查询，替代Mongoose的populate功能。以下是修正后的代码：

首先，定义包含账户名称的返回类型（TypeScript规范写法）：

// 在service-loans.ts中新增
interface InvoiceWithAccountName extends Omit<Invoice, 'accountId'> {
  accountId: {
    _id: ObjectId;
    name: string;
  };
}

然后修改getInvoices函数：

import { Invoice } from "../models/invoice";
import { MongoClient, ObjectId } from "mongodb";
import logger from "../lib/logging/logger";

const url: string = process.env["MONGODB_URL"] || "";
const dbName: string = process.env["MONGODB_DATABASE"] || "";
const client = new MongoClient(url);

// 新增返回类型定义
interface InvoiceWithAccountName extends Omit<Invoice, 'accountId'> {
  accountId: {
    _id: ObjectId;
    name: string;
  };
}

const getInvoices = async (): Promise<InvoiceWithAccountName[] | undefined> => {
  try {
    await client.connect();
    const db = client.db(dbName);
    const invoiceCollection = db.collection<Invoice>("invoice");
    
    const invoices = await invoiceCollection
      .aggregate<InvoiceWithAccountName>([
        // 关联accounts集合（假设账户集合名为accounts）
        {
          $lookup: {
            from: "accounts", // 账户集合的实际名称
            localField: "accountId", // Invoice中用于关联的字段
            foreignField: "_id", // 账户集合中匹配的主键
            as: "accountInfo" // 关联结果存储的临时字段
          }
        },
        // 将关联结果的数组转为单个对象（一对一关联场景）
        { $unwind: "$accountInfo" },
        // 投影需要的字段：发票的_id、number、createdAt，以及账户名称
        {
          $project: {
            _id: 1,
            number: 1,
            createdAt: 1,
            accountId: {
              _id: "$accountId",
              name: "$accountInfo.name"
            }
          }
        }
      ])
      .toArray();
    
    return invoices;
  } catch (error) {
    logger.error(error);
    return undefined;
  } finally {
    // 确保查询完成后关闭数据库连接，避免资源泄漏
    await client.close();
  }
};

export default { getInvoices };

解决方案二：切换到Mongoose使用populate #

如果你更习惯用populate语法，可以改用Mongoose来操作数据库：

1. 安装Mongoose依赖：

npm install mongoose

2. 定义Invoice和Account的Mongoose Schema：

// models/invoice.ts
import mongoose, { Schema, Document } from 'mongoose';
import { AccountDocument } from './account';

export interface InvoiceDocument extends Document {
  accountId: AccountDocument['_id'];
  number: string;
  invoiceDate: Date;
  amount: number;
  paymentDate: Date;
  expectedPaymentDate: Date;
  updatedAt: Date;
  createdAt: Date;
  paymentAt: Date;
  repaymentAt: Date;
  reservation: object;
  totalCosts: number;
}

const InvoiceSchema: Schema = new Schema({
  accountId: { type: Schema.Types.ObjectId, ref: 'Account', required: true },
  number: { type: String, required: true },
  invoiceDate: { type: Date, required: true },
  amount: { type: Number, required: true },
  paymentDate: Date,
  expectedPaymentDate: Date,
  updatedAt: { type: Date, default: Date.now },
  createdAt: { type: Date, default: Date.now },
  paymentAt: Date,
  repaymentAt: Date,
  reservation: Object,
  totalCosts: Number
});

export default mongoose.model<InvoiceDocument>('Invoice', InvoiceSchema);

// models/account.ts
import mongoose, { Schema, Document } from 'mongoose';

export interface AccountDocument extends Document {
  name: string;
  // 其他账户相关字段
}

const AccountSchema: Schema = new Schema({
  name: { type: String, required: true },
  // 其他字段定义
});

export default mongoose.model<AccountDocument>('Account', AccountSchema);

3. 修改service-loans.ts中的查询代码：

import Invoice from "../models/invoice";
import logger from "../lib/logging/logger";
import mongoose from 'mongoose';

const url: string = process.env["MONGODB_URL"] || "";

// 初始化Mongoose连接
mongoose.connect(url)
  .then(() => logger.info('MongoDB connected'))
  .catch(err => logger.error('MongoDB connection error', err));

const getInvoices = async () => {
  try {
    const invoices = await Invoice.find(
      {},
      { accountId: 1, number: 1, _id: 1, createdAt: 1 }
    )
    .populate({ path: 'accountId', select: 'name' })
    .lean();
    
    return invoices;
  } catch (error) {
    logger.error(error);
    return undefined;
  }
};

export default { getInvoices };

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