Differential D3963

Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth
ClosedPublic
Actions

Authored by ieli on Feb 15 2026, 11:39.

Details

Reviewers

ieli

Commits

rSPbd4a46beabca: Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth

Summary

Database:

Expand schema with incident_update, incident_service, maintenance, and maintenance_service tables
Add ordering and timestamp columns to existing tables

Backend:

Add full CRUD endpoints for services, incidents, and maintenance
Add incident lifecycle (create → update → resolve) with update tracking
Add JWT authentication middleware for admin/write operations
Add start/dev scripts to package.json
Remove unused Sequelize dependency

API:

New RESTful routes (/api/services, /api/incidents, /api/maintenances)
Legacy endpoints preserved for backward compatibility
Public GET endpoints, authenticated POST/PUT/DELETE

Diff Detail

Repository

rSP ServPulse

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

ieli requested review of this revision.Feb 15 2026, 11:39

ieli created this revision.

Harbormaster completed remote builds in B6332: Diff 10271.Feb 15 2026, 11:39

ieli accepted this revision.Feb 15 2026, 11:41

This revision is now accepted and ready to land.Feb 15 2026, 11:41

Closed by commit rSPbd4a46beabca: Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth (authored by ieli). · Explain WhyFeb 15 2026, 11:42

This revision was automatically updated to reflect the committed changes.

ieli added a commit: rSPbd4a46beabca: Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth.

dereckson awarded a token.Feb 15 2026, 12:17

Revision Contents
Changeset List

Path

Size

.env.example

1 line

README.md

32 lines

backend/

Dockerfile

2 lines

app.js

2 lines

controllers/

incidentController.js

67 lines

maintenanceController.js

57 lines

serviceController.js

48 lines

middleware/

auth.js

25 lines

models/

incidentModel.js

36 lines

incidentUpdateModel.js

19 lines

38 lines

31 lines

324 lines

9 lines

routes/

incidentRoutes.js

8 lines

maintenanceRoutes.js

12 lines

serviceRoutes.js

10 lines

database/

init.sql

56 lines

Diff 10272

View Options

.env.example

View Options

README.md

View Options

backend/Dockerfile

View Options

backend/app.js

View Options

backend/controllers/incidentController.js

View Options

backend/controllers/maintenanceController.js

View Options

backend/controllers/serviceController.js

View Options

backend/middleware/auth.js

View Options

backend/models/incidentModel.js

View Options

backend/models/incidentUpdateModel.js

View Options

backend/models/maintenanceModel.js

View Options

backend/models/serviceModel.js

View Options

backend/package-lock.json

View Options

backend/package.json

View Options

backend/routes/incidentRoutes.js

View Options

backend/routes/maintenanceRoutes.js

View Options

backend/routes/serviceRoutes.js

View Options

Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT authClosedPublicActions

Details

Diff Detail

Event Timeline

Revision ContentsChangeset List

Diff 10272

.env.example

README.md

backend/Dockerfile

backend/app.js

backend/controllers/incidentController.js

backend/controllers/maintenanceController.js

backend/controllers/serviceController.js

backend/middleware/auth.js

backend/models/incidentModel.js

backend/models/incidentUpdateModel.js

backend/models/maintenanceModel.js

backend/models/serviceModel.js

backend/package-lock.json

backend/package.json

backend/routes/incidentRoutes.js

backend/routes/maintenanceRoutes.js

backend/routes/serviceRoutes.js

database/init.sql

Phase 2: Backend refactor with full CRUD API, expanded schema, and JWT auth
ClosedPublic
Actions

Revision Contents
Changeset List