화성땅 주문하기 | 스파르타 커뮤니티

커뮤니티

포인트

쿠폰

내 강의실

국비 신청 내역

증명서

계정

로그아웃

학습 질문

개발 일지

나의 활동

답변 완료

화성땅 주문하기

undefined주차

이*진

・

추천

・

조회수

답변 완료

from flask import Flask, render_template, request, jsonify
app = Flask(__name__)

from pymongo import MongoClient
client = MongoClient('mongodb+srv://test:sparta@cluster0.cyjz0jp.mongodb.net/Cluster0?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():
    order_list = list(db.mars.find({}, {'_id': False}))
    return jsonify({'orders':order_list})

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) {
                    let rows = response['orders']
                    for (let i = 0; i < rows.length; i++) {
                        let name = rows[i]['name']
                        let address = rows[i]['address']
                        let size = rows[i]['size']

                        let temp_html = `<tr>
                                            <td>${name}</td>
                                            <td>${address}</td>
                                            <td>${size}</td>
                                          </tr>`
                        $('order-box').append(temp_html)
                    }

                }
            });
        }

        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 id="order-box">
        </tbody>
    </table>
</div>
</body>

"C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\Scripts\python.exe" "C:/Users/sunji/OneDrive/바탕 화면/spa/projects/mars/app.py"

* Serving Flask app 'app' (lazy loading)

* Environment: production

WARNING: This is a development server. Do not use it in a production deployment.

Use a production WSGI server instead.

* Debug mode: on

* Running on all addresses (0.0.0.0)

WARNING: This is a development server. Do not use it in a production deployment.

* Running on http://127.0.0.1:5000

* Running on http://119.206.21.41:5000 (Press CTRL+C to quit)

* Restarting with stat

* Debugger is active!

* Debugger PIN: 811-784-206

127.0.0.1 - - [27/Jul/2022 13:51:45] "GET / HTTP/1.1" 200 -

127.0.0.1 - - [27/Jul/2022 13:51:45] "GET /favicon.ico HTTP/1.1" 404 -

127.0.0.1 - - [27/Jul/2022 13:52:15] "GET /mars HTTP/1.1" 500 -

Traceback (most recent call last):

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2091, in __call__

return self.wsgi_app(environ, start_response)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2076, in wsgi_app

response = self.handle_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2073, in wsgi_app

response = self.full_dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1519, in full_dispatch_request

rv = self.handle_user_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1517, in full_dispatch_request

rv = self.dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1503, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\app.py", line 29, in web_mars_get

order_list = list(db.mars.find({}, {'_id': False}))

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\cursor.py", line 1248, in next

if len(self.__data) or self._refresh():

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\cursor.py", line 1139, in _refresh

self.__session = self.__collection.database.client._ensure_session()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session

return self.__start_session(True, causal_consistency=False)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session

self._topology._check_implicit_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

self._check_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

self._select_servers_loop(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다,ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다,ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다, Timeout: 30s, Topology Description: <TopologyDescription id: 62e0c45b7da2458b9094ed92, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>, <ServerDescription ('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>, <ServerDescription ('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>]>

127.0.0.1 - - [27/Jul/2022 13:52:17] "POST /mars HTTP/1.1" 500 -

Traceback (most recent call last):

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2091, in __call__

return self.wsgi_app(environ, start_response)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2076, in wsgi_app

response = self.handle_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2073, in wsgi_app

response = self.full_dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1519, in full_dispatch_request

rv = self.handle_user_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1517, in full_dispatch_request

rv = self.dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1503, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\app.py", line 23, in web_mars_post

db.mars.insert_one(doc)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one

self._insert_one(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\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\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, in _retryable_write

with self._tmp_session(session) as s:

File "C:\Users\sunji\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

return next(self.gen)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session

s = self._ensure_session(session)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session

return self.__start_session(True, causal_consistency=False)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session

self._topology._check_implicit_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

self._check_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

self._select_servers_loop(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다,ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다,ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: connection closed, Timeout: 30s, Topology Description: <TopologyDescription id: 62e0c45b7da2458b9094ed92, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>, <ServerDescription ('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: connection closed')>, <ServerDescription ('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>]>

127.0.0.1 - - [27/Jul/2022 13:52:20] "POST /mars HTTP/1.1" 500 -

Traceback (most recent call last):

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2091, in __call__

return self.wsgi_app(environ, start_response)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2076, in wsgi_app

response = self.handle_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2073, in wsgi_app

response = self.full_dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1519, in full_dispatch_request

rv = self.handle_user_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1517, in full_dispatch_request

rv = self.dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1503, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\app.py", line 23, in web_mars_post

db.mars.insert_one(doc)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one

self._insert_one(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\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\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, in _retryable_write

with self._tmp_session(session) as s:

File "C:\Users\sunji\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

return next(self.gen)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session

s = self._ensure_session(session)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session

return self.__start_session(True, causal_consistency=False)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session

self._topology._check_implicit_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

self._check_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

self._select_servers_loop(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

raise ServerSelectionTimeoutError(

pymongo.errors.ServerSelectionTimeoutError: ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: connection closed,ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: connection closed,ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다, Timeout: 30s, Topology Description: <TopologyDescription id: 62e0c45b7da2458b9094ed92, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-00.cyjz0jp.mongodb.net:27017: connection closed')>, <ServerDescription ('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-01.cyjz0jp.mongodb.net:27017: [WinError 10054] 현재 연결은 원격 호스트에 의해 강제로 끊겼습니다')>, <ServerDescription ('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-5fbijbh-shard-00-02.cyjz0jp.mongodb.net:27017: connection closed')>]>

127.0.0.1 - - [27/Jul/2022 13:52:21] "POST /mars HTTP/1.1" 500 -

Traceback (most recent call last):

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2091, in __call__

return self.wsgi_app(environ, start_response)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2076, in wsgi_app

response = self.handle_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 2073, in wsgi_app

response = self.full_dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1519, in full_dispatch_request

rv = self.handle_user_exception(e)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1517, in full_dispatch_request

rv = self.dispatch_request()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\flask\app.py", line 1503, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\app.py", line 23, in web_mars_post

db.mars.insert_one(doc)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\collection.py", line 621, in insert_one

self._insert_one(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\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\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1447, in _retryable_write

with self._tmp_session(session) as s:

File "C:\Users\sunji\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__

return next(self.gen)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1729, in _tmp_session

s = self._ensure_session(session)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1712, in _ensure_session

return self.__start_session(True, causal_consistency=False)

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\mongo_client.py", line 1657, in __start_session

self._topology._check_implicit_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support

self._check_session_support()

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support

self._select_servers_loop(

File "C:\Users\sunji\OneDrive\바탕 화면\spa\projects\mars\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop

raise ServerSelectionTimeoutError(

주문하기 버튼이 인식이 안됩니다.

댓글 알림