How lacambraeron/rrw works
Arizona Red Ribbon Week is a Flask campaign site with a PostgreSQL-backed event scheduler and protected staff tools. Visitors browse campaign information and submit event requests; staff review requests, approve event details, view an approved-events calendar, and export scheduler data. The site also provides a school-planning map and links to pledge and prevention resources. Routes and storage are sampled; other feature links reflect README documentation, so their internal wiring is not expanded beyond the documented behavior.
Main entry points: storage.py Database access · routes.py Campaign pages · __init__.py Flask app · pledge.html Pledge form
Components 21
Campaign site
- Flask app
app/__init__.py - Campaign pages
app/routes.py - Campaign templates
app/templates - Pledge form
app/templates/pledge.html - Prevention resources
app/routes.py
Event scheduler
- Registration workflow
app/routes.py - Registration templates
app/templates/register.html - Database access
app/storage.py
Staff tools
- Request review
app/routes.py - Approved calendar
app/routes.py - Excel export
app/routes.py - Approval email
app/routes.py
School planning
- School planning map
app/routes.py - School datasets
app/static/resources
Other components
- Visitor
- Staff user
- Arizona resources site
- Google Form
- PostgreSQL
- SMTP service
- Census geocoder
Connections 24
- Visitor → Flask app: requests pages
- Flask app → Campaign pages: dispatches routes
- Campaign pages → Campaign templates: renders pages
- Campaign pages → Pledge form: renders pledge
- Pledge form → Google Form: embeds form
- Campaign pages → Prevention resources: redirects request
- Prevention resources → Arizona resources site: redirects to
- Visitor → Registration workflow: submits request
- Registration workflow → Registration templates: renders workflow
- Registration workflow → Database access: reads and writes
- Flask app → Database access: initializes database
- Database access → PostgreSQL: queries and migrates
- Staff user → Request review: reviews requests
- Staff user → Approved calendar: views events
- Staff user → Excel export: requests export
- Request review → Database access: reads and updates
- Approved calendar → Database access: reads approvals
- Excel export → Database access: reads registrations
- Request review → Approval email: sends approval email
- Approval email → SMTP service: sends message
- Visitor → School planning map: opens map
- School planning map → School datasets: loads map data
- School planning map → Database access: reads approved locations
- School planning map → Census geocoder: geocodes addresses