跳到主要內容


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'...

Python-資料庫

Python 資料庫 基本概念說明 參考程式語言概念- 資料庫內容 。 對於這邊的介紹其實,主要是對基本語法、資料庫的基本操作進行說明,所以大多只會看到語法指令,而不會深究內容,因為其內容會在SQL跟noSQL的文章內容進行說明,這邊說明會讓篇幅太多。 常見的資料庫 SQL:MySQL NoSQL:Mongodb 以下是處理該類型檔案對應函式或模組 資料庫名稱 模組 MySql MySQLdb mysqlclient PyMySQL mysql.connector peewee SQLAlchemy Mongodb pymongo PyMySQL 用python全實作的model,需要下SQL語法。 範例- 連結 SQLAlchemy 用ORM的概念做出來,支援各種SQL資料庫。 範例- 連結 pymongo 專門用來連結mongodb的module 範例- 連結