{"id":5005,"date":"2019-05-01T13:31:09","date_gmt":"2020-04-22T06:37:42","guid":{"rendered":"https:\/\/vip.fxxkpython.com\/?p=5005"},"modified":"2021-08-31T03:17:04","modified_gmt":"2021-08-30T19:17:04","slug":"1f2e24542d","status":"publish","type":"post","link":"https:\/\/vip.fxxkpython.com\/?p=5005","title":{"rendered":"python\u722c\u866b27 | \u5f53Python\u9047\u5230MongoDB\u7684\u65f6\u5019\uff0c\u5b58\u50a8av\u5973\u4f18\u7684\u6570\u636e\u53d8\u5f97\u5982\u6b64\u987a\u6ed1\u723d\uff5e"},"content":{"rendered":"
\n

\n

\u4e0a\u6b21<\/p>\n

\n

\u6211\u4eec\u77e5\u9053\u4e86\u600e\u4e48\u64cd\u4f5c MySQL \u6570\u636e\u5e93<\/p>\n

\n

python\u722c\u866b26 | \u628a\u6570\u636e\u722c\u53d6\u4e0b\u6765\u4e4b\u540e\u5c31\u5b58\u50a8\u5230\u4f60\u7684MySQL\u6570\u636e\u5e93\u3002<\/a><\/p>\n

\n

MySQL \u6709\u4e9b\u5e74\u5934\u4e86<\/p>\n

\n

\u5f00\u6e90\u53c8\u6210\u719f\u53c8\u725b\u903c<\/p>\n

\n

\u6240\u4ee5\u73b0\u5728\u5f88\u591a\u4f01\u4e1a\u90fd\u5728\u4f7f\u7528 MySQL<\/p>\n

\n

MySQL \u662f<\/span>\u5173\u7cfb\u578b\u6570\u636e\u5e93<\/span><\/p>\n

\n

\u5176\u5b9e\u5f53\u524d\u4e3b\u6d41\u7684\u6570\u636e\u5e93<\/p>\n

\n

\u4f8b\u5982<\/p>\n

\n

Oracle\u3001DB2\u3001PostgreSQL\u3001Microsoft SQL Server \u7b49\u7b49<\/p>\n

\n

\u90fd\u662f\u5173\u7cfb\u578b\u6570\u636e\u5e93<\/p>\n

\n

\u8fd9\u6837\u7684\u8bdd<\/p>\n

\n

\u5b83\u4eec\u53ef\u4ee5\u5728\u6570\u636e\u8868\u4e4b\u95f4\u5efa\u7acb\u7d22\u5f15\u3001\u7ea6\u675f<\/p>\n

\n

\u8fdb\u884c\u5173\u8054<\/p>\n

\n

\u8ba9\u8868\u4e0e\u8868\u4e4b\u95f4\u4ea7\u751f\u8054\u7cfb<\/p>\n

\n

\u53ef\u4ee5\u8ba9\u6570\u636e\u91cd\u590d\u5229\u7528\uff0c\u4e0d\u4f1a\u6d6a\u8d39<\/p>\n

\n

\"python\u722c\u866b27<\/p>\n

\n

\u00a0\u76f8\u5bf9\u5e94\u7684\u5c31\u662f<\/p>\n

\n

\u975e\u5173\u7cfb\u578b\u6570\u636e\u5e93<\/span><\/p>\n

\u00a0<\/span><\/p>\n

NoSQL<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

\u5b83\u4e0d\u7528\u4f20\u7edf\u7684 SQL \u8bed\u53e5\u8fdb\u884c\u64cd\u4f5c<\/p>\n

\n

\u800c\u662f\u6709\u81ea\u5df1\u7684\u72ec\u7279\u7684\u6570\u636e\u5b58\u50a8\u65b9\u5f0f<\/p>\n

\n

\u53ef\u4ee5\u8bf4\u76f8\u5f53\u65b9\u4fbf<\/p>\n

\n

NOSQL \u7684\u7ecf\u5178\u4ee3\u8868\u6570\u636e\u5e93\u5c31\u662f\u6211\u4eec\u4eca\u5929\u8981\u8bf4\u7684<\/p>\n

\n

MongoDB<\/strong><\/p>\n

\u00a0<\/strong><\/p>\n

\u7531 C++ \u5199\u7684\u00a0\u6587\u6863\u5b58\u50a8 \u5f62\u5f0f\u7684\u975e\u5173\u7cfb\u6570\u636e\u5e93<\/p>\n

\n

\u5982\u679c\u4f60\u5bf9 JSON \u6709\u6240\u4e86\u89e3<\/p>\n

\n

\u90a3\u4e48 MongoDB \u5bf9\u4f60\u6765\u8bf4so easy<\/p>\n

\n

\"python\u722c\u866b27<\/p>\n

\n

\u7531\u4e8e\u5b83\u662f\u57fa\u4e8e\u5185\u5b58\u5bf9\u6570\u636e\u8fdb\u884c\u5904\u7406\u7684<\/p>\n

\n

\u6240\u4ee5\u8bfb\u5199\u901f\u5ea6\u76f8\u5bf9\u66f4\u9ad8\u4e00\u4e9b<\/p>\n

\n

\u597d\u4e86<\/p>\n

\n

\u5439\u4e86\u4e00\u6ce2 MongoDB \u7684\u725b\u903c\u4e4b\u540e<\/p>\n

\n

\"python\u722c\u866b27<\/p>\n

\n

\u63a5\u4e0b\u6765\u5c0f\u5e05b\u5c31\u6765\u8ddf\u4f60\u8bf4\u8bf4<\/p>\n

\n

\u600e\u4e48\u73a9\u00a0MongoDB<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u63a5\u4e0b\u6765\u5c31\u662f<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u5b66\u4e60 python \u7684\u6b63\u786e\u59ff\u52bf<\/span><\/p>\n

\n

\"python\u722c\u866b27<\/p>\n

\n

\u6211\u4eec\u5148\u6765\u770b\u770b\u8fd9\u6837\u7684\u6570\u636e<\/p>\n

\n\n\n\n\n\n\n\n\n\n
name<\/span><\/th>\nquantity<\/span><\/th>\nsize<\/span><\/th>\nstatus<\/span><\/th>\ntags<\/span><\/th>\nrating<\/span><\/th>\n<\/tr>\n<\/thead>\n
journal<\/span><\/td>\n25<\/span><\/td>\n14×21,cm<\/span><\/td>\nA<\/span><\/td>\nbrown, lined<\/span><\/td>\n9<\/span><\/td>\n<\/tr>\n
notebook<\/span><\/td>\n50<\/span><\/td>\n8.5×11,in<\/span><\/td>\nA<\/span><\/td>\ncollege-ruled,perforated<\/span><\/td>\n8<\/span><\/td>\n<\/tr>\n
paper<\/span><\/td>\n100<\/span><\/td>\n8.5×11,in<\/span><\/td>\nD<\/span><\/td>\nwatercolor<\/span><\/td>\n10<\/span><\/td>\n<\/tr>\n
planner<\/span><\/td>\n75<\/span><\/td>\n22.85×30,cm<\/span><\/td>\nD<\/span><\/td>\n2019<\/span><\/td>\n10<\/span><\/td>\n<\/tr>\n
postcard<\/span><\/td>\n45<\/span><\/td>\n10x,cm<\/span><\/td>\nD<\/span><\/td>\ndouble-sided,white<\/span><\/td>\n2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uff08\u6765\u81ea mongodb \u5b98\u65b9\u4f8b\u5b50\uff09<\/p>\n

\n

\u6709\u4e9b\u5b57\u6bb5\u91cc\u9762\u5305\u542b\u591a\u4e2a\u4fe1\u606f<\/p>\n

\n

\u5982\u679c\u6309\u4f20\u7edf\u7684 SQL \u7684\u8bdd<\/p>\n

\n

\u67e5\u8be2\u8d77\u6765\u6bd4\u8f83\u9ebb\u70e6<\/p>\n

\n

\u800c\u4e14\u9700\u8981\u521b\u5efa\u591a\u5f20\u8868\u8fdb\u884c\u5173\u8054<\/p>\n

\n

\u800c\u7528\u6587\u6863\u683c\u5f0f\u5b58\u50a8\u7684\u8bdd\u5c31\u53ef\u4ee5\u4f7f\u7528\u8fd9\u6837\u7684\u683c\u5f0f\u8868\u793a<\/p>\n

\n

\n
{\n<\/span><\/code> \"name\"<\/span>: \"notebook\"<\/span>,\n<\/span><\/code> \"qty\"<\/span>: 50<\/span>,\n<\/span><\/code> \"rating\"<\/span>: [ { \"score\"<\/span>: 8<\/span> }, { \"score\"<\/span>: 9<\/span> } ],\n<\/span><\/code> \"size\"<\/span>: { \"height\"<\/span>: 11<\/span>, \"width\"<\/span>: 8.5<\/span>, \"unit\"<\/span>: \"in\"<\/span> },\n<\/span><\/code> \"status\"<\/span>: \"A\"<\/span>,\n<\/span><\/code> \"tags\"<\/span>: [ \"college-ruled\"<\/span>, \"perforated\"<\/span>]\n<\/span><\/code>}<\/span><\/code><\/pre>\n<\/section>\n
\n
\n
\u662f\u4e0d\u662f\u5f88\u7b80\u5355\u54a7<\/p>\n
\n
\u90a3\u4e48\u63a5\u4e0b\u6765\u5c0f\u5e05b\u5c31\u5e26\u4f60\u4f7f\u7528 python \u6765\u64cd\u4f5c MangoDB \u5427<\/p>\n
\n
\u771f\u9999\u5047\u8bbe<\/span><\/p>\n
\n
\u672c\u6587\u5047\u8bbe\u4f60\u7684\u64cd\u4f5c\u7cfb\u7edf\u5df2\u7ecf\u5b89\u88c5\u597d MangoDB \u4e86<\/p>\n
\u5982\u679c\u4f60\u8fd8\u6ca1\u5b89\u88c5\u7684\u8bdd<\/p>\n
\u53ef\u4ee5\u5230\u4ee5\u4e0b\u94fe\u63a5\u8fdb\u884c\u4e0b\u8f7d\u5b89\u88c5<\/p>\n
\n
https:\/\/docs.mongodb.com\/manual\/installation\/?jmp=footer&_ga=2.246611149.899311115.1556631996-38380112.1556631995<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\u5f53\u4f60\u5b89\u88c5\u5b8c\u4e4b\u540e<\/p>\n
\n
\u542f\u52a8 mongodb<\/p>\n
\n
\u7136\u540e\u8f93\u5165 mongo \u5c31\u53ef\u4ee5\u64cd\u4f5c MongoDB \u4e86<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\u597d\u4e86\u597d\u4e86<\/p>\n
\n
\u6211\u4eec\u4f7f\u7528 python \u4ee3\u7801\u6765\u64cd\u4f5c\u4e00\u4e0b\u5427<\/p>\n
\n
\u8fd9\u6b21\u6211\u4eec\u9700\u8981\u4e00\u4e2a\u5e93<\/p>\n
\n
Pymongo<\/p>\n
\n
\n
from<\/span> pymongo import<\/span> MongoClient<\/span><\/code><\/pre>\n<\/section>\n
\n
\u8fde\u63a5\u5230\u4f60\u7684 MongoDB<\/p>\n
\n
\n
conn<\/span> = MongoClient('mongodb:\/\/localhost:27017\/'<\/span>)<\/span><\/code><\/pre>\n<\/section>\n
\n
27017 \u662f\u4f60\u7684\u00a0MongoDB \u7684\u9ed8\u8ba4\u7aef\u53e3<\/span><\/p>\n
\u00a0<\/span><\/p>\n
\u521b\u5efa\u4e00\u4e2a avIdol \u6570\u636e\u5e93\uff0c\u5982\u679c mongodb \u6ca1\u6709\u4f1a\u81ea\u884c\u521b\u5efa<\/p>\n
\n
\n
db<\/span> = conn.avIdol<\/span><\/code><\/pre>\n<\/section>\n
\n
\u5f80\u6570\u636e\u5e93\u63d2\u5165\u4e00\u6761\u6570\u636e<\/p>\n
\n
\n
db.col.insert({\"name\"<\/span>: '\u6ce2\u591a\u91ce\u7d50\u8863'<\/span>, 'bwh'<\/span>: '{ \"b\": 90, \"w\": 59, \"h\": 85}'<\/span> , 'age'<\/span>: 30<\/span>})<\/span><\/code><\/pre>\n<\/section>\n
\u200d<\/span><\/p>\n
\u8fd0\u884c\u4e00\u4e0b<\/p>\n
\n
\u6ca1\u62a5\u4ec0\u4e48\u9519<\/p>\n
\n
\u63a5\u7740\u6211\u4eec\u4f7f\u7528<\/p>\n
\n
print(db.col.find_one())<\/p>\n
\n
\u6765\u67e5\u8be2\u4e00\u4e0b\u662f\u5426\u63d2\u5165\u6570\u636e\u4e86<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\u53ef\u4ee5\u770b\u5230<\/p>\n
\n
\u6570\u636e\u63d2\u5165\u6210\u529f<\/p>\n
\n
\u6765\u4e2a\u6279\u91cf\u63d2\u5165\u5427<\/p>\n
\n
\n
db.col.insert([\n<\/span><\/code>    {\"name\"<\/span>: '\u6ce2\u591a\u91ce\u7d50\u8863'<\/span>, 'bwh'<\/span>: '{ \"b\": 90, \"w\": 59, \"h\": 85}'<\/span> , 'age'<\/span>: 30<\/span>},\n<\/span><\/code>    {\"name\"<\/span>: '\u5409\u6cfd\u660e\u6b65'<\/span>, 'bwh'<\/span>: '{ \"b\": 86, \"w\": 58, \"h\": 86}'<\/span> , 'age'<\/span>: 35<\/span>},\n<\/span><\/code>    {\"name\"<\/span>: '\u6843\u4e43\u6728\u9999\u5948'<\/span>, 'bwh'<\/span>: '{ \"b\": 80, \"w\": 54, \"h\": 80}'<\/span> , 'age'<\/span>: 22<\/span>},\n<\/span><\/code>    {\"name\"<\/span>: '\u897f\u5bab\u68a6'<\/span>, 'bwh'<\/span>: '{ \"b\": 85, \"w\": 56, \"h\": 86}'<\/span> , 'age'<\/span>: 22<\/span>},\n<\/span><\/code>    {\"name\"<\/span>: '\u677e\u4e0b\u7eb1\u8363\u5b50'<\/span>, 'bwh'<\/span>: '{ \"b\": 88, \"w\": 57, \"h\": 86}'<\/span> , 'age'<\/span>: 28<\/span>}\n<\/span><\/code>])<\/span><\/code><\/pre>\n<\/section>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\u8fd9\u6b21\u6211\u4eec\u4f7f\u7528 for \u5faa\u73af\u67e5\u8be2\u4e00\u4e0b\u6570\u636e\u5e93<\/p>\n
\n
\n
for<\/span> item in<\/span> db.col.find<\/span>():\n<\/span><\/code>    print<\/span>(item)<\/span><\/code><\/pre>\n<\/section>\n
\n
\u53ef\u4ee5\u770b\u5230<\/p>\n
\n
\u6570\u636e\u88ab\u6211\u4eec\u5b58\u50a8\u4e0b\u6765\u4e86<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\u5f53\u7136<\/p>\n
\n
\u4f60\u4e5f\u53ef\u4ee5\u901a\u8fc7\u6761\u4ef6\u67e5\u8be2<\/p>\n
\n
\u4f8b\u5982\u6839\u636e id \u67e5\u8be2<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\n
\u5220\u9664 \u6ce2\u591a\u91ce\u7ed3\u8863<\/p>\n
\n
\"python\u722c\u866b27<\/p>\n
\n
\n
db.col.remove<\/span>({\"name\"<\/span>: \"\u6ce2\u591a\u91ce\u7d50\u8863\"<\/span>})<\/span><\/code><\/pre>\n<\/section>\n
\n
\u5220\u9664\u5168\u90e8<\/p>\n
\n
\n
db<\/span>.col<\/span>.remove<\/span>()<\/span><\/code><\/pre>\n<\/section>\n
\n
\u628a \u5409\u6cfd\u660e\u6b65 \u6362\u6210 \u82cd\u4e95\u7a7a<\/p>\n
\n
\n
db.col.update({'name'<\/span>: '\u5409\u6cfd\u660e\u6b65'<\/span>}, {'$set'<\/span>: {'name'<\/span>: '\u82cd\u4e95\u7a7a'<\/span>}})<\/span><\/code><\/pre>\n<\/section>\n
\n
\n
ok<\/p>\n
\n
\u4ee5\u4e0a\u5c31\u662f python \u5bf9 MongoDB \u7684\u64cd\u4f5c<\/p>\n
\n
\u66f4\u591a\u5173\u4e8e MongoDB \u7684\u4ecb\u7ecd\u53ef\u4ee5\u5230\u5b98\u65b9\u770b\u770b<\/p>\n
\n
https:\/\/docs.mongodb.com\/<\/p>\n
\n
\u4ee5\u540e<\/p>\n
\n
\u5c0f\u5e05b\u5e26\u4f60\u73a9\u722c\u866b\u9879\u76ee\u5b9e\u6218\u7684\u65f6\u5019<\/p>\n
\n
\u8fd8\u4f1a\u63d0\u53ca MongoDB \u7684<\/p>\n
\n
\u671f\u5f85\u5c31\u597d<\/p>\n
\n
\u90a3\u4e48<\/p>\n
\n
\u6211\u4eec\u4e0b\u56de\u89c1\u4e86<\/p>\n
\n
peace<\/span><\/p>\n
\n
\"python\u722c\u866b27<\/span><\/a><\/p>\n
\n
\u8bb0\u5f97\u7d20\u8d28\u4e09\u8fde!!!!!!!!!!!!!!!!<\/p>\n
\u539f\u6587\u59cb\u53d1\u4e8e\u5fae\u4fe1\u516c\u4f17\u53f7\uff08\u5b66\u4e60python\u7684\u6b63\u786e\u59ff\u52bf\uff09\uff1apython\u722c\u866b27 | \u5f53Python\u9047\u5230MongoDB\u7684\u65f6\u5019\uff0c\u5b58\u50a8av\u5973\u4f18\u7684\u6570\u636e\u53d8\u5f97\u5982\u6b64\u987a\u6ed1\u723d\uff5e<\/a><\/p><\/blockquote>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u4e0a\u6b21 \u6211\u4eec\u77e5\u9053\u4e86\u600e\u4e48\u64cd\u4f5c MySQL \u6570\u636e\u5e93 python\u722c\u866b26 | \u628a\u6570\u636e\u722c\u53d6\u4e0b\u6765\u4e4b\u540e\u5c31\u5b58\u50a8\u5230\u4f60\u7684MySQL\u6570\u636e\u5e93\u3002 MySQL \u6709\u4e9b\u5e74\u5934\u4e86 \u5f00\u6e90\u53c8\u6210\u719f\u53c8\u725b\u903c \u6240\u4ee5\u73b0\u5728\u5f88\u591a\u4f01\u4e1a\u90fd\u5728\u4f7f\u7528 MySQL MySQL \u662f\u5173\u7cfb\u578b\u6570\u636e\u5e93 \u5176\u5b9e\u5f53\u524d\u4e3b\u6d41\u7684\u6570\u636e\u5e93…<\/p>\n","protected":false},"author":1,"featured_media":5006,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[303],"tags":[401],"_links":{"self":[{"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/posts\/5005"}],"collection":[{"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5005"}],"version-history":[{"count":2,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/posts\/5005\/revisions"}],"predecessor-version":[{"id":6640,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/posts\/5005\/revisions\/6640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=\/wp\/v2\/media\/5006"}],"wp:attachment":[{"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vip.fxxkpython.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}