* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
현재 퀴즈 진행중인데 계속 에러가 뜨네요.....
작성한 코드 및 에러 메세지
from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient("mongodb+srv://sparta:test@sparta.boeti0q.mongodb.net/?retryWrites=true&w=majority", tlsCAFile=ca)
db = client.dbsparta
movie = db.users.find_one({'title':'가버나움'})
print(movie['star'])
======================================================
The default interactive shell is now zsh.
To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ source /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/activate
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수'}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수'}
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py", line 11, in <module>
db.users.insert_one(doc)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/collection.py", line 628, in insert_one
self._insert_one(
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/collection.py", line 569, in _insert_one
self.__database.client._retryable_write(acknowledged, _insert_command, session)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1476, in _retryable_write
return self._retry_with_session(retryable, func, s, None)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1349, in _retry_with_session
return self._retry_internal(retryable, func, session, bulk)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/_csot.py", line 105, in csot_wrapper
return func(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1381, in _retry_internal
with self._get_socket(server, session) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1217, in _get_socket
with server.get_socket(handler=err_handler) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1407, in get_socket
sock_info = self._get_socket(handler=handler)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1520, in _get_socket
sock_info = self.connect(handler=handler)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1378, in connect
sock_info.authenticate()
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 870, in authenticate
auth.authenticate(creds, self)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 549, in authenticate
auth_func(credentials, sock_info)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 475, in _authenticate_default
return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 241, in _authenticate_scram
res = sock_info.command(source, cmd)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 767, in command
return command(
^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/network.py", line 166, in command
helpers._check_command_response(
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/helpers.py", line 181, in _check_command_response
raise OperationFailure(errmsg, code, response, max_wire_version)
pymongo.errors.OperationFailure: bad auth : authentication failed, full error: {'ok': 0, 'errmsg': 'bad auth : authentication failed', 'code': 8000, 'codeName': 'AtlasError'}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수'}
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py", line 11, in <module>
db.users.insert_one(doc)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/collection.py", line 628, in insert_one
self._insert_one(
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/collection.py", line 569, in _insert_one
self.__database.client._retryable_write(acknowledged, _insert_command, session)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1476, in _retryable_write
return self._retry_with_session(retryable, func, s, None)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1349, in _retry_with_session
return self._retry_internal(retryable, func, session, bulk)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/_csot.py", line 105, in csot_wrapper
return func(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1381, in _retry_internal
with self._get_socket(server, session) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1217, in _get_socket
with server.get_socket(handler=err_handler) as sock_info:
File "/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1407, in get_socket
sock_info = self._get_socket(handler=handler)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1520, in _get_socket
sock_info = self.connect(handler=handler)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1378, in connect
sock_info.authenticate()
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 870, in authenticate
auth.authenticate(creds, self)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 549, in authenticate
auth_func(credentials, sock_info)
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 475, in _authenticate_default
return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/auth.py", line 241, in _authenticate_scram
res = sock_info.command(source, cmd)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/pool.py", line 767, in command
return command(
^^^^^^^^
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/network.py", line 166, in command
helpers._check_command_response(
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/lib/python3.11/site-packages/pymongo/helpers.py", line 181, in _check_command_response
raise OperationFailure(errmsg, code, response, max_wire_version)
pymongo.errors.OperationFailure: bad auth : authentication failed, full error: {'ok': 0, 'errmsg': 'bad auth : authentication failed', 'code': 8000, 'codeName': 'AtlasError'}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수'}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영희', 'age': 30}
{'name': '철수', 'age': 20}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수'}
{'name': '영희', 'age': 30}
{'name': '철수', 'age': 20}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
{'_id': ObjectId('6409896608a9a9fd2fc23532'), 'name': '영수'}
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbprac.py
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py", line 1, in <module>
import requests
ModuleNotFoundError: No module named 'requests'
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py", line 1, in <module>
import requests
ModuleNotFoundError: No module named 'requests'
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install pymongo
Requirement already satisfied: pymongo in ./venv/lib/python3.11/site-packages (4.3.3)
Requirement already satisfied: dnspython<3.0.0,>=1.16.0 in ./venv/lib/python3.11/site-packages (from pymongo) (2.3.0)
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install dnspython
Requirement already satisfied: dnspython in ./venv/lib/python3.11/site-packages (2.3.0)
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install certifi
Requirement already satisfied: certifi in ./venv/lib/python3.11/site-packages (2022.12.7)
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py", line 1, in <module>
import requests
ModuleNotFoundError: No module named 'requests'
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install requests bs4
Collecting requests
Using cached requests-2.28.2-py3-none-any.whl (62 kB)
Collecting bs4
Using cached bs4-0.0.1.tar.gz (1.1 kB)
Preparing metadata (setup.py) ... done
Collecting charset-normalizer<4,>=2
Using cached charset_normalizer-3.1.0-cp311-cp311-macosx_11_0_arm64.whl (121 kB)
Collecting idna<4,>=2.5
Using cached idna-3.4-py3-none-any.whl (61 kB)
Collecting urllib3<1.27,>=1.21.1
Using cached urllib3-1.26.14-py2.py3-none-any.whl (140 kB)
Requirement already satisfied: certifi>=2017.4.17 in ./venv/lib/python3.11/site-packages (from requests) (2022.12.7)
Collecting beautifulsoup4
Using cached beautifulsoup4-4.11.2-py3-none-any.whl (129 kB)
Collecting soupsieve>1.2
Using cached soupsieve-2.4-py3-none-any.whl (37 kB)
Installing collected packages: urllib3, soupsieve, idna, charset-normalizer, requests, beautifulsoup4, bs4
DEPRECATION: bs4 is being installed using the legacy 'setup.py install' method, because it does not have a 'pyproject.toml' and the 'wheel' package is not installed. pip 23.1 will enforce this behaviour change. A possible replacement is to enable the '--use-pep517' option. Discussion can be found at https://github.com/pypa/pip/issues/8559
Running setup.py install for bs4 ... done
Successfully installed beautifulsoup4-4.11.2 bs4-0.0.1 charset-normalizer-3.1.0 idna-3.4 requests-2.28.2 soupsieve-2.4 urllib3-1.26.14
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py
01 밥정 9.64
02 그린 북 9.59
03 가버나움 9.59
04 디지몬 어드벤처 라스트 에볼루션 : 인연 9.53
05 원더 9.52
06 베일리 어게인 9.52
07 먼 훗날 우리 9.52
08 아일라 9.51
09 당갈 9.49
010 극장판 바이올렛 에버가든 9.48
11 포드 V 페라리 9.48
12 주전장 9.47
13 쇼생크 탈출 9.45
14 터미네이터 2:오리지널 9.44
15 덕구 9.43
16 나 홀로 집에 9.43
17 라이언 일병 구하기 9.43
18 클래식 9.42
19 잭 스나이더의 저스티스 리그 9.42
20 그대, 고맙소 : 김호중 생애 첫 팬미팅 무비 9.42
21 월-E 9.42
22 보헤미안 랩소디 9.42
23 사운드 오브 뮤직 9.41
24 포레스트 검프 9.41
25 빽 투 더 퓨쳐 9.41
26 위대한 쇼맨 9.41
27 글래디에이터 9.41
28 헬프 9.41
29 인생은 아름다워 9.40
30 타이타닉 9.40
31 매트릭스 9.40
32 살인의 추억 9.40
33 센과 치히로의 행방불명 9.39
34 토이 스토리 3 9.39
35 가나의 혼인잔치: 언약 9.39
36 헌터 킬러 9.39
37 캐스트 어웨이 9.38
38 집으로... 9.38
39 아이즈 온 미 : 더 무비 9.38
40 반지의 제왕: 왕의 귀환 9.38
41 죽은 시인의 사회 9.38
42 히든 피겨스 9.38
43 알라딘 9.38
44 어벤져스: 엔드게임 9.38
45 레옹 9.38
46 쉰들러 리스트 9.37
47 아이 캔 스피크 9.37
48 동주 9.37
49 안녕 베일리 9.37
50 클레멘타인 9.37
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/hello.py
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py
None
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py", line 9, in <module>
print(movie['star'])
~~~~~^^^^^^^^
TypeError: 'NoneType' object is not subscriptable
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install cerfiti
ERROR: Could not find a version that satisfies the requirement cerfiti (from versions: none)
ERROR: No matching distribution found for cerfiti
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py", line 9, in <module>
print(movie['star'])
~~~~~^^^^^^^^
TypeError: 'NoneType' object is not subscriptable
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ install pymongo
usage: install [-bCcpSsv] [-B suffix] [-f flags] [-g group] [-m mode]
[-o owner] file1 file2
install [-bCcpSsv] [-B suffix] [-f flags] [-g group] [-m mode]
[-o owner] file1 ... fileN directory
install -d [-v] [-g group] [-m mode] [-o owner] directory ...
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install pymongo
Requirement already satisfied: pymongo in ./venv/lib/python3.11/site-packages (4.3.3)
Requirement already satisfied: dnspython<3.0.0,>=1.16.0 in ./venv/lib/python3.11/site-packages (from pymongo) (2.3.0)
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ pip install dnspython
Requirement already satisfied: dnspython in ./venv/lib/python3.11/site-packages (2.3.0)
[notice] A new release of pip available: 22.3.1 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$ /Users/kimtaeyeon/Desktop/sparta/pythonprac/venv/bin/python /Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py
Traceback (most recent call last):
File "/Users/kimtaeyeon/Desktop/sparta/pythonprac/dbmovie.py", line 9, in <module>
print(movie['star'])
~~~~~^^^^^^^^
TypeError: 'NoneType' object is not subscriptable
(venv) gimtaeyeon-ui-MacBookAir:pythonprac kimtaeyeon$
