How ragz743/cpts_451_meta_capstone works
This is a Flask restaurant-management application backed by Oracle. Users enter through web routes to maintain customers, reservations, orders, order items, and payments, or view operational reports; route handlers execute SQL through a shared database helper and render HTML templates. The graph separates these domain areas while retaining the shared persistence and configuration layers. The excerpts establish several template-rendering links, but not every route-to-template relationship, so uncertain links are omitted.
Main entry points: app.py Flask routes · db.py SQL helper · config.py Runtime configuration · index.html Home page
Components 16
Web interface
- Flask routes
app.py - Home page
templates/index.html - Reservation pages
templates/reservations.html - Order pages
templates/orders.html - Order-item page
templates/order_items.html
Restaurant operations
- Customer management
app.py - Reservation management
app.py - Order management
app.py - Order-item management
app.py - Payment management
app.py - Operational reports
app.py
Persistence
- SQL helper
db.py - Runtime configuration
config.py - Oracle database
- Restaurant schema
schema.sql
Other components
- Browser user
Connections 21
- Browser user → Flask routes: uses routes
app.py - Flask routes → Home page: renders
app.py - Flask routes → Reservation pages: renders
app.py - Flask routes → Order pages: renders
app.py - Flask routes → Order-item page: renders
app.py - Flask routes → Customer management: dispatches to
app.py - Flask routes → Reservation management: dispatches to
app.py - Flask routes → Order management: dispatches to
app.py - Flask routes → Order-item management: dispatches to
app.py - Flask routes → Payment management: dispatches to
app.py - Flask routes → Operational reports: dispatches to
app.py - Customer management → SQL helper: queries
app.py - Reservation management → SQL helper: queries
app.py - Order management → SQL helper: queries
app.py - Order-item management → SQL helper: queries
app.py - Payment management → SQL helper: queries
app.py - Operational reports → SQL helper: queries
app.py - Flask routes → Runtime configuration: loads secret
app.py - SQL helper → Runtime configuration: loads credentials
db.py - SQL helper → Oracle database: connects to
db.py - Oracle database → Restaurant schema: stores data