How lc-xander/mochilaiep-fullstack works
Mochila is a student schedule web app with account activation/login, personalized schedule viewing and day comparison, plus role-protected administration of students, subjects, schedules and activation codes. The server routes own API operations and query MySQL; the browser clients call those routes and render results. Connections reflect sampled source and README statements; administrative route coverage is documented, while some implementation details are unsampled.
Main entry points: mysql.js MySQL pool · auth.js Account access · script.js Student client · index.js HTTP server
Components 15
Web clients
- Student client
script.js - Admin client
admin.js - Day comparison
script.js
API and access
- HTTP server
server/index.js - Account access
server/routes/auth.js - Session and roles
server/middleware/auth.js
Schedule and administration
- Student schedules
server/routes/schedule.js - Admin operations
server/routes/admin.js - Activation codes
server/services/accessCodes.js
Persistence
- MySQL pool
server/db/mysql.js - Academic seed
server/db/seedData.js - Database schema
database/schema.sql
Other components
- Student
- Administrator
- MySQL
Connections 23
- Student → Student client: uses
README.md - Administrator → Admin client: uses
README.md - Student client → Account access: activates or logs in
script.js - Student client → Account access: checks session
script.js - Student client → Student schedules: requests schedule
script.js - Student client → Day comparison: renders comparison
script.js - Admin client → Admin operations: manages records
admin.js - Admin client → Account access: logs out
admin.js - HTTP server → Account access: mounts routes
server/index.js - HTTP server → Student schedules: mounts routes
server/index.js - HTTP server → Admin operations: mounts routes
server/index.js - HTTP server → Session and roles: loads session user
server/index.js - Account access → MySQL pool: queries users and codes
server/routes/auth.js - Account access → Academic seed: normalizes activation code
server/routes/auth.js - Session and roles → MySQL pool: loads user
server/middleware/auth.js - Student schedules → Session and roles: requires authentication
server/routes/schedule.js - Student schedules → MySQL pool: queries group schedule
server/routes/schedule.js - Admin operations → Session and roles: requires admin role
server/routes/admin.js - Admin operations → MySQL pool: queries and updates
server/routes/admin.js - Activation codes → MySQL pool: queries codes
server/services/accessCodes.js - Academic seed → MySQL pool: seeds records
server/db/seedData.js - MySQL pool → MySQL: connects
- Database schema → MySQL: defines tables
README.md