Express.ts API Template

A very mimimal REST API template using Express.ts, Sequelize and MySQL.

This project is designed to work with AnthonyBudd/Vuetify-SPA-Template

🔐 Auth using JWT's with Passport.js
👥 Simple DB: Users -∈ GroupsUsers ∋- Groups
🌐 Production-ready OpenApiSpec.yml & Kubernetes files
🥇 Real-world tested, generated over $50M in revenue

git clone git@github.com:anthonybudd/express-ts-api-template.git
cd express-ts-api-template

# [Optional] Find & Replace (case-sensaive, whole repo): "express-api" => "your-api-name" 
LC_ALL=C find . -type f -name '*.*' -exec sed -i '' s/express-api/your-api-name/g {} +

# Private RSA key for JWT signing
openssl genrsa -out private.pem 2048
openssl rsa -in private.pem -outform PEM -pubout -out public.pem

# Start app
cp .env.example .env
npm install
docker compose up
npm run _db:refresh

# [Optional] Code generation command
npm run generate -- --model="Book"
npm run _db:refresh

# [Optional] Interactive CRUD commands
npm run create --model="Book"
npm run index --model="Book" --prop="id" --value="name"
npm run get --model="Book" --id="c4644733-deea-47d8-b35a-86f30ff9618e"
npm run edit --model="Book" --id="c4644733-deea-47d8-b35a-86f30ff9618e"
npm run delete --model="Book" --id="c4644733-deea-47d8-b35a-86f30ff9618e"

DB Structure

The DB structure is the optimum balance of functionality and minimalism. A User can belong to many Groups through the GroupsUsers table. This allows you to make very basic single-user applications that do not even require the concept of groups or full SaaS solutions with complex User-Group relationships.

+--------------+           +---------------+         +--------------+  
|Users         | --------∈ |GroupsUsers    | ∋------ |Groups        |  
|--------------|           |---------------|         |--------------|  
|id            |           |id             |         |id            |  
|email         |           |groupID        |         |name          |  
|password      |           |userID         |         |ownerID       |  
|firstName     |           |role           |         |createdAt     |  
|lastName      |           |createdAt      |         |updatedAt     |
|createdAt     |           |updatedAt      |         +--------------+  
|updatedAt     |           +---------------+                                            
|...           |                                                      
+--------------+

Routes

Method	Route	Description	Payload	Response
GET	`/_readiness`	Kuber readiness check	--	"healthy"
GET	`/api/v1/_healthcheck`	Returns {status: 'ok'} if healthy	--	{status: 'ok'}
Auth
POST	`/api/v1/auth/login`	Login	{email, password}	{accessToken}
POST	`/api/v1/auth/sign-up`	Sign-up	{email, password, firstName, tos}	{accessToken}
GET	`/api/v1/_authcheck`	Returns {auth: true} if has auth	--	{auth: true}
GET	`/api/v1/auth/verify-email/:emailVerificationKey`	Verify email	--	{success: true}
GET	`/api/v1/auth/resend-verification-email`	Resend verification email	--	{email}
POST	`/api/v1/auth/forgot`	Forgot	{email}	{success: true}
GET	`/api/v1/auth/get-user-by-reset-key/:passwordResetKey`	Get user for given `passwordResetKey`	--	{id, email}
POST	`/api/v1/auth/reset`	Reset password	{email, password, passwordResetKey}	{accessToken}
GET	`/api/v1/auth/get-user-by-invite-key/:inviteKey`	Get user for given `inviteKey`	--	{id, email}
POST	`/api/v1/auth/invite`	Complete user invite process	{inviteKey, email, password, ...}	{accessToken}
User
GET	`/api/v1/user`	Get the current user		{User}
POST	`/api/v1/user`	Update the current user	{firstName, lastName}	{User}
POST	`/api/v1/user/update-password`	Update password	{password, newPassword}	{success: true}
Groups
GET	`/api/v1/groups/:groupID`	Returns group by ID	--	{Group}
POST	`/api/v1/groups/:groupID`	Update group by ID	{name: 'New Name'}	{Group}
POST	`/api/v1/groups/:groupID/users/invite`	Invite user to group	{email}	{UserID, GroupID}
POST	`/api/v1/groups/:groupID/users/:userID/resend-invitation-email`	Resend invitation email	{}	{email}
POST	`/api/v1/groups/:groupID/users/:userID/set-role`	Set user role	{role: 'User'/'Admin' }	{UserID, role}
DELETE	`/api/v1/groups/:groupID/users/:userID`	Remove user from group	--	{UserID}

Deployment

Full Kubernetes deployment instructions can be found in k8s/Deployment.md.

kubectl apply -f .k8s/api.deployment.yml \
  -f .k8s/api.ingress.yml \
  -f .k8s/api.service.yml

Generate SDK Client Libraries

There is an OpenAPISpec in the root of the repo. The project includes code generation config files for PHP, JavaScript and Swift. Use the below command to generate SDK Client Libraries for your API to /sdk/dist. A full list of supported langauages can be found here.

docker run --rm \
  -v ${PWD}:/app \
  -w /app \
  openapitools/openapi-generator-cli batch sdk/config/*.yaml

Commands

There are a few helper scripts and commands for interacting with the application.

Some commands need to be run inside the docker container, these commands have been aliased with an underscore prefix, for exmaple npm run _db:refresh is an alias for docker exec -ti express-api npm run db:refresh which actually runs ./src/scripts/refresh