* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
pymongo와 mongodb에 뭐가 잘못된 것인지 알 수가 없습니다.
마지막python app.py로 점검하면 다음의 메시지가 뜹니다.
$ python app.py
Traceback (most recent call last):
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\srv_resolver.py", line 89, in _resolve_uri
results = _resolve(
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\srv_resolver.py", line 43, in _resolve
return resolver.resolve(*args, **kwargs)
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\dns\resolver.py", line 1368, in resolve
return get_default_resolver().resolve(
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\dns\resolver.py", line 1190, in resolve
(request, answer) = resolution.next_request()
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\dns\resolver.py", line 691, in next_request
raise NXDOMAIN(qnames=self.qnames_to_try, responses=self.nxdomain_responses)
dns.resolver.NXDOMAIN: The DNS query name does not exist: _mongodb._tcp.cluster0.tw1j9or.mongodb.net.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\Administrator\Desktop\pirates\web\lv1\app.py", line 8, in <module>
client = MongoClient("mongodb+srv://sparta:test@cluster0.tw1j9or.mongodb.net/?retryWrites=true&w=majority")
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\mongo_client.py", line 736, in __init__
res = uri_parser.parse_uri(
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\uri_parser.py", line 542, in parse_uri
nodes = dns_resolver.get_hosts()
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\srv_resolver.py", line 121, in get_hosts
_, nodes = self._get_srv_response_and_hosts(True)
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\srv_resolver.py", line 101, in _get_srv_response_and_hosts
results = self._resolve_uri(encapsulate_errors)
File "C:\Users\Administrator\Desktop\pirates\web\lv1\venv\lib\site-packages\pymongo\srv_resolver.py", line 97, in _resolve_uri
raise ConfigurationError(str(exc))
pymongo.errors.ConfigurationError: The DNS query name does not exist: _mongodb._tcp.cluster0.tw1j9or.mongodb.net.
(venv)
app.py
from flask import Flask, render_template, request, jsonify
app = Flask(__name__)
import requests
from bs4 import BeautifulSoup
from pymongo import MongoClient
client = MongoClient("mongodb+srv://sparta:test@cluster0.tw1j9or.mongodb.net/?retryWrites=true&w=majority")
db = client.pirates_lv1
@app.route('/')
def home():
return render_template("index.html")
@app.route('/exhibit', methods=["POST"])
def post_exhibit():
url_receive = request.form["url_give"]
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_receive, headers=headers)
soup = BeautifulSoup(data.text, 'html.parser')
title = soup.select_one('#container > div.wide-inner > section > h3').text
period = soup.select_one('#container > div.detial-cont-element.active > div > dl:nth-child(1) > dd').text.strip()
tags = soup.select_one('#container > section.tag-element.poi > p').text.replace('\n',' ')
image = 'https://korean.visitseoul.net/'+soup.select('.item')[1]['style'].split('(')[1].replace(');','').replace('\'','')
doc = {
'title':title,
'period':period,
'tags':tags,
'image':image,
'url':url_receive
}
db.exhibition.insert_one(doc)
return jsonify({"msg": "저장 완료!"})
@app.route('/exhibit', methods=["GET"])
def get_exhibit():
exhibitions = list(db.exhibition.find({},{'_id':False}))
return jsonify({'result':exhibitions})
@app.route('/now', methods=["GET"])
def get_now():
url = 'https://korean.visitseoul.net/exhibition'
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')
items = soup.select('.item > a')
base = 'https://korean.visitseoul.net'
docs = []
for item in items:
url = base+item['href']
image = base+item.select_one('.thumb')['style'].split('(')[1].replace(')','')
title = item.select_one('.title').text
period = item.select_one('.small-text.text-dot-d').text.strip()
doc = {
'url':url,
'image':image,
'title':title,
'period':period
}
docs.append(doc)
print(docs)
return jsonify({'now':docs})
if __name__ == "__main__":
app.run(debug=True, port=8080)
index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>오늘의 전시</title>
<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.12.4.min.js"></script>
<style>
html,
body,
h1,
h2,
h3,
p,
a,
span {
margin: 0;
padding: 0;
}
.wrap {
width: 1050px;
margin: auto;
}
.card {
width: 320px;
height: 340px;
display: flex;
flex-direction: column;
align-items: flex-start;
justify-content: flex-start;
margin: 16px 10px;
border: 1px solid black;
cursor: pointer;
}
.card-wrap {
display: flex;
flex-direction: row;
flex-wrap: wrap;
}
.card-image {
background-position: center;
background-size: cover;
width: 100%;
height: 200px;
}
.card>span {
margin: 8px;
}
.card-title {
font-size: 18px;
font-weight: bold;
}
.period {
color: yellowgreen;
font-size: 14px;
}
.tags {
color: gray;
font-size: 14px;
word-break: keep-all;
}
.url-form {
align-items: center;
justify-content: space-around;
cursor: default;
}
.plus-form {
align-items: center;
justify-content: center;
cursor: pointer;
}
</style>
<script>
$(document).ready(() => {
showPlusForm();
listing();
now();
})
const showUrlForm = () => {
$('#url-form').show();
$('#plus-form').hide();
}
const showPlusForm = () => {
$('#url-form').hide();
$('#plus-form').show();
}
const posting = () => {
let url = $('#url').val();
let formData = new FormData()
formData.append("url_give", url)
fetch('/exhibit', {method: "POST", body: formData}).then(res => res.json()).then(data => {
alert(data['msg']);
window.location.reload();
})
}
const move = (url) => {
window.open(url,'_blank');
}
const listing = () => {
fetch('/exhibit').then(res => res.json()).then(data => {
let rows = data['result']
rows.forEach((row) => {
let image = row['image']
let title = row['title']
let period = row['period']
let tags = row['tags']
let url = row['url']
let temp_html = `<div class="card" onclick="move('${url}')">
<div class="card-image" style="background-image: url('${image}');"></div>
<span class="card-title">${title}</span>
<span class="period">${period}</span>
<span class="tags">${tags}</span>
</div>`
$('#card-wrap').prepend(temp_html)
})
})
const now = () => {
fetch('/now').then(res => res.json()).then(data => {
let rows = data['now']
rows.forEach((row) => {
let image = row['image']
let title = row['title']
let period = row['period']
let url = row['url']
let temp_html = `<div class="card" onclick="move('${url}')">
<div class="card-image" style="background-image: url('${image}');"></div>
<span class="card-title">${title}</span>
<span class="period">${period}</span>
<span class="tags"></span>
</div>`
$('#card-now').prepend(temp_html)
})
})
}
</script>
</head>
<body>
<div class="wrap">
<h1>오늘의 전시</h1>
<h2>내가 추가한 전시</h2>
<div id="card-wrap" class="card-wrap">
<div id="url-form" class="url-form card">
<input id="url" type="text">
<div>
<button onclick="showPlusForm()">취소하기</button>
<button onclick="posting()">등록하기</button>
</div>
</div>
<h2>현재 진행중인 전시</h2>
<div id="card-now" class="card-now">
<div id="plus-form" onclick="showUrlForm()" class="plus-form card">
<span>+</span>
<span>추가하기</span>
</div>
</div>
</div>
</body>
</html>
