twikoo 的 mongodb 数据 转为 waline 的数据， _id 问题

[jerryc127]

你好 我在把 twikoo 的 mongodb 转为 waline 的 mongodb data 遇到一个问题
twikoo 的 _id 是存为string 格式 而 waline 的是 objectId
objectId 有限制 导致我导入评论 有些评论出现 Failed: the provided hex string is not a valid ObjectID 无法导入
应该是 objectId 要求 24 hex characters, 而 twikoo 生成的 id 并不符合
该怎么解决？

twikoo

{
  "_id": "0fe806ea4beb46819f1973fac9d344f8",
  "nick": "听雨轩",
  "mail": "[email protected]",
  "mailMd5": "2f2dc333236d17cdf545ec62a7e536bf",
  "link": "www.oyhq.top",
  "ua": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36",
  "ip": "xxxxxxxxx",
  "master": false,
  "url": "/messageboard/",
  "comment": "<p>膜拜大佬</p>\n",
  "pid": null,
  "rid": null,
  "isSpam": true,
  "created": {
    "$numberLong": "1652415537856"
  },
  "updated": {
    "$numberLong": "1652415539139"
  }
}

waline

{
  "_id": {
    "$oid": "61e82b939101390009d6b76e"
  },
  "link": "",
  "mail": "[email protected]",
  "nick": "test",
  "pid": null,
  "rid": null,
  "ua": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36 Edg/97.0.1072.62",
  "url": "/",
  "comment": "test",
  "ip": "xxxxxx",
  "insertedAt": {
    "$date": {
      "$numberLong": "1642605458767"
    }
  },
  "user_id": null,
  "status": "approved"
}

我用 nodejs 转换

person.forEach(function(e) {
  e._id = { "$oid": e._id }

  e.insertedAt = {
    "$date": {
      "$numberLong": e.created.$numberLong
    }
  }

  if (e.isSpam === true) {
    e.status = "waiting"
  } else {
    e.status = "approved"
  }

  if (e.master === true) {
    e.user_id = 'xxxxx'
  } else {
    e.user_id = 'null'
  }

  delete e.isSpam
  delete e.master
  delete e.created
  delete e.updated
  delete e.mailMd5
});

然后通过 mongoimport 导入

[lizheming]

已私聊沟通解决，Twikoo 自己生成 md5 的 id 无法直接作用到 mongodb 的 objectId 上，所以需要自己再重新映射一下。

[jerryc127]

想问下如何映射？我对这类不太熟悉

[lizheming]

https://github.com/walinejs/waline/blob/main/packages/server/src/controller/db.js#L7-L23 可以参考下这块的代码