主页 / user-2671206

D Singh's questions

Martin Hope
D Singh
Asked: 2024-12-02 19:55:14 +0800 CST
  • 5

我有两个集合。用户和课程

用户集合

  [{
    "_id": "11111",
    "name": "john",
  },
  {
    "_id": "11112",
    "name": "smith",
    
  }]

课程集合

[{
    "_id": "00011",
    "user_id": "11111",
    "location_id": "9999",
  },
  {
    "_id": "00012",
    "user_id": "11111",
    "location_id": "8888",
    
  },
  {
    "_id": "00013",
    "user_id": "11111",
    "location_id": "7777",
  },
  {
    "_id": "00014",
    "user_id": "11112",
    "location_id": "7777",
  }]

如果我应用区域 ID 7777 的过滤器，那么我希望得到以下输出。如果我应用区域 ID 7777 和 8888，我希望得到相同的输出。所以基本上，我想要所有用户区域，如果它至少匹配一个区域 ID。如果没有区域 ID 过滤器，我会得到正确的响应

预期结果：

[
    {
      "_id": "11111",
      "name": "john",
      "regions": [
        {
          "_id": "00011",
          "user_id": "11111",
          "location_id": "9999"
        },
        {
          "_id": "00012",
          "user_id": "11111",
          "location_id": "8888"
        },
        {
          "_id": "00013",
          "user_id": "11111",
          "location_id": "7777"
        }
      ]
    },
    {
      "_id": "11112",
      "name": "smith",
      "regions": [
        {
          "_id": "00014",
          "user_id": "11112",
          "location_id": "7777"
        }
      ]
    }
]

以下是我的汇总查询

db.user.aggregate([
  {
    "$match": {}
  },
  {
    "$lookup": {
      "from": "region",
      "localField": "_id",
      "foreignField": "user_id",
      "as": "regions"
    }
  },
  {
    "$addFields": {
      "regions": {
        "$filter": {
          input: "$regions",
          as: "region",
          cond: {
            $in: [
              "$$region.location_id",
              [
                "7777"
              ]
            ]
          }
        }
      }
    }
  }
])

实际结果（如果我应用过滤器region_id：7777，我将获得以下结果）

[
    {
      "_id": "11111",
      "name": "john",
      "regions": [
        {
          "_id": "00013",
          "user_id": "11111",
          "location_id": "7777"
        }
      ]
    },
    {
      "_id": "11112",
      "name": "smith",
      "regions": [
        {
          "_id": "00014",
          "user_id": "11112",
          "location_id": "7777"
        }
      ]
    }
]
mongodb
Martin Hope
D Singh
Asked: 2024-10-25 16:33:18 +0800 CST
  • 5

我正在实施 JOI 验证，并希望通过 JOI 验证逗号分隔的字符串。此字符串仅包含特定文本字符串，如“admin”、“client”、“customer”、“user”。例如，请检查以下内容。我可以通过 JavaScript 验证这一点，但我想通过 JOI 进行验证

function checkString(perm)
{
    const a = ['admin','client', 'customer', 'user'];
     
    const check = perm.split(",");
     
    if(!check.every(val => a.includes(val)))
    {
            return false;
      }
     
      return true;
}
        
//alert(checkString('admin,client,customer'))            //true
//alert(checkString('customer'))                         //true
//alert(checkString('admin,client,buyer'))               //false
//alert(checkString('buyer'))                            //false
//alert(checkString('admin,client,customer,buyer'))      //false

javascript