Clean Express

An express boilerplate app build with Clean Architecture in mind.

Comes with:

Typescript
Code formatting with Prettier
Database set up with Knex query builder and Objection ORM
Request logging using express-winston
App config through environment variables with dotenv
NVM
Testing framework with:
- Jest
- SuperTest for integration tests

All set up in a modular way to allow for easy replacement.

Coming soon:

More logging with winston
Dependency injection

Getting Started

# Get the most recent revision
git clone --depth 1 https://github.com/atelic/clean-express my-project

# Change directory
cd my-project

# Install NPM packages
yarn install

# Run the app
yarn start

API Documentation

API docs are automatically generated from JSDoc comments. They can be viewed at /api/v1/docs. To add to this documentation, annotate your controller actions with the OpenAPI 3.0 spec format.

Database

The app is currently set up with a PostgreSQL database, however Knex supports many other SQL databases. To use them all you'll need to do is install the driver by running

yarn add [pg|mysql2|oracledb|mssql|sqlite]

Then update your environment variables or the knexfile.ts.

Migrations

Knex comes with a migrations CLI, allowing you to define schema changes for easy upgrading. NOTE: Knex doesn't have the best Typescript support so migrations are written in plain JavaScript.

To create a new migration run:

yarn migration:make -- my_migration_name

To update your database to the latest version:

yarn migration:latest

And to rollback a migration:

yarn migration:rollback

Knex has more advanced migration features documented here

Environment variable config

To add configuration through environment variables:

Copy the .env.example file to .env
Add your variables
Access them in your ap through process.env.MY_ENV_VAR

Tests

Run tests by running yarn test from the root folder. To add new tests, simply create a file with the extension .test.ts in any directory.

atelic/clean-express