스파르타코딩클럽, [왕초보] 비개발자를 위한, 웹개발 종합반 4주차 개발일지

Dongwoo Kim·2022년 4월 14일
0
  • flask - get 요청
    • app.py
      # 주문 목록보기(Read) API
      @app.route('/order', methods=['GET'])
      def view_orders():
          sample_receive = request.args.get('sample_give')
          print(sample_receive)
          return jsonify({'msg': '이 요청은 GET!'})
    • index.html
      <stript>
      	function order_listing() {
      	            // 주문목록 보기 API 연결
      							$.ajax({
      	                type: "GET",
      	                url: "/order?sample_give=샘플데이터",
      	                data: {},
      	                success: function (response) {
      	                    alert(response["msg"]);
      	                }
      	            })
      	        }
      </stript>
  • flask - post 요청
    • app.py
      # 주문하기(POST) API
      @app.route('/order', methods=['POST'])
      def save_order():
          sample_receive = request.form['sample_give']
          print(sample_receive)
          return jsonify({'msg': '이 요청은 POST!'})
    • index.html
      <stript>
      		function order() {
      		            // 주문하기 API 연결
      								$.ajax({
      		                type: "POST",
      		                url: "/order",
      		                data: {sample_give:'샘플데이터'},
      		                success: function (response) { // 성공하면
      		                    alert(response["msg"]);
      		                }
      		            })
      		        }
      </stript>
  • example project - 1. bookreview
    • app.py
      from flask import Flask, render_template, jsonify, request
      app = Flask(__name__)
      
      from pymongo import MongoClient
      client = MongoClient('localhost', 27017)
      db = client.dbsparta
      
      ## HTML을 주는 부분
      @app.route('/')
      def home():
          return render_template('index.html')
      
      ## API 역할을 하는 부분
      @app.route('/review', methods=['POST'])
      def write_review():
          title_receive = request.form['title_give']
          author_receive = request.form['author_give']
          review_receive = request.form['review_give']
      
          doc = {
              'title': title_receive,
              'author': author_receive,
              'review': review_receive
          }
          db.bookreview.insert_one(doc)
      
          return jsonify({'msg': '이 요청은 POST!'})
      
      @app.route('/review', methods=['GET'])
      def read_reviews():
      
          reviews = list(db.bookreview.find({},{'_id':False}))
      
          return jsonify({'all_reviews': reviews})
      
      if __name__ == '__main__':
          app.run('0.0.0.0', port=5000, debug=True)
    • index.html
      <!DOCTYPE html>
      <html lang="ko">
      
          <head>
              <!-- Webpage Title -->
              <title>모두의 책리뷰 | 스파르타코딩클럽</title>
      
              <!-- Required meta tags -->
              <meta charset="utf-8">
              <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      
              <!-- Bootstrap CSS -->
              <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
                    integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm"
                    crossorigin="anonymous">
      
              <!-- JS -->
              <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
              <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
                      integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
                      crossorigin="anonymous"></script>
      
              <!-- 구글폰트 -->
              <link href="https://fonts.googleapis.com/css?family=Do+Hyeon&display=swap" rel="stylesheet">
      
              <script type="text/javascript">
      
                  $(document).ready(function () {
                      showReview();
                  });
      
                  function makeReview() {
                      // 화면에 입력어 있는 제목, 저자, 리뷰 내용을 가져옵니다.
                      let title = $("#title").val();
                      let author = $("#author").val();
                      let review = $("#bookReview").val();
      
                      // POST /review 에 저장(Create)을 요청합니다.
                      $.ajax({
                          type: "POST",
                          url: "/review",
                          data: {
                              title_give: title,
                              author_give: author,
                              review_give: review
                          },
                          success: function (response) {
                              alert(response["msg"]);
                              window.location.reload();
                          }
                      })
                  }
      
                  function showReview() {
                      $('#reviews-box').empty();
      
                      $.ajax({
                          type: "GET",
                          url: "/review",
                          data: {},
                          success: function (response) {
                              let reviews = response['all_reviews']
      
                              for(let i = 0; i < reviews.length; i++){
                                  let title = reviews[i]['title'];
                                  let author = reviews[i]['author']
                                  let review = reviews[i]['review']
      
                                  let temp_html = `<tr>
                                                      <td>${title}</td>
                                                      <td>${author}</td>
                                                      <td>${review}</td>
                                                  </tr>`
      
                                  $('#reviews-box').append(temp_html)
                              }
                          }
                      })
                  }
              </script>
      
              <style type="text/css">
                  * {
                      font-family: "Do Hyeon", sans-serif;
                  }
      
                  h1,
                  h5 {
                      display: inline;
                  }
      
                  .info {
                      margin-top: 20px;
                      margin-bottom: 20px;
                  }
      
                  .review {
                      text-align: center;
                  }
      
                  .reviews {
                      margin-top: 100px;
                  }
              </style>
          </head>
      
          <body>
              <div class="container">
                  <img src="https://previews.123rf.com/images/maxxyustas/maxxyustas1511/maxxyustas151100002/47858355-education-concept-books-and-textbooks-on-the-bookshelf-3d.jpg"
                       class="img-fluid" alt="Responsive image">
                  <div class="info">
                      <h1>읽은 책에 대해 말씀해주세요.</h1>
                      <p>다른 사람을 위해 리뷰를 남겨주세요! 다 같이 좋은 책을 읽는다면 다 함께 행복해질 수 있지 않을까요?</p>
                      <div class="input-group mb-3">
                          <div class="input-group-prepend">
                              <span class="input-group-text">제목</span>
                          </div>
                          <input type="text" class="form-control" id="title">
                      </div>
                      <div class="input-group mb-3">
                          <div class="input-group-prepend">
                              <span class="input-group-text">저자</span>
                          </div>
                          <input type="text" class="form-control" id="author">
                      </div>
                      <div class="input-group mb-3">
                          <div class="input-group-prepend">
                              <span class="input-group-text">리뷰</span>
                          </div>
                          <textarea class="form-control" id="bookReview"
                                    cols="30"
                                    rows="5" placeholder="140자까지 입력할 수 있습니다."></textarea>
                      </div>
                      <div class="review">
                          <button onclick="makeReview()" type="button" class="btn btn-primary">리뷰 작성하기</button>
                      </div>
                  </div>
                  <div class="reviews">
                      <table class="table">
                          <thead>
                          <tr>
                              <th scope="col">제목</th>
                              <th scope="col">저자</th>
                              <th scope="col">리뷰</th>
                          </tr>
                          </thead>
                          <tbody id="reviews-box">
      
                          </tbody>
                      </table>
                  </div>
              </div>
          </body>
      
      </html>
  • example project - 2. alonememo
    • app.py
      from flask import Flask, render_template, jsonify, request
      app = Flask(__name__)
      
      import requests
      from bs4 import BeautifulSoup
      
      from pymongo import MongoClient
      client = MongoClient('localhost', 27017)
      db = client.dbsparta
      
      ## HTML을 주는 부분
      @app.route('/')
      def home():
         return render_template('index.html')
      
      @app.route('/memo', methods=['GET'])
      def listing():
          articles = list(db.articles2.find({}, {'_id': False}))
      
          return jsonify({'articles': articles})
      
      ## API 역할을 하는 부분
      @app.route('/memo', methods=['POST'])
      def saving():
          url_receive = request.form['url_give']
          comment_receive = request.form['comment_give']
      
          headers = {
              'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36'}
          data = requests.get(url_receive, headers=headers)
      
          soup = BeautifulSoup(data.text, 'html.parser')
      
          # 여기에 코딩을 해서 meta tag를 먼저 가져와보겠습니다.
      
          title = soup.select_one('meta[property="og:title"]')['content']
          image = soup.select_one('meta[property="og:image"]')['content']
          desc = soup.select_one('meta[property="og:description"]')['content']
      
          doc = {
              'title': title,
              'image': image,
              'desc': desc,
              'url': url_receive,
              'comment': comment_receive
          }
          db.articles2.insert_one(doc)
      
          return jsonify({'msg':'저장 완료'})
      
      if __name__ == '__main__':
         app.run('0.0.0.0',port=5000,debug=True)
    • index.html
      <!Doctype html>
      <html lang="ko">
      
          <head>
              <!-- Required meta tags -->
              <meta charset="utf-8">
              <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      
              <!-- Bootstrap CSS -->
              <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
                    integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm"
                    crossorigin="anonymous">
      
              <!-- JS -->
              <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
              <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
                      integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
                      crossorigin="anonymous"></script>
      
              <!-- 구글폰트 -->
              <link href="https://fonts.googleapis.com/css?family=Stylish&display=swap" rel="stylesheet">
      
              <title>스파르타코딩클럽 | 나홀로 메모장</title>
      
              <!-- style -->
              <style type="text/css">
                  * {
                      font-family: "Stylish", sans-serif;
                  }
      
                  .wrap {
                      width: 900px;
                      margin: auto;
                  }
      
                  .comment {
                      color: blue;
                      font-weight: bold;
                  }
      
                  #post-box {
                      width: 500px;
                      margin: 20px auto;
                      padding: 50px;
                      border: black solid;
                      border-radius: 5px;
                  }
              </style>
              <script>
                  $(document).ready(function () {
                      showArticles();
                  });
      
                  function openClose() {
                      if ($("#post-box").css("display") == "block") {
                          $("#post-box").hide();
                          $("#btn-post-box").text("포스팅 박스 열기");
                      } else {
                          $("#post-box").show();
                          $("#btn-post-box").text("포스팅 박스 닫기");
                      }
                  }
      
                  function postArticle() {
                      let url = $('#post-url').val()
                      let comment = $('#post-comment').val()
      
                      $.ajax({
                          type: "POST",
                          url: "/memo",
                          data: {
                              url_give: url,
                              comment_give: comment
                          },
                          success: function (response) { // 성공하면
                              alert(response["msg"]);
                              window.location.reload();
                          }
                      })
                  }
      
                  function showArticles() {
                      $('#cards-box').empty()
      
                      $.ajax({
                          type: "GET",
                          url: "/memo",
                          data: {},
                          success: function (response) {
                              let articles = response['articles']
                              for(let i = 0; i< articles.length; i++){
                                  let title = articles[i]['title']
                                  let image = articles[i]['image']
                                  let desc = articles[i]['desc']
                                  let url = articles[i]['url']
                                  let comment = articles[i]['comment']
      
                                  let temp_html = `<div class="card">
                                                      <img class="card-img-top"
                                                           src="${image}"
                                                           alt="Card image cap">
                                                      <div class="card-body">
                                                          <a target="_blank" href="${url}" class="card-title">${title}</a>
                                                          <p class="card-text">${desc}</p>
                                                          <p class="card-text comment">${comment}</p>
                                                      </div>
                                                  </div>`
      
                                  $('#cards-box').append(temp_html)
                              }
                          }
                      })
                  }
              </script>
      
          </head>
      
          <body>
              <div class="wrap">
                  <div class="jumbotron">
                      <h1 class="display-4">나홀로 링크 메모장!</h1>
                      <p class="lead">중요한 링크를 저장해두고, 나중에 볼 수 있는 공간입니다</p>
                      <hr class="my-4">
                      <p class="lead">
                          <button onclick="openClose()" id="btn-post-box" type="button" class="btn btn-primary">포스팅 박스 열기
                          </button>
                      </p>
                  </div>
                  <div id="post-box" class="form-post" style="display:none">
                      <div>
                          <div class="form-group">
                              <label for="post-url">아티클 URL</label>
                              <input id="post-url" class="form-control" placeholder="">
                          </div>
                          <div class="form-group">
                              <label for="post-comment">간단 코멘트</label>
                              <textarea id="post-comment" class="form-control" rows="2"></textarea>
                          </div>
                          <button type="button" class="btn btn-primary" onclick="postArticle()">기사저장</button>
                      </div>
                  </div>
                  <div id="cards-box" class="card-columns">
                  </div>
              </div>
          </body>
      
      </html>
  • homework
    • app.py
      from flask import Flask, render_template, jsonify, request
      
      app = Flask(__name__)
      
      from pymongo import MongoClient
      
      client = MongoClient('localhost', 27017)
      db = client.dbhomework
      
      ## HTML 화면 보여주기
      @app.route('/')
      def homework():
          return render_template('index.html')
      
      # 주문하기(POST) API
      @app.route('/order', methods=['POST'])
      def save_order():
          name = request.form['name']
          count = request.form['count']
          address = request.form['address']
          phone = request.form['phone']
      
          doc = {
              'name': name,
              'count': count,
              'address': address,
              'phone': phone
          }
      
          db.orders2.insert_one(doc)
      
          return jsonify({'msg': '저장 완료'})
      
      # 주문 목록보기(Read) API
      @app.route('/order', methods=['GET'])
      def view_orders():
      
          orders = list(db.orders2.find({}, {'_id': False}))
      
          return jsonify({'orders': orders,'msg': '주문 조회 완료'})
      
      if __name__ == '__main__':
          app.run('0.0.0.0', port=5000, debug=True)
    • index.html
      <!doctype html>
      <html lang="en">
      
      <head>
          <!-- Required meta tags -->
          <meta charset="utf-8">
          <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
      
          <!-- Bootstrap CSS -->
          <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
              integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
      
          <!-- Optional JavaScript -->
          <!-- jQuery first, then Popper.js, then Bootstrap JS -->
          <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
          <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
              integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
              crossorigin="anonymous"></script>
          <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"
              integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
              crossorigin="anonymous"></script>
      
          <title>스파르타코딩클럽 | 부트스트랩 연습하기</title>
      
          <link rel="preconnect" href="https://fonts.googleapis.com">
          <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
          <link href="https://fonts.googleapis.com/css2?family=Dongle&display=swap" rel="stylesheet">
      
          <style>
              * {
                  font-family: 'Dongle', sans-serif;
              }
      
              .body_box {
                  width: 300px;
                  margin: auto;
              }
      
              .product_img {
                  width: 300px;
                  height: 300px;
      
                  background-image: url("https://media.bunjang.co.kr/product/183489786_1_1648527887_w360.jpg");
                  background-size: cover;
                  background-position: center;
      
                  border-radius: 20px;
                  margin: 30px auto 30px auto;
              }
      
              .product_price {
                  font-size: 20px;
              }
      
              .order_btn {
                  width: 100px;
                  display: block;
                  margin: auto auto 30px auto;
              }
      
              .blue_font {
                  color: blue;
              }
          </style>
      
          <script>
              $(document).ready(function () {
                  $('#rate-box').empty();
                  $.ajax({
                      type: "GET",
                      url: "http://spartacodingclub.shop/sparta_api/rate",
                      data: {},
                      success: function (response) {
                          let rate = response['rate']
                          let temp_html = `<p class="blue_font">달러-원 환율 : ${rate}</p>`
                          $('#rate-box').append(temp_html)
                      }
                  })
      
                 order_listing();
              });
      
              function order_listing() {
                  $('#order_list').empty()
      
                  // 주문목록 보기 API 연결
                  $.ajax({
                      type: "GET",
                      url: "/order",
                      data: {},
                      success: function (response) {
                          let orders = response['orders']
                          for(let i = 0; i < orders.length; i++){
                              let name = orders[i]['name']
                              let count = orders[i]['count']
                              let address = orders[i]['address']
                              let phone = orders[i]['phone']
      
                              let temp_html = `<tr>
                                                  <th scope="row">${name}</th>
                                                  <td>${count}</td>
                                                  <td>${address}</td>
                                                  <td>${phone}</td>
                                              </tr>`
      
                              $('#order_list').append(temp_html)
                          }
      
                      }
                  })
              }
      
              function order() {
                  let name = $('#name_box').val()
                  let count = $('#inputGroupSelect01').val()
                  let address = $('#address_box').val()
                  let phone = $('#phone_box').val()
      
                  // 주문하기 API 연결
                  $.ajax({
                      type: "POST",
                      url: "/order",
                      data: {
                          name: name,
                          count: count,
                          address: address,
                          phone: phone
                      },
                      success: function (response) { // 성공하면
                          alert(response["msg"]);
                      }
                  })
      
                  window.location.reload();
              }
      
          </script>
      
      </head>
      
      <body>
          <div class="body_box">
              <div class="product_img"></div>
              <h1>모코코 무드등 팝니다 <span class="product_price">가격: 45000원/개</span></h1>
      
              <div id="rate-box"></div>
              <div class="input-group mb-3">
                  <div class="input-group-prepend">
                      <span class="input-group-text" id="inputGroup-sizing-default">주문자 이름</span>
                  </div>
                  <input id="name_box" type="text" class="form-control" aria-label="Default" aria-describedby="inputGroup-sizing-default">
              </div>
      
              <div class="input-group mb-3">
                  <div class="input-group-prepend">
                      <label class="input-group-text" for="inputGroupSelect01">수량</label>
                  </div>
                  <select class="custom-select" id="inputGroupSelect01">
                      <option selected>--수량을 선택하세요--</option>
                      <option value="1">1</option>
                      <option value="2">2</option>
                      <option value="3">3</option>
                  </select>
              </div>
      
              <div class="input-group mb-3">
                  <div class="input-group-prepend">
                      <span class="input-group-text" id="inputGroup-sizing-default">주소</span>
                  </div>
                  <input id="address_box" type="text" class="form-control" aria-label="Default" aria-describedby="inputGroup-sizing-default">
              </div>
      
              <div class="input-group mb-3">
                  <div class="input-group-prepend">
                      <span class="input-group-text" id="inputGroup-sizing-default">전화번호</span>
                  </div>
                  <input id="phone_box" type="text" class="form-control" aria-label="Default"
                         aria-describedby="inputGroup-sizing-default">
              </div>
      
              <button type="button" onclick="order()" class="btn btn-primary order_btn">주문하기</button>
          </div>
          <table class="table">
              <thead>
              <tr>
                  <th scope="col">이름</th>
                  <th scope="col">수량</th>
                  <th scope="col">주소</th>
                  <th scope="col">전화번호</th>
              </tr>
              </thead>
              <tbody id="order_list">
              </tbody>
          </table>
      
      </body>
      
      </html>
profile
kimphysicsman

0개의 댓글