playerMatchEventLogの確認

[dai0413]

matchフィールドエラー確認

db.playermatcheventlogs.aggregate([
  {
    $lookup: {
      from: "matches",
      localField: "match",
      foreignField: "_id",
      as: "matchDoc",
    },
  },
  {
    $match: {
      matchDoc: { $size: 0 },
    },
  },
  {
    $count: "invalidMatchCount",
  },
]);

エラーデータ削除

db.playermatcheventlogs.aggregate([
  {
    $lookup: {
      from: "matches",
      localField: "match",
      foreignField: "_id",
      as: "matchDoc",
    },
  },
  {
    $match: {
      matchDoc: { $size: 0 },
    },
  },
]).forEach(doc => {
  db.playermatcheventlogs.deleteOne({ _id: doc._id });
});