{"id":159310,"date":"2020-09-23T06:58:40","date_gmt":"2020-09-22T22:58:40","guid":{"rendered":"http:\/\/4563.org\/?p=159310"},"modified":"2020-09-23T06:58:40","modified_gmt":"2020-09-22T22:58:40","slug":"mongoose-%e8%81%9a%e5%90%88%e7%ae%a1%e9%81%93%e6%9f%a5%e8%af%a2%ef%bc%8c-list-%e4%b8%ad%e7%9a%84%e5%ad%90%e5%af%b9%e8%b1%a1%e5%a6%82%e4%bd%95%e5%85%b3%e8%81%94%ef%bc%9f","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=159310","title":{"rendered":"mongoose \u805a\u5408\u7ba1\u9053\u67e5\u8be2\uff0c list \u4e2d\u7684\u5b50\u5bf9\u8c61\u5982\u4f55\u5173\u8054\uff1f"},"content":{"rendered":"
\n
\n
\n

mongoose \u805a\u5408\u7ba1\u9053\u67e5\u8be2\uff0c list \u4e2d\u7684\u5b50\u5bf9\u8c61\u5982\u4f55\u5173\u8054\uff1f <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : ideacco <\/span> <\/i> 0<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

RT\uff0c\u4f7f\u7528 mongoose\uff0c\u6709\u5982\u4e0b\u4e24\u4e2a\u6570\u636e\uff0c\u6211\u60f3\u628a\u4ea7\u54c1\u53c2\u6570\u636e\u8868\uff0c\u5bf9\u5e94\u7684\u4ea7\u54c1\u67e5\u8be2\u51fa\u6765\uff0c\u6211\u76ee\u524d\u53ea\u4f1a\u67e5\u8be2\u4e00\u7ea7\u7684\uff0c\u5728 Array \u91cc\u9762\u5305\u88f9\u7684\u6570\u636e\u5c31\u4e0d\u77e5\u9053\u600e\u4e48\u53d6\u51fa\u6765\u4e86\uff0c\u770b\u4e86\u4e00\u5929\u7684\u5b98\u7f51\u6587\u6863\u4e5f\u6ca1\u770b\u660e\u767d\u2026\u2026\u60ed\u6127\u60ed\u6127\uff0c\u6c42\u5927\u795e\u7ed9\u6307\u4e2a\u9053\u5427\u3002<\/p>\n

\u793a\u4f8b\u6570\u636e\u5982\u4e0b\uff1a<\/p>\n

\/\/ \u4ea7\u54c1\u6570\u636e\u8868 product {     \"uid\": \"5f460572f639b62baa839baa\",     \"productCounts\": 17,     \"productItems\": [{             \"is_variants\": false,             \"totalVariants\": 1,             \"id\": 12345 \"tetle\": \"\u82f9\u679c\"         },         {             \"is_variants\": false,             \"totalVariants\": 1,             \"id\": 23456 \"tetle\": \"\u897f\u74dc\"         },         {             \"is_variants\": false,             \"totalVariants\": 1,             \"id\": 56789 \"tetle\": \"\u8354\u679d\"         },         ...     ]  }  \/\/ \u4ea7\u54c1\u53c2\u6570\u6570\u636e\u8868 options  {        \"uid\": \"5f460572f639b62baa839baa\",     \"pid\":23456,     \"ditch\": \"weixin\",     \"postcode\": 518000,     \"is_pay\": true } <\/code><\/pre>\n
\u6211\u60f3\u8981\u7684\u6570\u636e\u5982\u4e0b<\/p>\n
{     \"is_variants\": false,     \"totalVariants\": 1,     \"id\": 12345,     \"tetle\": \"\u82f9\u679c\",     \"options\": {         \"uid\": \"5f460572f639b62baa839baa\",         \"pid\": 23456,         \"ditch\": \"weixin\",         \"postcode\": 518000,         \"is_pay\": true     } } <\/code><\/pre>\n<\/p><\/div>\n
 \u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (7<\/span>)        <\/div>\n
 <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
     \u8cc7\u6df1\u5927\u4f6c : ScaredHeart <\/span>  <\/div>\n
     <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                 \u5148\u901a\u8fc7[$unwind]( https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/unwind\/index.html)\u628a\u6570\u7ec4\u4e2d\u7684\u5143\u7d20\u62c6\u5206\uff0c[$project]( https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/project\/index.html)\u4fee\u526a\u4e0b\u6570\u636e\uff0c\u5bf9 uid \u5b57\u6bb5[$lookup]( https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/lookup\/index.html)\u6765\u5173\u8054 options \u8868(uid \u662f objectId \u7684\u8bdd                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
     \u8cc7\u6df1\u5927\u4f6c : wkzq <\/span>  <\/div>\n
     <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                 ““
    db.getCollection(’emotes’).aggregate([
    {$match: {“productItems.id”: 23456}},
    {$unwind: “$productItems”},
    {$match: {“productItems.id”: 23456}},
    {
     $lookup:
     {
     from: “options”,
     localField: “productItems.id”,
     foreignField: “pid”,
     as: “options”
     }
    },
    {$unwind: “$options”},
    {
     $project: {
     “is_variants”: “$productItems.is_variants”,
     “totalVariants”: “$productItems.totalVariants”,
     “id”: “$productItems.id”,
     “tetle”: “$productItems.tetle”,
     “options”: 1
     }
    }
    ])
    ““
    \u9700\u8981\u7ed9`productItems.id`\u52a0\u7d22\u5f15                                                            <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
     \u8cc7\u6df1\u5927\u4f6c : wkzq <\/span>  <\/div>\n
     <\/i>            <\/span> <\/div>\n<\/p><\/div>\n
                                                                 \u56de\u590d\u4e0d\u652f\u6301 md, \u7528\u8fd9\u4e2a\u5427
    https:\/\/gist.github.com\/fefine\/d5fd3d60688d05887316ae25322f50f5