커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
4주차 마지막 숙제를 하는데 몽고디비 연결에 문제가 있는거 같습니다 !
undefined주차
북마크
강*구
댓글
4
추천
0
조회수
14
조회수
14
답변 완료
작성한 글이 다 날라겠네요 !
인덱스에서 닉네임과 응원댓글을 가져오는건 로그값으로 나오는데
몽고디비에 내용이 들어가지 않습니다 ㅠㅠ

---




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.wjhqjga.mongodb.net/Cluster0?retryWrites=true&w=majority',tlsCAFile=ca)
db = client.dbsparta

@app.route('/')
def home():
   return render_template('index.html')

@app.route("/homework", methods=["POST"])
def homework_post():
    name_receive = request.form['name_give']
    comment_receive = request.form['comment_give']
    doc = {
        'name': name_receive,
        'comment': comment_receive
    }
    db.homework.insert_one(doc)

    return jsonify({'msg':'저장 완료!'})

@app.route("/homework", methods=["GET"])
def homework_get():
    return jsonify({'msg':'GET 연결 완료!'})

if __name__ == '__main__':
   app.run('0.0.0.0', port=5001, debug=True)


----


index

<!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>

    <title>초미니홈피 - 팬명록</title>

    <link href="https://fonts.googleapis.com/css2?family=Noto+Serif+KR:wght@200;300;400;500;600;700;900&display=swap" rel="stylesheet">
    <style>
        * {
            font-family: 'Noto Serif KR', serif;
        }
        .mypic {
            width: 100%;
            height: 300px;

            background-image: linear-gradient(0deg, rgba(0, 0, 0, 0.5), rgba(0, 0, 0, 0.5)), url('https://thumb.mt.co.kr/06/2021/02/2021020409438255271_1.jpg/dims/optimize/');
            background-position: center 30%;
            background-size: cover;

            color: white;

            display: flex;
            flex-direction: column;
            align-items: center;
            justify-content: center;
        }

        .mypost {
            width: 95%;
            max-width: 500px;
            margin: 20px auto 20px auto;

            box-shadow: 0px 0px 3px 0px black;
            padding: 20px;
        }

        .mypost > button {
            margin-top: 15px;
        }

        .mycards {
            width: 95%;
            max-width: 500px;
            margin: auto;
        }

        .mycards > .card {
            margin-top: 10px;
            margin-bottom: 10px;
        }
    </style>
    <script>
        $(document).ready(function(){
            set_temp()
            show_comment()
        });
        function set_temp(){
            $.ajax({
                type: "GET",
                url: "http://spartacodingclub.shop/sparta_api/weather/seoul",
                data: {},
                success: function (response) {
                    $('#temp').text(response['temp'])
                }
            })
        }
        function save_comment(){

            let name = $('#name').val()
            let comment = $('#comment').val()


            $.ajax({
                type: 'POST',
                url: '/homework',
                data: {name_give: name, comment_give: comment},
                success: function (response) {
                    console.log (name, comment)
                    alert(response['msg'])
                    window.location.reload()
                }
            })
        }
        function show_comment(){
            $.ajax({
                type: "GET",
                url: "/homework",
                data: {},
                success: function (response){
                // let rows = response['comments']
                // for (let i = 0; i < rows.length; i++){
                //     let name = rows[i]['name']
                //     let comment = rows[i]['comment']
                //
                //     console.log(name, comment)

        //

                    // console.log(name)
                    alert(response["msg"])
                }
            });
        }
    </script>
</head>
<body>
    <div class="mypic">
        <h1> 아이유 팬명록🎤</h1>
        <p>현재기온: <span id="temp">36</span>도</p>
    </div>
    <div class="mypost">
        <div class="form-floating mb-3">
            <input type="text" class="form-control" id="name" placeholder="url">
            <label for="floatingInput">닉네임</label>
        </div>
        <div class="form-floating">
            <textarea class="form-control" placeholder="Leave a comment here" id="comment"
                style="height: 100px"></textarea>
            <label for="floatingTextarea2">응원댓글</label>
        </div>
        <button onclick="save_comment()" type="button" class="btn btn-dark">응원 남기기</button>
    </div>
    <div class="mycards" id="comment-list">
        <div class="card">
            <div class="card-body">
                <blockquote class="blockquote mb-0">
                    <p>새로운 앨범 너무 멋져요!</p>
                    <footer class="blockquote-footer">호빵맨</footer>
                </blockquote>
            </div>
        </div>
        <div class="card">
            <div class="card-body">
                <blockquote class="blockquote mb-0">
                    <p>새로운 앨범 너무 멋져요!</p>
                    <footer class="blockquote-footer">호빵맨</footer>
                </blockquote>
            </div>
        </div>
        <div class="card">
            <div class="card-body">
                <blockquote class="blockquote mb-0">
                    <p>새로운 앨범 너무 멋져요!</p>
                    <footer class="blockquote-footer">호빵맨</footer>
                </blockquote>
            </div>
        </div>
    </div>
</body>
</html>

-----


/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/bin/python /Users/hyungukang/Desktop/sparta/projects/homework/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:5001
 * Running on http://192.168.10.180:5001
Press CTRL+C to quit
 * Restarting with stat
 * Debugger is active!
 * Debugger PIN: 854-421-199
127.0.0.1 - - [07/Jan/2023 11:40:47] "GET / HTTP/1.1" 200 -
127.0.0.1 - - [07/Jan/2023 11:40:48] "GET /homework HTTP/1.1" 200 -
127.0.0.1 - - [07/Jan/2023 11:41:28] "POST /homework HTTP/1.1" 500 -
Traceback (most recent call last):
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 2548, in __call__
    return self.wsgi_app(environ, start_response)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 2528, in wsgi_app
    response = self.handle_exception(e)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 2525, in wsgi_app
    response = self.full_dispatch_request()
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 1822, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 1820, in full_dispatch_request
    rv = self.dispatch_request()
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/flask/app.py", line 1796, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
  File "/Users/hyungukang/Desktop/sparta/projects/homework/app.py", line 21, in homework_post
    db.homework.insert_one(doc)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/collection.py", line 628, in insert_one
    self._insert_one(
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/contextlib.py", line 119, in __enter__
    return next(self.gen)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "/Users/hyungukang/Desktop/sparta/projects/movie/homework/venv/lib/python3.9/site-packages/pymongo/topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-hsxwbjd-shard-00-02.wjhqjga.mongodb.net:27017: connection closed,ac-hsxwbjd-shard-00-01.wjhqjga.mongodb.net:27017: connection closed,ac-hsxwbjd-shard-00-00.wjhqjga.mongodb.net:27017: connection closed, Timeout: 30s, Topology Description: <TopologyDescription id: 63b8dbae10856aceb4ae4dec, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-hsxwbjd-shard-00-00.wjhqjga.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hsxwbjd-shard-00-00.wjhqjga.mongodb.net:27017: connection closed')>, <ServerDescription ('ac-hsxwbjd-shard-00-01.wjhqjga.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hsxwbjd-shard-00-01.wjhqjga.mongodb.net:27017: connection closed')>, <ServerDescription ('ac-hsxwbjd-shard-00-02.wjhqjga.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-hsxwbjd-shard-00-02.wjhqjga.mongodb.net:27017: connection closed')>]>


취소
 공유
취소
댓글 0
댓글 알림
나의얼굴