Thanks in part to:
- Getting Started on Heroku with Node.js
- Seans-TypeScript-NodeJS-CRUD-REST-API-Boilerplate
- Express ES2017 REST API Boilerplate
- Node Postgres
- Postgres migrate
- Postgres migrate
brew tap mongodb/brew
brew install mongodb-community
brew install postgres
brew services start postgresql
brew services start postgres
Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up.
psql postgres
\c boilerplate
CREATE DATABASE boilerplate;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
DATABASE_URL=postgres://`{whoami}`:test@localhost:5432/boilerplate yarn run migrate up
Create a new migration. From here
yarn run migrate create customer table init
- move migrations to .ts, and use data models
- tie data models to swagger defs
- add auth for customers
- password table for customers
- swagger-jsdoc
- add abstract class for types, for loading to data store
- map pg functions to Contractor/Customer classes