{"id":182043,"date":"2020-10-29T15:13:22","date_gmt":"2020-10-29T07:13:22","guid":{"rendered":"http:\/\/4563.org\/?p=182043"},"modified":"2020-10-31T23:17:07","modified_gmt":"2020-10-31T15:17:07","slug":"mongodb-%e5%af%b9%e6%9f%90%e5%88%97%e5%8e%bb%e9%87%8d%e5%90%8e%ef%bc%8c%e6%9f%a5%e8%af%a2%e8%af%a5%e5%88%97%e5%af%b9%e5%ba%94%e7%9a%84%e5%8f%a6%e5%a4%96%e4%b8%80%e5%80%bc%e6%98%af%e5%90%a6%e9%83%bd","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=182043","title":{"rendered":"MongoDB \u5bf9\u67d0\u5217\u53bb\u91cd\u540e\uff0c\u67e5\u8be2\u8be5\u5217\u5bf9\u5e94\u7684\u53e6\u5916\u4e00\u503c\u662f\u5426\u90fd\u4e3a xx"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  MongoDB \u5bf9\u67d0\u5217\u53bb\u91cd\u540e\uff0c\u67e5\u8be2\u8be5\u5217\u5bf9\u5e94\u7684\u53e6\u5916\u4e00\u503c\u662f\u5426\u90fd\u4e3a xx               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : Te11UA <\/span>  <span><i><\/i> 3<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u6570\u636e\u5f62\u5982<\/p>\n<pre><code>[ {'status':'ok','message_id': '1', 'group_id':1}, {'status':'bad','message_id': '2', 'group_id':1}, {'status':'ok','message_id': '1', 'group_id':2} ], <\/code><\/pre>\n<p>\u9700\u6c42\u662f\u8981\u5224\u65ad\u5f53\u524d\u5e93\u4e2d\u540c\u4e00 group \u7684 status \u90fd\u4e3a ok\uff0c\u6709\u4e00\u4e2a bad \u5219\u8fd4\u56de False \u3002\u7531\u4e8e\u4e0d\u592a\u719f\u6089 MongoDB\uff0c\u4f7f\u7528\u4e86\u6bd4\u8f83\u96be\u770b\u7684\u505a\u6cd5\uff1a<\/p>\n<pre><code>group_ids = db.tasks.distinct('group_id') for group_id in group_ids: ____status = db.tasks.find_one({'group_id': group_id, 'status': 'bad'}) ____return False if task else True <\/code><\/pre>\n<p>\u8bf7\u95ee\u5927\u4f6c\u4eec\uff0c\u6709\u4ec0\u4e48\u597d\u7684\u529e\u6cd5\u53ef\u4ee5\u5b8c\u6210\u8fd9\u4e2a\u9700\u6c42\u5462<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>3<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"3954773\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : catinsides <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             &#8220;`<br \/>aggregate([<br \/> {<br \/> $group: {<br \/> _id: &#8216;$group_id&#8217;,<br \/> statusAry: {<br \/> $addToSet: &#8216;$status&#8217;<br \/> }<br \/> }<br \/> },<br \/> {<br \/> $addFields: {<br \/> len: {<br \/> $size: &#8216;$statusAry&#8217;<br \/> }<br \/> }<br \/> },<br \/> {<br \/> $addFields: {<br \/> results: {<br \/> $cond: { if: { $eq: [ &#8220;$len&#8221;, 1 ] }, then: true, else: false }<br \/> }<br \/> }<br \/> }<br \/>])<br \/>&#8220;`                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3954774\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : catinsides <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div> <img decoding=\"async\" src=\"http:\/\/4563.org\/wp-content\/uploads\/2020\/10\/62e721e4gw1et01xu1r3aj200k00k3y9.jpg\" rel=\"noreferrer\" referrerpolicy=\"no-referrer\" alt=\"MongoDB \u5bf9\u67d0\u5217\u53bb\u91cd\u540e\uff0c\u67e5\u8be2\u8be5\u5217\u5bf9\u5e94\u7684\u53e6\u5916\u4e00\u503c\u662f\u5426\u90fd\u4e3a xx\"> \u6ca1\u5224\u65ad\u5168\u662f bad                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3954775\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : lithiumii <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4f60\u8fd9\u4e2a\u662f pymongo \uff1f\u5982\u679c\u53ef\u4ee5\u5728 py \u91cc\u505a\u7684\u8bdd<\/p>\n<p>group_ids = db.tasks.distinct(&#8216;group_id&#8217;)<br \/>bad_ids = db.tasks.find({&#8216;status&#8217;:&#8217;bad&#8217;}).distinct(&#8216;group_id&#8217;)<br \/>good_ids = [x for x in group_ids if x not in bad_ids]<\/p>\n<p>\u6216\u8005\u7528 MongoDB \u7684 aggregation                                                            <\/p><\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>MongoDB \u5bf9\u67d0\u5217\u53bb\u91cd\u540e\uff0c\u67e5\u8be2&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/182043"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=182043"}],"version-history":[{"count":1,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/182043\/revisions"}],"predecessor-version":[{"id":182045,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/182043\/revisions\/182045"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=182043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=182043"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=182043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}