
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.
DB연결때문에 그런건가 싶어서 DB연결 코드를 지워보기도 하고,
JSON이 chat GPT 통해서 오류를 고치려 노력하는데도 불구하고,
계속해서 콘솔에서 이런 오류가 뜹니다.ㅠㅠ
json 문제일 것 같아서 json설치를 새로 해보았으나 해결이 되지 않아요.
하지만, 코드에 어떤 문제가 있는지 잘 모르겠어요

작성한 코드 및 에러 메세지
Tip 1) </> 아이콘을 눌러 코드박스를 만들어 보세요.
Tip 2) Ctrl+A(맥의 경우 Command+A) 단축키로 코드를 한 번에 선택할 수 있어요!
app.py
from flask import Flask, render_template, request, jsonify
app = Flask(__name__)
from pymongo import MongoClient
client = MongoClient('mongodb+srv://sparta:<0000>@cluster0.bpdwmko.mongodb.net/?retryWrites=true&w=majority')
db = client.dbsparta
@app.route('/')
def home():
return render_template('index.html')
@app.route("/mars", methods=["POST"])
def 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 mars_get():
mars_data = list(db.mars.find({},{'_id':False}))
return jsonify({'result':'mars_data'})
if __name__ == '__main__':
app.run('0.0.0.0', port=5001, debug=True)
terminal
127.0.0.1 - - [06/May/2023 10:22:43] "GET / HTTP/1.1" 200 -
127.0.0.1 - - [06/May/2023 10:22:43] "GET /mars HTTP/1.1" 500 -
Traceback (most recent call last):
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 2213, in __call__
return self.wsgi_app(environ, start_response)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 2193, in wsgi_app
response = self.handle_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 2190, in wsgi_app
response = self.full_dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 1486, in full_dispatch_request
rv = self.handle_user_exception(e)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/app.py", line 29, in mars_get
mars_data = list(db.mars.find({},{'_id':False}))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/cursor.py", line 1207, in next
if len(self.__data) or self._refresh():
^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/cursor.py", line 1124, in _refresh
self.__send_message(q)
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/cursor.py", line 999, in __send_message
response = client._run_operation_with_response(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1368, in _run_operation_with_response
return self._retryable_read(
^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1464, in _retryable_read
with self._slaveok_for_server(read_pref, server, session,
File "/opt/homebrew/Cellar/python@3.11/3.11.3/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1309, in _slaveok_for_server
with self._get_socket(server, session, exhaust=exhaust) as sock_info:
File "/opt/homebrew/Cellar/python@3.11/3.11.3/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/mongo_client.py", line 1246, in _get_socket
with server.get_socket(
File "/opt/homebrew/Cellar/python@3.11/3.11.3/Frameworks/Python.framework/Versions/3.11/lib/python3.11/contextlib.py", line 137, in __enter__
return next(self.gen)
^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1225, in get_socket
sock_info = self._get_socket(all_credentials)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/pool.py", line 1279, in _get_socket
sock_info.check_auth(all_credentials)
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/pool.py", line 793, in check_auth
self.authenticate(credentials)
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/pool.py", line 810, in authenticate
auth.authenticate(credentials, self)
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/auth.py", line 673, in authenticate
auth_func(credentials, sock_info)
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/auth.py", line 591, in _authenticate_default
return _authenticate_scram(credentials, sock_info, 'SCRAM-SHA-1')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/auth.py", line 333, in _authenticate_scram
res = sock_info.command(source, cmd)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/pool.py", line 683, in command
return command(self, dbname, spec, slave_ok,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/network.py", line 159, in command
helpers._check_command_response(
File "/Users/chae_ah/Desktop/sparta/projects/02.mars/venv/lib/python3.11/site-packages/pymongo/helpers.py", line 167, in _check_command_response
raise OperationFailure(msg % errmsg, code, response,
pymongo.errors.OperationFailure: bad auth : authentication failed, full error: {'ok': 0, 'errmsg': 'bad auth : authentication failed', 'code': 8000, 'codeName': 'AtlasError'}
↓ index code
<!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() {
fetch('/mars').then((res) => res.json()).then((data) => {
console.log(data)
alert(data["msg"])
})
}
function save_order() {
let name = $('#name').val()
let address = $('address').val()
let size = $('size').val()
let formData = new FormData();
formData.append("name_give", name)
formData.append("address_give", address)
formData.append("size_give", size)
fetch('/mars', { method: "POST", body: formData }).then((res) => res.json()).then((data) => {
console.log(data);
alert(data['msg']);
});
}
</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 id="order-box">
<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>
