커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
그대로 복사해서 붙이는데 안돼요.
undefined주차
북마크
정*재
댓글
12
추천
0
조회수
20
조회수
20
답변 완료

* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.강

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

강의 대로 따라 붙여서 했는데도 영수의 나이가 19로 수정이 안되요.

할 수 없어서 강의자료 보고 넣었는데 혹시 앞으로도 강의 자료보고 써야하고 계속 오류나나요?




스파르타 즉문즉답





from pymongo import MongoClient

import certifi

ca = certifi.where()

client = MongoClient('mongodb+srv://sparata:test@cluster0.ibfc7hf.mongodb.net/?retryWrites=true&w=majority',tlsCAFile=ca)

db = client.dbsparta


db.users.update_one({'name':'영수'},{'$set':{'age':19}})


user = db.users.find_one({'name':'영수'})

print(user)



(venv)

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

Traceback (most recent call last):

 File "c:\Users\정민재\Desktop\스파르타\pythonprac\dbprac.py", line 6, in <module>

  client = pymongo.MongoClient("mongodb+srv://sparata:test@cluster0.ibfc7hf.mongodb.net/?retryWrites=true&w=majority").tlsCAFile=ca

NameError: name 'pymongo' is not defined

(venv)

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

Traceback (most recent call last):

 File "c:\Users\정민재\Desktop\스파르타\pythonprac\dbprac.py", line 11, in <module>

  db.users.insert_one(doc)

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one

  self._insert_one(

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one

  self.__database.client._retryable_write(acknowledged, _insert_command, session)

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write

  with self._tmp_session(session) as s:

 File "C:\Program Files\WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.2544.0_x64__qbz5n2kfra8p0\lib\contextlib.py", line 135, in __enter__

  return next(self.gen)

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session

  s = self._ensure_session(session)

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session

  return self.__start_session(True, causal_consistency=False)

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session

  self._topology._check_implicit_session_support()

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

  self._check_session_support()

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

  self._select_servers_loop(

 File "C:\Users\정민재\Desktop\스파르타\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

  raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-t9gmp54-shard-00-00.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-t9gmp54-shard-00-01.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997),ac-t9gmp54-shard-00-02.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997), Timeout: 30s, Topology Description: <TopologyDescription id: 63ac1caddf0f4afe0e2e1f1c, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-t9gmp54-shard-00-00.ibfc7hf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-t9gmp54-shard-00-00.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-t9gmp54-shard-00-01.ibfc7hf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-t9gmp54-shard-00-01.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>, <ServerDescription ('ac-t9gmp54-shard-00-02.ibfc7hf.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-t9gmp54-shard-00-02.ibfc7hf.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)')>]>

(venv)

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

(venv) 

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

(venv) 

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

(venv) 

정민재@DESKTOP-BTBI854 MINGW64 ~/Desktop/스파르타/pythonprac

$ c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe

Python 3.10.9 (tags/v3.10.9:1dd9be6, Dec 6 2022, 20:01:21) [MSC v.1934 64 bit (AMD64)] on win32

Type "help", "copyright", "credits" or "license" for more information.

>>> for a in all_users:

... 

 File "<stdin>", line 2


  ^

IndentationError: expected an indented block after 'for' statement on line 1

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythoSyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py   ^SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>> c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

 File "<stdin>", line 1

  c:/Users/정민재/Desktop/스파르타/pythonprac/venv/Scripts/python.exe c:/Users/정민재/Desktop/스파르타/pythonprac/dbprac.py

   ^

SyntaxError: invalid syntax

>>>

취소
 공유
취소
댓글 0
댓글 알림
나의얼굴