mongod-pymongo

#安装
# https://www.mongodb.com/download-center/community
# 启动
# 创建data\db目录
# bin目录下命令行执行
# mongod --dbpath c:\data\db


import pymongo

myclient = pymongo.MongoClient("mongodb://127.0.0.1:27017/")
# 创建数据库 数据库需创建集合并插入文档后真正创建 database
mydb = myclient["testbd"]
mydb1 = myclient["testbd1"]

# 查看数据库
dbnamelist = myclient.list_database_names()
print("db name list: ", dbnamelist)
dblist = myclient.list_databases()
print("db list: ", dblist)

# 创建集合 collection 对应SQL的table
mycol = mydb["testcol"]

# 查看集合
col_list = mydb.list_collections()
print("col list: ",col_list)
colnamelist = mydb.list_collection_names()
print("col name list: ", colnamelist)

# 增 insert_one()
add_dict = {"name":"test add", "date":"22.1.4", "id":"1"}
cb = mycol.insert_one(add_dict)
print("cb: ", cb)
print("cb.inserted_id: ",cb.inserted_id)
# 可同时插入多个
add_dicts = [
    {"id":"2", "date":"22.1.4"},
    {"id":"3", "date":"22.1.4"},
    {"id":"4", "date":"22.1.4"}
]
cb = mycol.insert_many(add_dicts)
print("cb: ",cb)
print("cb.inserted_ids: ", cb.inserted_ids)

# 查 find()
find_one = mycol.find_one()
print("find_one:", find_one)

find_all = mycol.find()
for x in find_all:
    print(x)
print("find_all: ", type(find_all))

# 查询指定条件、字段、返回条数 需要的字段为1
find_assign_filed = mycol.find({"id":  { "$gt": "0" }},{"name": 1, "id": 1}).limit(3)
for x in find_assign_filed:
    print(x)
print("find_assign_filed:", type(find_assign_filed))

# 改
# 修改第一个匹配 update_one, 多个update_mangy
old = {"id":"4"}
new = {"$set": {"date":"22.1.5"}}
mycol.update_one(old, new)
find_all = mycol.find()
find_assign_filed = mycol.find({"id": "4"},{})
print("update: ", find_assign_filed[0])
# 删
# 删除单个delete_one() 删除多个 delete_many() (没有条件是删除所有)
delete = {"id":"4"}
mycol.delete_one(delete)
print("delete one: ")
for x in mycol.find():
  print(x)

mycol.delete_many({})
print("delete many: ")
for x in mycol.find():
  print(x)

# 删除集合 drop()
mycol.drop()
colnamelist = mydb.list_collection_names()
print("col name list: ", colnamelist)