javascript - 如何使用 node.js 将 _bsontype objectID 值转换为 string/objectID 以插入到 mongoDB 中

Question

我有一个 JSON 文件，其中包含如下所示的对象。

{
    userID: {"_bsontype":"ObjectID","id":{"0":92,"1":237,"2":216,"3":42,"4":254,"5":178,"6":68,"7":182,"8":208,"9":254,"10":51,"11":64}},
    userName: "abc"
}

注意:还有一些嵌套字段，例如 userID。

尝试使用批量插入导入到 MongoDB 时出现错误

UnhandledPromiseRejectionWarning: Error: object [{"_bsontype":"ObjectID","id":{"0":92,"1":237,"2":216,"3":42,"4":254,"5":178,"6":68,"7":182,"8":208,"9":254,"10":51,"11":64}}] is not a valid ObjectId

如何将 userID 转换为 objectID/字符串？例如 ObjectId("5d1de1bab90f8bf15f58df3f") 或 "5d1de1bab90f8bf15f58df3f"

数据库中的预期输出:

{
    userID: ObjectId("5d1de1bab90f8bf15f58df3f"),
    userName: "abc"
}

或

{
    userID: "5d1de1bab90f8bf15f58df3f",
    userName: "abc"
}

Answer 1

谢谢罗达姆，

你让我走上了正轨。只是为了它。这是我的效用函数。冗长但有效。

const { ObjectID } = require( 'mongodb' )

  toObjectID: function ( object ) {
    let hexString = ''
    Object.values(object.id).forEach(elem =>{
      const result = elem.toString(16)
      if(result.length === 2) {
        hexString += result
      } else {
        hexString += "0" + result
      }
    })
    const id = new ObjectID(hexString)
    return id
  }