NodeJS/NextJS使用mongoose连接MongoDB数据库

.env.production配置连接地址

MONGO_DB=mongodb://UserName:Password@127.0.0.1/notebooks-production?authSource=admin

dbConnector.ts连接工具类

import mongoose from "mongoose";

async function dbConnector() {
  let connection = mongoose.createConnection();
  // @ts-ignore
  let client = await connection.openUri(process.env.MONGO_DB, {
    maxPoolSize: 100,
  });
  return client;
}

export default dbConnector;

测试

export async function GET(request: NextRequest) {
  const db = await dbConnector();
  let idQoo;
  do {
    idQoo = idBuilder();
  } while (await db.collection("dUser").findOne({ idQoo }));
  let result = await db.collection("dUser").insertOne({
    id: nanoid(),
    idQoo,
    idCard: "",
    password: "",
    motto: "",
    name: "",
    nickname: "",
    smsCode: "",
    smsCodeTime: "",
    token: "",
    mobile: "",
    email: "",
    avatar: "",
    linkQQ: "",
    linkWechat: "",
    createTime: moment().format("YYYY-MM-DD HH:mm:ss"),
    updateTime: moment().format("YYYY-MM-DD HH:mm:ss"),
  });
  db.close();
  return NextResponse.json({ success: true, data: result });
}