ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • python & mongoDB 연동
    공부/python 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)
Designed by Tistory.