Skip to content

Example Express Node API written in Typescript with Postgres and Redis backend and RBAC / ABAC authorization

Notifications You must be signed in to change notification settings

mikesparr/typescript-postgres-auth-example

Repository files navigation

CircleCI

Full-featured Starter API (Typescript, Express, RBAC / ABAC)

This project was created initially for research purposes, reviewing how various other apps organize their Node/Express/Typescript repos and trying to pick the best parts of each. It is now a reference / starter API project any startup could use to start off on the right foot with key functionality needed for future scaling and support.

Features included

  • Authentication (register, login, verify email, lost password, login as (assume identity))
  • Authorization (role-based access control with attribute filtering)
  • Features flags (flags, multi-variant flags, user segments, environments, goal tracking)
  • Event logging (logs activity stream of user events, search and filter log records)
  • Graph relations (automatically builds graph from activity stream events)
  • Performance monitoring (logging process time per request to identify bottlenecks)
  • Security (token deny list, helmet, more to come...)
  • Email using Sendgrid transactional email
  • Docker Compose (rapid setup including database admin tools)
  • Database integrations (Postgres, Redis, Elasticsearch)
  • Containers (optionally build app in Docker container with multi-stage build)
  • Continuous Integration (CI config builds, lints, tests on push with CircleCI)
  • Flexible architecture (Dao layer allows adding future "views", EventEmitter allows CQRS-ES)
  • Strongly-typed codebase (written in Typescript)
  • Interactive API documentation using Swagger UI (Open API spec)
  • Automated testing (including integration tests for API routes)
    • Jest unit and integration tests (npm test)
    • Locust load testing (see locustfile.py)

Planned features

  • User groups support (authorization based on membership roles)
  • User invite support
  • Internationalization
  • Additional view layers (i.e. GraphQL)
  • Workspaces

Usage (quick start)

  1. clone the repo
  2. npm install
  3. Setup temp environment configs (TEST only)
    • RUN in CLI from project root ./setenv.test.sh
  4. Make note of generated files and change to your preferences
    • IMPORTANT: when deploying app, don't use the .env file, simply set vars in your CI provider or container manager
  5. docker-compose up
    • This will spin up Postgres, PGAdmin, Elasticsearch, Kibana, and Redis
    • IMPORTANT: run ./setup_es.sh to create index mapping templates for Elasticsearch after startup
    • To stop them, and remove local volumes: docker-compose down -v
  6. Run tests (will load up test data in tables)
    • npm run test
  7. Start up app in developer mode (will watch and recompile for changes)
    • npm run dev
  8. Open browser tab to Swagger UI Explorer to explore API
  9. Open browser tab to Postgres Admin for Postgres Admin
    • click on "Servers" and then "Object > Create > Server"
    • "General > Name" the connection "Test Server"
    • click on "Connection" tab:
      • Host: postgres (network exposed by docker-compose)
      • Password: admin (or whatever you set in ENV vars)
    • click on "Save"
    • traverse "Servers > Test Server > Databases > auth_example > Schemas > public"
  10. Open browser tab to Kibana for Elasticsearch Admin
    • You will have to know a little about ES if you choose to use it

Testing

This app includes automated tests using Supertest and Jest to test routes, etc.

  • npm test or npm run coverage
  • NOTE: the Docker database must be running (see Step 5 above)
  • SEE: __tests__ folders in application for test source code

Extending

Every DAO method should emit an event in an activity stream format as shown. For max flexibility, like to disable writes and make the architecture CQRS, you can create a new handler in utils/activity.helper.ts.

Adding new services

You can follow along the commit history relating to the issues (closed) and see how, but a general idea is:

  1. add a new folder (i.e. category) in the src/services/ folder
  2. if CRUD feature with database, copy src/services/role/* and find/replace to match new names
  3. edit src/config/data.test.ts and add necessary test data and permissions for CRUD
  4. if new providers, add src/config/{provider}.ts and make connections from process.env.{vars here}
    • be sure to add test vars to setenv.test.sh, src/utils/validation.helper.ts, .env
  5. edit src/config/openapi.json and add routes to documentation (if REST implementation)
  6. if non-CRUD feature, add a new src/config/event.ts listener and be sure to emit within Dao methods
    • this is key to support CQRS-ES architecture and scale to PubSub or message bus in future as needed

User stories (demonstrated within by test data and features)

Check test data

See the /config/data.test.ts file to see how permissions, roles, and users were added to the database that fulfill the requirements below. The /util/{type}.helper.ts files abstract the specific module implementation as much as possible so we could change out solutions in future without modifying the code base.

Guest

  • As a guest, I want to be able to register or login, so that I can access features within the app
  • As a guest, I want to confirm my valid email address, so that I can gain access to the application
  • As a guest, I want to be able to submit my email credentials, so I can still login if my password is lost

User

  • As a user, I want to be able to search by city name, so I can view geo data about the city
  • As a user, I want to be able to view users (without age or password), so I know users of the system
  • As a user, I want to be able to edit my own user record, so I can keep my information current
  • As a user, I want to be able to view a list of roles (without permissions) so I know what roles are available
  • As a user, I want to be able to logout, so that my authentication session cannot be used by others
  • As a user, I want to be informed if attempts to gain access to my account occur, so I can help prevent unauthorized access
  • As a user, I want to be able to disable one or more devices (tokens), so I can prevent unauthorized access
  • As a user, I want the app to respond quickly, so I don't have to wait for information

Admin (User + Admin)

  • As an admin, I want to be able to search by city name, so I can view geo data about the city
  • As an admin, I want to be able to view users (with age but no password), so I know users of the system and their age
  • As an admin, I want to be able to create any user record, so I can manage users in the system
  • As an admin, I want to be able to edit any user record, so I can manage users in the system
  • As an admin, I want to be able to delete any user record, so I can manage users and keep the system current
  • As an admin, I want to be able to view roles (with permissions), so I know roles of the system and their permissions
  • As an admin, I want to be able to create any role record, so I can manage roles in the system
  • As an admin, I want to be able to edit any role record, so I can manage roles in the system
  • As an admin, I want to be able to delete any role record, so I can manage roles and keep the system current
  • As an admin, I want to be able to view roles for any user, so I know users of the system and their roles
  • As an admin, I want to be able to add any role record to any user, so I can manage users and their roles in the system
  • As an admin, I want to be able to remove any role record from any user, so I can manage users and keep the system current
  • As an admin, I want to be able to view permissions for any role, so I know permissions of the system and their permissions
  • As an admin, I want to be able to add any permission record to any role, so I can manage permissions in the system
  • As an admin, I want to be able to remove any permission record from any role, so I can manage permissions and keep the system current
  • As an admin, I want to be able to deny any user or user device token, so I can manage user and device access

Systems Administrator

  • As a sysadmin, I want to be able to automatically check app health, so I can automate scaling and recovery
  • As a sysadmin, I want the app to log all events, so that I can optionally add alerts if acceptable thresholds are exceeded
  • As a sysadmin, I want to be able to deny protected access to any user or individual token, so I can prevent unauthorized access
  • As a sysadmin, I want to be able to disable client features that may have issues, so I can maintain app stability
  • As a sysadmin, I want to identify actions a support user performs on behalf of users, so I can audit and explain data

Customer Support (Tier 1)

  • As a support user, I want to be able to initiate a lost password request for a user, so I can take care of them in real time
  • As a support user, I want to be able to assume a users identity without password, so I can use the app as they would and help identify issues
  • As a support user, I want to be able to search for and view all users, so I can take care of them in real time
  • As a support user, I want to be able to edit a limited set of user data, so I can take care of them in real time

Technical Support (Tier 1 + Tier 2)

  • As a tech support, I want to view and filter user activity logs in real time, so I can troubleshoot issues before escalation
  • As a tech support, I want to be able to edit a limited set of user data, so I can test different configurations during troubleshooting

Product Owner

  • As a product owner, I want an API that supports various authorization levels, so we can support future revenue and feature models
  • As a product owner, I want all features of the app automatically tested using TDD, so we can keep customers happy with stability
  • As a product owner, I want to allow external authentication providers (IdP), so we can offload effort or meet compliance guidelines
  • As a product owner, I want to test new features on a subset of users or geographies, so we can measure impact, refine, or revert as needed
  • As a product owner, I want to be able to track usage of toggle/flag features, so we can fine-tune before global deployment (or omit)
  • As a product owner, I want to ignore metrics performed by support users on behalf of users, so we can accurately measure metrics

Architect

  • As an architect, I want to centralize events/activity stream, so that I can easily add stream pipeline, queue, or bus to implment CQRS-ES
  • As an architect, I want the app to be 'stateless' with remote DB, so that I can easily scale to meet growth requirements
  • As an architect, I want the app to be layered, so it's extensible with minimal duplicate code and able to change providers
  • As an architect, I want to app to be able to run in containers, so it is isolated and can easily scale to meet growth requirements
  • As an architect, I want to be able to change password hash solutions, so we can stay current as security standards evolve
  • As an architect, I want to be able to plug in security middleware, so we can stay current as security standards evolve
  • As an architect, I want to log performance metrics, so I can eliminate bottlenecks or calculate resource needs for scaling

Developer

  • As a developer, I want to be able to toggle/flag new functionality, so we can safely build/deploy and test out new features

Resources

Inspiration / Credits

As I wanted to piece together RBAC/ABAC using popular stack choices, I found several good examples online. I'd like to give credit and thanks to the following for their hard work and excellent articles and examples.

Contributing

As this is just a research project, I don't plan on maintaining LTS but if any suggestions on improving the app, please write Issue or PR and I'll consider. Thanks!

About

Example Express Node API written in Typescript with Postgres and Redis backend and RBAC / ABAC authorization

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages