
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
강의 내용대로 아래 코드를 작성 후 실행했는데 DB에 반영이 되지 않습니다.
리프레시해도 Collections에 movies가 추가되지 않습니다.
코드에 에러가 발생한 거 같은데 terminal에 내용이 많아 잘 모르겠네요. 봐서는 문제가 없어 보이는데...
작성한 코드 및 에러 메세지
from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient('mongodb+srv://sparta:test@cluster0.rlowhky.mongodb.net/?retryWrites=true&w=majority',
tlsCAFile=ca)
db = client.dbsparta
import requests
from bs4 import BeautifulSoup
URL = "https://movie.daum.net/ranking/reservation"
headers = {'User-Agent' : 'Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36'}
data = requests.get(URL,headers=headers)
soup = BeautifulSoup(data.text, 'html.parser')
trs = soup.select('#old_content > table > tbody > tr')
for tr in trs:
a = tr.select_one('td.title > div > a')
if a is not None:
title = a.text
rank = tr.select_one('td:nth-child(1) > img')['alt']
star = tr.select_one('td.point').text
doc = {
'title':title,
'rank':rank,
'star':star
}
db.movies.insert_one(doc)오류 발생 시, 작성한 코드 전체와 에러 메시지를 첨부해 주세요.
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ source c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/activate
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
1 가디언즈 오브 갤럭시: Volume 3 8.9
2 슈퍼 마리오 브라더스 8.6
3 드림 7.9
4 극장판 짱구는 못말려: 동물소환 닌자 배꼽수비대 8.7
5 존 윅 4 7.5
6 더 퍼스트 슬램덩크 8.3
7 스즈메의 문단속 7.3
8 옥수역귀신 6.2
9 리바운드 8.9
10 킬링 로맨스 6.2
11 스트리머 5.5
12 무명 7.9
13 클로즈 7.3
14 항구의 니쿠코짱! 9.7
15 아임 히어로 더 파이널 9.7
16 슬픔의 삼각형 9.8
17 롱디 7.8
18 스프린터 8.7
19 거울 속 외딴 성 9.0
20 라이스보이 슬립스 8.9
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
File "c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py", line 11
for a in all_users
^
SyntaxError: invalid syntax
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
{'name': '영수', 'age': 24}
{'name': '영희', 'age': 30}
{'name': '철수', 'age': 20}
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
{'_id': ObjectId('644e75487e78247b2b5288b0'), 'name': '영수', 'age': 24}
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
Traceback (most recent call last):
File "c:/Users/PSY/Desktop/sparta/pythonprac/hello.py", line 12, in <module>
trs = soup.select('#old_content > table > tbody > tr')
NameError: name 'soup' is not defined
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
Traceback (most recent call last):
File "c:/Users/PSY/Desktop/sparta/pythonprac/hello.py", line 12, in <module>
soup = BeautifulSoup(data.text, 'html.parcer')
NameError: name 'data' is not defined
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/hello.py
(venv)
PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$
Tip 1) </> 아이콘을 눌러 코드박스를 만들어 보세요.
Tip 2) Ctrl+A(맥의 경우 Command+A) 단축키로 코드를 한 번에 선택할 수 있어요!
