
아 진짜 문의글 안남기고싶은데ㅠㅠ해결이 또안됩니다ㅠㅠㅠ
get 연결완료 후 입력후 주문하면 주문완료창이 뜨질않아요,,
app.py
->
from flask import Flask, render_template, request, jsonify
app = Flask(__name__)
from pymongo import MongoClient
import certifi
ca = certifi.where()
client = MongoClient('mongodb+srv://test:<sparta>@cluster0.gz3lawk.mongodb.net/?retryWrites=true&w=majority',
tlsCAFile=ca)
db = client.test
@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)
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">
<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>
실행창은
C:\Users\User\Desktop\sparta\projects\mars\venv\Scripts\python.exe C:/Users/User/Desktop/sparta/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.219.104:5000
Press CTRL+C to quit
* Restarting with stat
* Debugger is active!
* Debugger PIN: 130-998-295
127.0.0.1 - - [31/Aug/2022 14:59:59] "GET / HTTP/1.1" 200 -
127.0.0.1 - - [31/Aug/2022 14:59:59] "GET /mars HTTP/1.1" 200 -
127.0.0.1 - - [31/Aug/2022 15:00:09] "POST /mars HTTP/1.1" 500 -
Traceback (most recent call last):
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2548, in __call__
return self.wsgi_app(environ, start_response)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2528, in wsgi_app
response = self.handle_exception(e)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 2525, in wsgi_app
response = self.full_dispatch_request()
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 1822, in full_dispatch_request
rv = self.handle_user_exception(e)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\flask\app.py", line 1820, in full_dispatch_request
rv = self.dispatch_request()
File "C:\Users\User\Desktop\sparta\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 "C:\Users\User\Desktop\sparta\projects\mars\app.py", line 30, in web_mars_post
db.mars.insert_one(doc)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one
self._insert_one(
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 562, in _insert_one
self.__database.client._retryable_write(acknowledged, _insert_command, session)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1448, in _retryable_write
return self._retry_with_session(retryable, func, s, None)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1321, in _retry_with_session
return self._retry_internal(retryable, func, session, bulk)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\_csot.py", line 105, in csot_wrapper
return func(self, *args, **kwargs)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1353, in _retry_internal
with self._get_socket(server, session) as sock_info:
File "C:\Users\User\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
return next(self.gen)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1189, in _get_socket
with server.get_socket(handler=err_handler) as sock_info:
File "C:\Users\User\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
return next(self.gen)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\pool.py", line 1406, in get_socket
sock_info = self._get_socket(handler=handler)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\pool.py", line 1519, in _get_socket
sock_info = self.connect(handler=handler)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\pool.py", line 1377, in connect
sock_info.authenticate()
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\pool.py", line 869, in authenticate
auth.authenticate(creds, self)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\auth.py", line 549, in authenticate
auth_func(credentials, sock_info)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\auth.py", line 475, in _authenticate_default
return _authenticate_scram(credentials, sock_info, "SCRAM-SHA-1")
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\auth.py", line 241, in _authenticate_scram
res = sock_info.command(source, cmd)
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\pool.py", line 766, in command
return command(
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\site-packages\pymongo\network.py", line 166, in command
helpers._check_command_response(
File "C:\Users\User\Desktop\sparta\projects\mars\venv\lib\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'
로 나와요.
또 추가로 화성페이지에 배경화면이 안떠요..

파이참은 여러번 껐다 켜봤구요,
certifi도 깔았어요...
총체적난국입니다,.살려주세여...
