MongoDB下載: https://www.mongodb.com/
可視化工具Robo 3T下載:https://robomongo.org/download
python中的操作
# 引入pymongo模塊
import pymongo
讀取數(shù)據(jù)庫
import pandas as pd
def get_key_value(database, collection, key):
client = pymongo.MongoClient('localhost', 27017)
db = client['database']
table = db['collection']
data = pd.DataFrame(list(table.find()))
value = data['key']
return value
保存數(shù)據(jù)至數(shù)據(jù)庫中
def save_to_Mongo(result):
# 數(shù)據(jù)儲(chǔ)存到mongodb
try:
if db[MONGO_TABLE].insert_one(result):
print('存儲(chǔ)到MongoDB成功', result)
except Exception:
print('存儲(chǔ)到MongoDb失敗', result)
MONGO_URl = 'localhost:27017'
MONGO_DB = 'database_name'
client = pymongo.MongoClient(MONGO_URl)
db = client[MONGO_DB]
MONGO_TABLE = 'collection_name'
更新?lián)Q代數(shù)據(jù)庫中數(shù)據(jù)
db[MONGO_TABLE].update_one(
{'_id': "匹配所需更改的集合"},
{'$set': {'所需更改的key':'更改的值'}})
將數(shù)據(jù)庫壓縮導(dǎo)出
mongodump --db database_name --collection collection_name --archive=database_name.tar.gz