跳到主要內容


Python-資料庫-mongodb-pymongo

Python
資料庫
mongodb-pymongo

安裝:
linux、mac:pip3 install pymongo
windows:

import pymongo

client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client['demo_db']
col = db['demo_col']

dict1 = { "name": "ab123ab456g", "day": "1890-04-05" }
result = col.insert_one(dict1) 

dict2 = [
  { "name": "ki", "day": "1666-1-1"},
  { "name": "aa", "day": "1222-11-11"},
  { "name": "gg-gg", "day": "1333-02-22"},
  { "name": "T-T", "day": "1444-03-02"},
  { "name": "f-f", "day": "1555-01-01"}
]


result = col.insert_many(dict2)
result = col.find_one()
print(result)

results = col.find()
for result in col.find():
print(result)


results = col.find()
query = {'name':'ki'}
for result in col.find(query):
print(result)

query = {'name':'ki'}
update_query = {'$set':{'day':'1000-01-01'}}

result = col.update_many(query, update_query)

col.delete_ont(query)

for result in col.find():
print(result)

程式碼說明

匯入模組
連結資料庫
使用資料庫
使用collection,等於表格
定義單一筆資料
加入單一筆資料
定義多筆資料
加入多筆資料
搜尋一筆資料
搜尋全部資料
搜尋特定條件資料
更新資料
刪除資料

留言

這個網誌中的熱門文章

程式語言學習概論(1)

程式語言 介紹

語言學習-English-Lights

Song Lyric Title : Lights Singer :Ellie Goulding Album :  Bright Lights Release Date :  2011 I had a way then losing it all on my own I had a heart then but the queen has been overthrown And I'm not sleeping now the dark is too hard to beat And I'm not keeping up the strength I need to push me You show the lights that stop me turn to stone You shine it when I'm alone And so I tell myself that I'll be strong And dreaming when they're gone 'Cause they're calling, calling, calling me home Calling, calling, calling home You show the lights that stop me turn to stone You shine them when I'm alone Noises, I play within my head Touch my own skin and hope they'll still be there And I think back to when my brother and my sister slept In and on my place the only time I feel safe You show the lights that stop me turn to stone You shine it when I'm alone And so I tell myself that I'...