How oukmnut/node-crud-api-fronend works
This Express/EJS application provides browser-based CRUD pages and a JSON API for users and products, backed by MySQL. Requests enter through the server’s mounted route sets, then controllers validate or shape responses and call the corresponding model; models execute SQL through a shared connection pool. The README documents the full page workflows and a narrower product API (GET/POST); it also notes that product API creation currently has mismatched fields. Views are represented as subsystem nodes because their individual templates were not sampled.
Main entry points: index.js Express Server · userController.js User Controller · productController.js Product Controller · userModel.js User Model
Components 17
HTTP Runtime
- Express Server
src/index.js
Browser CRUD
- User Pages
src/routes/userRoutes.js - User Controller
src/controllers/userController.js - User Templates
src/views/users - Product Pages
src/routes/productRoutes.js - Product Controller
src/controllers/productController.js - Product Templates
src/views/product
JSON API
- User API Routes
src/routes/apiUserRoutes.js - User API Handlers
src/controllers/userController.js - Product API Routes
src/routes/apiProductRoutes.js - Product API Handlers
src/controllers/productController.js
MySQL Persistence
- User Model
src/models/userModel.js - Product Model
src/models/productModel.js - MySQL Pool
src/config/db.js
Other components
- Browser
- API Client
- MySQL Database
Connections 19
- Browser → Express Server: sends requests
README.md - API Client → Express Server: sends requests
README.md - Express Server → User Pages: mounts routes
src/index.js - Express Server → Product Pages: mounts routes
src/index.js - Express Server → User API Routes: mounts routes
src/index.js - Express Server → Product API Routes: mounts routes
src/index.js - User Pages → User Controller: dispatches to
src/routes/userRoutes.js - Product Pages → Product Controller: dispatches to
src/routes/productRoutes.js - User Controller → User Model: calls
src/controllers/userController.js - Product Controller → Product Model: calls
src/controllers/productController.js - User Controller → User Templates: renders
src/controllers/userController.js - Product Controller → Product Templates: renders
src/controllers/productController.js - User API Routes → User API Handlers: dispatches to
src/routes/apiUserRoutes.js - Product API Routes → Product API Handlers: dispatches to
src/routes/apiProductRoutes.js - User API Handlers → User Model: calls
src/controllers/userController.js - Product API Handlers → Product Model: calls
src/controllers/productController.js - User Model → MySQL Pool: executes queries
src/models/userModel.js - Product Model → MySQL Pool: executes queries
src/models/productModel.js - MySQL Pool → MySQL Database: connects to
src/config/db.js