基于python連接數據庫
更新時間 2023-08-29 15:14:30
最近更新時間: 2023-08-29 15:14:30
分享文章
本頁介紹了基于python如何連接文檔數據庫服務。
安裝pymongo
pip install pymongo
使用SSL證書連接
from pymongo import MongoClient
import ssl
?
# 指定文檔數據庫的連接URI
uri = "mongodb://username:password@hostname:port/database_name?ssl=true&authSource=admin"
?
# 創建SSL上下文
context = ssl.create_default_context(cafile="/path/to/ca.pem")
context.load_cert_chain("/path/to/client.pem", keyfile="/path/to/client.key")
?
# 創建客戶端
client = MongoClient(uri, ssl_certfile="/path/to/client.pem", ssl_keyfile="/path/to/client.key", ssl_ca_certs="/path/to/ca.pem", ssl_cert_reqs=ssl.CERT_REQUIRED, ssl_context=context)
?
# 獲取數據庫實例
database = client["testdb"]
?
# 獲取集合實例
collection = database["testcollection"]
?
# 插入文檔
document = {"name": "John Doe", "age": 30, "email": "johndoe@example.com"}
collection.insert_one(document)
?
# 查詢文檔
query = {"name": "John Doe"}
result = collection.find_one(query)
print(result)
?
# 關閉連接
client.close()
無證書連接
from pymongo import MongoClient
?
# 指定數據庫的連接URI
uri = "mongodb://username:password@hostname:port/database_name?authSource=admin"
?
# 創建客戶端
client = MongoClient(uri)
?
# 獲取數據庫實例
database = client["testdb"]
?
# 獲取集合實例
collection = database["testcollection"]
?
# 插入文檔
document = {"name": "John Doe", "age": 30, "email": "johndoe@example.com"}
collection.insert_one(document)
?
# 查詢文檔
query = {"name": "John Doe"}
result = collection.find_one(query)
print(result)
?
# 關閉連接
client.close()