본문 바로가기
[스파르타 코딩클럽]/비개발자를 위한, 웹개발 종합반

팬명록 -GET-

by 수민띠 2023. 2. 26.

버킷리스트 조회 API(GET)

데이터 명세

요청 정보: URL= /guestbook, 요청 방식 = GET

클라(fetch) → 서버(flask) : 없음

서버(flask) → 클라(fetch) : DB에 저장된 모든 응원 목록

 

클라이언트와 서버 연결 확인하기

웹에 접속했을 때 서버로부터 메시지를 받는지 확인

 

서버 만들기

받을 것 없이 DB에서 찾은 데이터를 변수에 담아서 클라이언트한테 보낸다.

@app.route("/guestbook", methods=["GET"])
def guestbook_get():
    all_comment = list(db.fan.find({},{'_id':False}))
    
    return jsonify({'result': all_comment })

 

클라이언트 만들기

step1. 서버한테 받은 데이터 console에 확인해보기

step2. 받은 데이터 저장하기 ※서버한테 객체로 받은 점 유의

step3. forEach로 데이터 뽑기

step4. 추가할 요소 만들고 변수에 저장하기

step5. 요소 추가하기 - jQuery

step6. 새로고침 (기존 html코드를 지우는 용도)

function show_comment() {
      fetch('/guestbook').then((res) => res.json()).then((data) => {
        let rows = data['result']
        $('#comment-list').empty();
        rows.forEach((a) =>{
          let name = a['name'];
          let comment = a['comment'];

          temp_html = ` <div class="card">
                            <div class="card-body">
                              <blockquote class="blockquote mb-0">
                                <p>${comment}</p>
                                <footer class="blockquote-footer">${name}</footer>
                              </blockquote>
                            </div>
                        </div>`
          $('#comment-list').append(temp_html);
        })
      })
    }

 

동작 확인

화면을 새로고침 했을 때, DB에 저장된 응원이 화면에 올바르게 나타나는지 확인

팬명록 app.py

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

from pymongo import MongoClient
client = MongoClient('몽고DB주소')
db = client.dbsparta


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

@app.route("/guestbook", methods=["POST"])
def guestbook_post():
    name_receive = request.form['name_give']
    comment_receive = request.form['comment_give']

    doc = {
        'name':name_receive,
        'comment':comment_receive
        }
    db.fan.insert_one(doc)

    return jsonify({'msg': '응원 완료!'})

@app.route("/guestbook", methods=["GET"])
def guestbook_get():
    all_comment = list(db.fan.find({},{'_id':False}))
    
    return jsonify({'result': all_comment })

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>

  <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://cdn.topstarnews.net/news/photo/201807/456143_108614_510.jpg");
      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() {
      fetch("http://spartacodingclub.shop/sparta_api/weather/seoul").then((res) => res.json()).then((data) => {
        let temp = data['temp'];
        $('#temp').text(temp);
      });
    }
    function save_comment() {
      let name = $('#name').val();
      let comment = $('#comment').val();

      let formData = new FormData();
      formData.append("name_give", name);
      formData.append("comment_give", comment);

      fetch('/guestbook', { method: "POST", body: formData, }).then((res) => res.json()).then((data) => {
        window.location.reload();
      });
    }
    function show_comment() {
      fetch('/guestbook').then((res) => res.json()).then((data) => {
        let rows = data['result']
        $('#comment-list').empty();
        rows.forEach((a) =>{
          let name = a['name'];
          let comment = a['comment'];

          temp_html = ` <div class="card">
                            <div class="card-body">
                              <blockquote class="blockquote mb-0">
                                <p>${comment}</p>
                                <footer class="blockquote-footer">${name}</footer>
                              </blockquote>
                            </div>
                        </div>`
          $('#comment-list').append(temp_html);
        })
      })
    }
  </script>
</head>

<body>
  <div class="mypic">
    <h1>십센치(10cm) 팬명록</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>