from pymongo import MongoClient
connection = MongoClient('localhost', 27017)
print(connection)
print(connection.list_database_names()) # DB 목록 출력
db = connection.Test # DB 생성
print(db)
collection = db.AAA # collection 생성
print(collection)
## insert_one
data = {"name": "user01",
"wall_post": "laugh out loud. LOL XD",
"follow": 34
}
col = db.collection
result = col.insert_one(data)
print(result)
## insert_many
data = [{"name": "user01",
"wall_post": "laugh out loud. LOL XD",
"follow": 34
},
{"name": "user02",
"wall_post": "merry christmas",
"follow": 17
},
{"name": "user03",
"wall_post": "happy holidays",
"follow": 51
}
]
col = db.collection
result = col.insert_many(data)
print(result)
## find_one : 가장 빨리 검색되는 문서를 하나 검색
col = db.collection
result = col.find_one()
print(result)
col = db.collection
result = col.find_one({"name" : "user03"})
print(result)
## find : 문서 전체 검색
col = db.collection
docs = col.find()
for doc in docs:
print("doc: ", doc)
## find().count()
docs_count = col.count_documents({}) # count_documents(filter)
print("docs_count: ", docs_count)
## find().sort()
for data in col.find({"name" : "user01"}).sort("_id"):
print("data: ", data)
## update
col = db.collection
result = col.update_one(
{"name" : "user02"},
{"$set" : {
"wall_post" : "I am not a user"
}
}
)
print(result)
## delete_one
col = db.collection
result = col.delete_one({"name": "user02"})
print(result)
## delete_many
col = db.collection
result = col.delete_many({"name": "user01"})
print(result)