고정 헤더 영역
상세 컨텐츠
본문
from flask import Flask, render_template, request, url_for, abort, redirect, redirect
from bson.objectid import ObjectId
from pymongo import MongoClient
import math
client = MongoClient("")
db = client.d_bar
app = Flask(__name__)
@app.route("/", methods=["GET"])
def home():
# 페이지 값(값이 없는 경우 기본값은 1)
page = request.args.get("page", 1, type=int)
#한페이지당 몇개의 게시물을 출력할지
limit = request.args.get("limit", 2, type=int)
# 여기 중요 강의 다른부분 count_documents
mv_list = list(db.mv.find({}).skip((page-1)*limit).limit(limit).sort({"date":-1}))
tot_count = db.mv.count_documents({})
# 마지막 페이지의 수
last_page_num = math.ceil(tot_count / limit)
# 페이지 블럭울 5개씩 표기
block_size = 5
# 현재블럭의 위치
block_num = int((page - 1)/ block_size)
# 블럭의 시작의 위치
block_start = int((block_size * block_num )+ 1)
# 블럭의 끝 위치
block_last = math.ceil(block_start +(block_size) - 1)
return render_template("home.html",
lists=mv_list,
limit=limit,
page=page,
block_start=block_start,
block_last=block_last,
last_page_num=last_page_num)
@app.route("/mv_create/", methods=["GET", "POST"])
def mv_create():
if request.method == "GET":
return render_template("mv_create.html")
elif request.method == "POST":
date = request.form["inport_date"]
mv_name = request.form["mv_name"]
port_name = request.form["port_name"]
remark = request.form["remark"]
doc = {
"date": date,
"mv_name": mv_name,
"port_name": port_name,
"remark": remark,
}
x = db.mv.insert_one(doc)
return redirect(url_for("read", idx=x.inserted_id))
@app.route("/read/<idx>")
def read(idx):
if idx is not None:
data = db.mv.find_one({"_id": ObjectId(idx)})
if data is not None:
result = {
"id": data.get("_id"),
"date": data.get("date"),
"mv_name": data.get("mv_name"),
"port_name": data.get("port_name"),
"remark": data.get("remark"),
}
return render_template("read.html", result=result)
return abort(404)
@app.route("/update/<idx>", methods=["GET", "POST"])
def update(idx):
if request.method == "GET":
if id is not None:
data = db.mv.find_one({"_id": ObjectId(idx)})
if data is not None:
result = {
"id": data.get("_id"),
"date": data.get("date"),
"mv_name": data.get("mv_name"),
"port_name": data.get("port_name"),
"remark": data.get("remark"),
}
return render_template("update.html", result=result)
elif request.method == "POST":
idx = ObjectId(idx)
date = request.form["inport_date"]
mv_name = request.form["mv_name"]
port_name = request.form["port_name"]
remark = request.form["remark"]
db.mv.update_one(
{"_id": idx},
{
"$set": {
"date": date,
"mv_name": mv_name,
"port_name": port_name,
"remark": remark,
}
},
)
return redirect(url_for("read", idx=idx))
@app.route("/delete/<idx>/", methods=["POST"])
def delete(idx):
idx = ObjectId(idx)
db.mv.delete_one({"_id": idx})
return redirect("/")
if __name__ == "__main__":
app.run(debug=True, port=5001)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.1/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm"
crossorigin="anonymous"></script>
</head>
<body>
<nav class="navbar navbar-expand-lg bg-body-tertiary">
<div class="container-fluid">
<a class="navbar-brand" href="/">철근홈</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"
aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="/mv_create/">본선등록</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">본선내역관리</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">화주관리</a>
</li>
<li class="nav-item">
<a class="nav-link disabled" aria-disabled="true">화종관리</a>
</li>
</ul>
</div>
</div>
</nav>
<table class="table table-striped table table-bordered">
<thead class="table-primary">
<tr>
<td>순 번</td>
<td>입 항 일</td>
<td>본 선 명</td>
<td>하 역 사</td>
<td>비 고</td>
</tr>
<hr>
</thead>
<tbody>
{% for list in lists %}
<tr>
<td>
<a href="{{url_for('read',idx=list._id)}}">
{{loop.index}}
</a>
</td>
<td>
<a href="{{url_for('read',idx=list._id)}}">
{{list.date}}
</a>
</td>
<td>
<a href="{{url_for('read',idx=list._id)}}">
{{list.mv_name}}
</a>
</td>
<td>{{list.port_name}}</td>
<td>{{list.remark}}</td>
</tr>
{% endfor %}
</tbody>
</table>
{% if block_start -1 >0 %}
<a href = "{{url_for('home',page=block_start -1)}}">[이전]</a>
{% endif %}
{% for i in range(block_start, block_last +1) %}
{% if i == page %}
<b>{{i}}</b>
{% else %}
<a href="{{url_for('home',page=i)}}">{{i}}</a>
{% endif %}
{% endfor %}
{% if block_last < last_page_num %}
<a href = "{{url_for('home',page=block_last +1)}}">[다음]</a>
{% endif %}
</body>
</html>
