SA: Phase 4 Code Challenge Two Late Show API [COMPULSORY]

• Due Jun 24 by 11:59pm
• Points 12
• Submitting a website url
• Available after Jun 19 at 12am

🌙 Flask Code Challenge — Late Show API

🎯 Overview

You will build a Flask REST API for a Late Night TV show system from scratch, using:

✅ MVC architecture
✅ PostgreSQL (mandatory DB)
✅ Token-based authentication (JWT)
✅ Postman for API testing
✅ Git + GitHub for version control
✅ Full documentation in README.md

🗂 Suggested Folder Structure

💻 GitHub Repository Setup

✅ Create a new repo:
👉 github.com Links to an external site. → New repo → late-show-api-challenge → No README/.gitignore

✅ Initialize + push:

✅ .gitignore example:

🛠 Setup

✅ **Install dependencies:

**

✅ PostgreSQL DB setup

Create your database in Postgres:

✅ Set your DATABASE_URI in server/config.py

✅ Run DB setup

🧩 Models

User

• id
• username (unique)
• password_hash (hashed password)

Guest

• id
• name
• occupation

Episode

• id
• date
• number
• ✅ Cascade delete appearances on delete

Appearance

• id
• rating (1-5 validation)
• guest_id
• episode_id

🔐 Authentication

✅ Required tech:Flask-JWT-Extended
✅ Must include:

• POST /register → create a user
• POST /login → get JWT token

✅ Protect:

• POST /appearances
• DELETE /episodes/<int:id>

Clients must send:

🛠 Routes

🧪 Testing

✅ Import challenge-4-lateshow.postman_collection.json into Postman
✅ Include:

• Register + login
• Send the token in protected requests

📝 README.md Requirements

Your README.md must contain:

• Setup instructions (PostgreSQL, Flask, env vars)
• How to run (migrate, seed, run)
• Auth flow (register, login, token usage)
• Route list + sample request/response
• Postman usage guide
• GitHub repo link

✅ Submission Checklist

• MVC folder structure
• PostgreSQL used (✅ no SQLite)
• Models + validations complete
• Auth implemented + protected routes
• Seed data works
• All routes work and have been tested in Postman
• Clean, complete README.md
• GitHub repo pushed and shared