<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                ## **1、MongoDB 聚合管道(Aggregation Pipeline)** 使用聚合管道可以對集合中的文檔進行變換和組合。 實際項目:表關聯查詢、數據的統計。 MongoDB 中使用 db.COLLECTION\_NAME.aggregate(\[{\<stage\>},...\]) 方法 來構建和使用聚合管道。先看下官網給的實例,感受一下聚合管道的用法。 ![](https://box.kancloud.cn/f0b424dc789655a5e0730fd87be9940c_1161x819.png) ## **2、MongoDB Aggregation 管道操作符與表達式** | 管道操作符 | Description | | --- | --- | | $project | 增加、刪除、重命名字段 | | $match | 條件匹配。只滿足條件的文檔才能進入下 一階段 | | $limit | 限制結果的數量 | | $skip | 跳過文檔的數量 | | $sort | 條件排序。 | | $group | 條件組合結果 統計 | | $lookup | $lookup 操作符 用以引入其它集合的數 據 (表關聯查詢) | **SQL 和 NOSQL 對比:** | WHERE | $match | | --- | --- | | GROUP BY | $group | | HAVING | $match | | SELECT | $project | | ORDER BY | $sort | | LIMIT | $limit | | SUM() | $sum | | COUNT() | $sum | | join | $lookup | **管道表達式:** 管道操作符作為“鍵”,所對應的“值”叫做管道表達式。 例如{$match:{status:"A"}},$match 稱為管道操作符,而 status:"A"稱為管道表達式, 是管道操作符的操作數(Operand)。 每個管道表達式是一個文檔結構,它是由字段名、字段值、和一些表達式操作符組成的。 | 常用表達式操作符 | Description | | --- | --- | | $addToSet | 將文檔指定字段的值去重 | | $max | 文檔指定字段的最大值 | | $min | 文檔指定字段的最小值 | | $sum | 文檔指定字段求和 | | $avg | 文檔指定字段求平均 | | $gt | 大于給定值 | | $lt | 小于給定值 | | $eq | 等于給定值 | ## **3、 數據模擬** ``` db.order.insert({"order_id":"1","uid":10,"trade_no":"111","all_price":100,"all_num":2}) db.order.insert({"order_id":"2","uid":7,"trade_no":"222","all_price":90,"all_num":2}) db.order.insert({"order_id":"3","uid":9,"trade_no":"333","all_price":20,"all_num":6}) db.order_item.insert({"order_id":"1","title":"商品鼠標 1","price":50,num:1}) db.order_item.insert({"order_id":"1","title":"商品鍵盤 2","price":50,num:1}) db.order_item.insert({"order_id":"1","title":"商品鍵盤 3","price":0,num:1}) db.order_item.insert({"order_id":"2","title":"牛奶","price":50,num:1}) db.order_item.insert({"order_id":"2","title":"酸奶","price":40,num:1}) db.order_item.insert({"order_id":"3","title":"礦泉水","price":2,num:5}) db.order_item.insert({"order_id":"3","title":"毛巾","price":10,num:1}) ``` ![](https://box.kancloud.cn/1f60402fc6033bde3e7f2e7461638d4d_1273x314.png) ## **4、 $project** 修改文檔的結構,可以用來重命名、增加或刪除文檔中的字段。 要求查找 order 只返回文檔中 trade\_no 和 all\_price 字段 ``` db.order.aggregate([ { $project:{ trade_no:1, all_price:1 } } ]) ``` ![](https://box.kancloud.cn/d224a5af853d09ff2b8b5340ccdd5214_1076x218.png) ## **5、 $match** **作用** 用于過濾文檔。用法類似于 find() 方法中的參數。 ``` db.order.aggregate([ { $project:{ trade_no:1, all_price:1 } }, { $match:{"all_price":{$gte:90}} } ] ) ``` ![](https://box.kancloud.cn/225b26a3b1d0c297d6cac9aef96d6d62_1121x294.png) ## **6、 $group** 將集合中的文檔進行分組,可用于統計結果。 統計每個訂單的訂單數量,按照訂單號分組 ``` db.order_item.aggregate( [ { $group: {_id: "$order_id", total: {$sum: "$num"}} } ] ) ``` ![](https://box.kancloud.cn/77b9852088e914c63c24804adbaa8062_1070x287.png) ## **7、 $sort** 將集合中的文檔進行排序。 ``` db.order.aggregate([ { $project:{ trade_no:1, all_price:1 } }, { $match:{"all_price":{$gte:90}} }, { $sort:{"all_price":-1} } ]) ``` ![](https://box.kancloud.cn/35086603a389f9490491280d3a7bcb7a_1058x331.png) ![](https://box.kancloud.cn/029bc6dfd138ba0dd69488f1621739e2_1069x377.png) ## **8、 $limit** ``` db.order.aggregate([ { $project:{ trade_no:1, all_price:1 } }, { $match:{"all_price":{$gte:90}} }, { $sort:{"all_price":-1} }, { $limit:1 } ]) ``` ![](https://box.kancloud.cn/b596a4656a61c1ac4d39ccd941f19820_980x357.png) ## **9、 $skip** ``` db.order.aggregate([ { $project:{ trade\_no:1, all_price:1 } }, { $match:{"all_price":{$gte:90}} }, { $sort:{"all_price":-1} }, { $skip:1 } ]) ``` ![](https://box.kancloud.cn/4660665c901ef99e91e66d7ba4793adc_1049x382.png) ## **10、 $lookup 表關聯** ``` db.order.aggregate([ { $lookup: { from: "order_item", localField: "order_id", foreignField: "order_id", as: "items" } } ]) { "_id": ObjectId("5b743d8c2c327f8d1b360540"), "order_id": "1", "uid": 10, "trade_no": "111", "all_price": 100, "all_num": 2, "items": [ { "_id": ObjectId("5b743d9c2c327f8d1b360543"), "order_id": "1", "title": "商品鼠標 1", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da12c327f8d1b360544"), "order_id": "1", "title": "商品鍵盤 2", "price": 50, "num": 1 }, { "_id": ObjectId("5b74f457089f78dc8f0a4f3b"), "order_id": "1", "title": "商品鍵盤 3", "price": 0, "num": 1 } ] } { "_id": ObjectId("5b743d902c327f8d1b360541"), "order_id": "2", "uid": 7, "trade_no": "222", "all_price": 90, "all_num": 2, "items": [ { "_id": ObjectId("5b743da52c327f8d1b360545"), "order_id": "2", "title": "牛奶", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da92c327f8d1b360546"), "order_id": "2", "title": "酸奶", "price": 40, "num": 1 } ] } { "_id": ObjectId("5b743d962c327f8d1b360542"), "order_id": "3", "uid": 9, "trade_no": "333", "all_price": 20, "all_num": 6, "items": [ { "_id": ObjectId("5b743dad2c327f8d1b360547"), "order_id": "3", "title": "礦泉水", "price": 2, "num": 5 }, { "_id": ObjectId("5b743dff2c327f8d1b360548"), "order_id": "3", "title": "毛巾", "price": 10, "num": 1 } ] } db.order.aggregate([ { $lookup: { from: "order_item", localField: "order_id", foreignField: "order_id", as: "items" } }, { $match:{"all_price":{$gte:90}} } ]) { "_id": ObjectId("5b743d8c2c327f8d1b360540"), "order_id": "1", "uid": 10, "trade_no": "111", "all_price": 100, "all_num": 2, "items": [ { "_id": ObjectId("5b743d9c2c327f8d1b360543"), "order_id": "1", "title": "商品鼠標 1", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da12c327f8d1b360544"), "order_id": "1", "title": "商品鍵盤 2", "price": 50, "num": 1 }, { "_id": ObjectId("5b74f457089f78dc8f0a4f3b"), "order_id": "1", "title": "商品鍵盤 3", "price": 0, "num": 1 } ] } { "_id": ObjectId("5b743d902c327f8d1b360541"), "order_id": "2", "uid": 7, "trade_no": "222", "all_price": 90, "all_num": 2, "items": [ { "_id": ObjectId("5b743da52c327f8d1b360545"), "order_id": "2", "title": "牛奶", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da92c327f8d1b360546"), "order_id": "2", "title": "酸奶", "price": 40, "num": 1 } ] } db.order.aggregate([ { $lookup: { from: "order\_item", localField: "order_id", foreignField: "order_id", as: "items" } }, { $project:{ trade_no:1, all\_price:1,items:1 } }, { $match:{"all\_price":{$gte:90}} }, { $sort:{"all_price":-1} }, ]) { "_id": ObjectId("5b743d8c2c327f8d1b360540"), "trade_no": "111", "all_price": 100, "items": [ { "_id": ObjectId("5b743d9c2c327f8d1b360543"), "order_id": "1", "title": "商品鼠標 1", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da12c327f8d1b360544"), "order_id": "1", "title": "商品鍵盤 2", "price": 50, "num": 1 }, { "_id": ObjectId("5b74f457089f78dc8f0a4f3b"), "order_id": "1", "title": "商 品鍵盤 3", "price": 0, "num": 1 } ] } { "_id": ObjectId("5b743d902c327f8d1b360541"), "trade_no": "222", "all_price": 90, "items": [ { "_id": ObjectId("5b743da52c327f8d1b360545"), "order_id": "2", "title": "牛奶", "price": 50, "num": 1 }, { "_id": ObjectId("5b743da92c327f8d1b360546"), "order_id": "2", "title": "酸奶", "price": 40, "num": 1 } ] } ``` ![](https://box.kancloud.cn/8a27afeb5815fc418a5549161bbfa6e4_1307x492.png)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看