❗ 리팩토링 중입니다... ❗
🏦 Database Design Assignment Banking DB with Flask
📃 DB Assignment Intro
📣 설명
1️⃣ 간단한 은행 기능 구현
2️⃣ 일정 상 Flask를 사용해서 빠르게 구현
3️⃣ 기본적인 입출금 기능 구현
4️⃣ PPT 생략
5️⃣ 발표자 역할: 입출력 부분 + 기본 기능 시현
➕ 추가 사항
1️⃣ 일정 (기말고사 전까지)
2️⃣ 기본 기능 구현
3️⃣ 2022.03.24: 시간생기면 코드 리팩토링하기
🌐 Assignment DB Schema
📂 API
URL |
PAGE |
/ |
index.html |
/user |
user.html |
/user/info |
user.html |
/card |
card.html |
/account |
account.html |
/account-record/deposit |
account_record.html |
/account-record/fetch |
account_record.html |
/account-record |
account_record.html |
🕹️ Used SQL statements
1️⃣ sql = """select * from user where user_name = %s;"""
2️⃣ sql = """update user set user_address=%s, user_job=%s where user_SSN= %s"""
3️⃣ sql = """select c.card_limit, u.user_name from card c, user u
where c.card_user_SSN = %s and u.user_SSN=%s;"""
4️⃣ sql = """select
a.account_user_name, a.account_user_phone, a.account_user_email, ar.account_category, ar.account_content, ar.record_amount, ar.account_left
from user_account a, account_record ar
where a.account_user_SSN = %s and a.account_id = ar.account_id;"""
5️⃣ sql = "select account_id from user_account where account_user_SSN= %s;"
6️⃣ sql = """insert into account_record(account_id, banking_date, record_number, account_category, account_content, record_amount, account_left)
values(%s, %s, %s, %s, %s, %s, %s); commit;"""
7️⃣ sql = "select account_id from user_account where account_user_SSN= %s;"
8️⃣ sql = "select * from account_record;"
💾 Tech
1️⃣ Python3
2️⃣ Flask
3️⃣ sqlalchemy
❓ How to run
$flask run
🔺 Improvements
1️⃣ 코드 리팩토링하기(로직 분리, 전역 변수 없애기)
2️⃣ URL 경로 수정하기