공부/python

python & mongoDB 연동

happyst 2023. 1. 18. 20:51
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)