커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
에러 08. [화성땅 공동구매] - POST 연습(주문 저장).
undefined주차
김*령
댓글
3
・
추천
0
・
조회수
9
조회수
9
답변 완료
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
데이터 입력 전에는 'GET' 'POST' 메시지 잘 출력되었는데, 데이터 보내고 받는 코드 입력 후 안됩니다. 도와주세요 ~
보고 계신 화면 전체를 캡처에러 08. [화성땅 공동구매] - POST 연습(주문 저장).
해 주시면, 튜터님들이 빠르게 상황을 이해할 수 있어요.
from flask import Flask, render_template, request, jsonify
app = Flask(__name__)
from pymongo import MongoClient
client = MongoClient('mongodb+srv://test:sparta@cluster0.y94ee0h.mongodb.net/?retryWrites=true&w=majority')
db = client.dbsparta
@app.route('/')
def home():
return render_template('index.html')
@app.route("/mars", methods=["POST"])
def web_mars_post():
name_receive = request.form['name_give']
address_receive = request.form['address_give']
size_receive = request.form['size_give']
doc = {
'name': name_receive,
'address': address_receive,
'size': size_receive
}
db.mars.insert_one(doc)
return jsonify({'msg': '주문완료'})
@app.route("/mars", methods=["GET"])
def web_mars_get():
return jsonify({'msg': 'GET 연결 완료!'})
if __name__ == '__main__':
app.run('0.0.0.0', port=5000, debug=True)
<!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">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet"integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous"><script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script><script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM"crossorigin="anonymous"></script>
<link href="https://fonts.googleapis.com/css2?family=Gowun+Batang:wght@400;700&display=swap" rel="stylesheet">
<title>선착순 공동구매</title>
<style>
* {
font-family: 'Gowun Batang', serif;
color: white;
}
body {
background-image: linear-gradient(0deg, rgba(0, 0, 0, 0.5), rgba(0, 0, 0, 0.5)), url('https://cdn.aitimes.com/news/photo/202010/132592_129694_3139.jpg');
background-position: center;
background-size: cover;
}
h1 {
font-weight: bold;
}
.order {
width: 500px;
margin: 60px auto 0px auto;
padding-bottom: 60px;
}
.mybtn {
width: 100%;
}
.order > table {
margin : 40px 0;
font-size: 18px;
}
option {
color: black;
}
</style><script>
$(document).ready(function () {
show_order();
});
function show_order() {
$.ajax({
type: 'GET',
url: '/mars',
data: {},
success: function (response) {
alert(response['msg'])
}
});
}
function save_order() {
let name = $('#name').val()
let address = $('#address').val()
let size = $('#size').val()
$.ajax({
type: 'POST',
url: '/mars',
data: { name_give: name, address_give: address, size_give: size},
success: function (response) {
alert(response['msg'])
window.location.reload()
}
});
}
</script>
</head>
<body><div class="mask"></div><div class="order"><h1>화성에 땅 사놓기!</h1><h3>가격: 평 당 500원</h3><p>
화성에 땅을 사둘 수 있다고?<br/>
앞으로 백년 간 오지 않을 기회. 화성에서 즐기는 노후!
</p><div class="order-info"><div class="input-group mb-3"><span class="input-group-text">이름</span><input id="name" type="text" class="form-control"></div><div class="input-group mb-3"><span class="input-group-text">주소</span><input id="address" type="text" class="form-control"></div><div class="input-group mb-3"><label class="input-group-text" for="size">평수</label><select class="form-select" id="size"><option selected>-- 주문 평수 --</option><option value="10평">10평</option><option value="20평">20평</option><option value="30평">30평</option><option value="40평">40평</option><option value="50평">50평</option></select></div><button onclick="save_order()" type="button" class="btn btn-warning mybtn">주문하기</button></div><table class="table"><thead><tr><th scope="col">이름</th><th scope="col">주소</th><th scope="col">평수</th></tr></thead><tbody><tr><td>홍길동</td><td>서울시 용산구</td><td>20평</td></tr><tr><td>임꺽정</td><td>부산시 동구</td><td>10평</td></tr><tr><td>세종대왕</td><td>세종시 대왕구</td><td>30평</td></tr></tbody></table></div>
</body>
</html>
E:\OneDrive\Sparta_home\Projects\mars\venv\Scripts\python.exe E:\OneDrive\Sparta_home\Projects\mars\app.py * Serving Flask app 'app' * Debug mode: on WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Running on all addresses (0.0.0.0) * Running on http://127.0.0.1:5000 * Running on http://192.168.0.3:5000 Press CTRL+C to quit * Restarting with stat * Debugger is active! * Debugger PIN: 108-000-352 127.0.0.1 - - [22/Jan/2023 18:02:10] "GET / HTTP/1.1" 200 - 127.0.0.1 - - [22/Jan/2023 18:02:10] "GET /mars HTTP/1.1" 405 - 127.0.0.1 - - [22/Jan/2023 18:02:48] "POST /mars HTTP/1.1" 500 - Traceback (most recent call last): File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2548, in __call__ return self.wsgi_app(environ, start_response) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2528, in wsgi_app response = self.handle_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2525, in wsgi_app response = self.full_dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1822, in full_dispatch_request rv = self.handle_user_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1820, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1796, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\app.py", line 24, in web_mars_post db.mars.insert_one(doc) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 628, in insert_one self._insert_one( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 569, in _insert_one self.__database.client._retryable_write(acknowledged, _insert_command, session) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write with self._tmp_session(session) as s: File "C:\Users\medzi_lh0062m\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session s = self._ensure_session(session) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session return self.__start_session(True, causal_consistency=False) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session self._topology._check_implicit_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support self._check_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 554, in _check_session_support self._select_servers_loop( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop raise ServerSelectionTimeoutError( pymongo.errors.ServerSelectionTimeoutError: ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992), Timeout: 30s, Topology Description: <TopologyDescription id: 63ccfb8e989b20416cc700e3, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>]> 127.0.0.1 - - [22/Jan/2023 18:02:52] "POST /mars HTTP/1.1" 500 - Traceback (most recent call last): File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2548, in __call__ return self.wsgi_app(environ, start_response) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2528, in wsgi_app response = self.handle_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2525, in wsgi_app response = self.full_dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1822, in full_dispatch_request rv = self.handle_user_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1820, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1796, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\app.py", line 24, in web_mars_post db.mars.insert_one(doc) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 628, in insert_one self._insert_one( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 569, in _insert_one self.__database.client._retryable_write(acknowledged, _insert_command, session) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write with self._tmp_session(session) as s: File "C:\Users\medzi_lh0062m\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session s = self._ensure_session(session) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session return self.__start_session(True, causal_consistency=False) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session self._topology._check_implicit_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support self._check_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 554, in _check_session_support self._select_servers_loop( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop raise ServerSelectionTimeoutError( pymongo.errors.ServerSelectionTimeoutError: ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992), Timeout: 30s, Topology Description: <TopologyDescription id: 63ccfb8e989b20416cc700e3, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>]> * Detected change in 'E:\\OneDrive\\Sparta_home\\Projects\\mars\\app.py', reloading * Restarting with stat * Debugger is active! * Debugger PIN: 108-000-352 127.0.0.1 - - [22/Jan/2023 18:09:21] "GET / HTTP/1.1" 200 - 127.0.0.1 - - [22/Jan/2023 18:09:22] "GET /mars HTTP/1.1" 200 - 127.0.0.1 - - [22/Jan/2023 18:09:49] "POST /mars HTTP/1.1" 500 - 127.0.0.1 - - [22/Jan/2023 18:10:00] "POST /mars HTTP/1.1" 500 - Traceback (most recent call last): File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2548, in __call__ return self.wsgi_app(environ, start_response) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2528, in wsgi_app response = self.handle_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 2525, in wsgi_app response = self.full_dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1822, in full_dispatch_request rv = self.handle_user_exception(e) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1820, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\flask\app.py", line 1796, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\app.py", line 24, in web_mars_post db.mars.insert_one(doc) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 628, in insert_one self._insert_one( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\collection.py", line 569, in _insert_one self.__database.client._retryable_write(acknowledged, _insert_command, session) File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write with self._tmp_session(session) as s: File "C:\Users\medzi_lh0062m\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 137, in __enter__ return next(self.gen) ^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session s = self._ensure_session(session) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session return self.__start_session(True, causal_consistency=False) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session self._topology._check_implicit_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support self._check_session_support() File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 554, in _check_session_support self._select_servers_loop( File "E:\OneDrive\Sparta_home\Projects\mars\venv\Lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop raise ServerSelectionTimeoutError( pymongo.errors.ServerSelectionTimeoutError: ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992),ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992), Timeout: 30s, Topology Description: <TopologyDescription id: 63ccfd3a653968caae4de4da, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-00.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-01.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>, <ServerDescription ('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-tqkt4bv-shard-00-02.y94ee0h.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:992)')>]>
댓글 알림
