tm-apps-db

tm-apps-db

Apps backend database using the Sequalize library. See /models and /migrations.

• index.js: provides access to the DB using Sequalize APIs
• sync.js: command-line tool to init/synchronize the DB models.

Docs

In order to view or generate an entity diagram of the database, go to ./db/docs/ and follow the instructions.

Migrations

Information on using the Sequelize CLI to perform database migrations can be viewed here: http://docs.sequelizejs.com/en/latest/docs/migrations/

To perform migrations then run

$ npm run migrate

Migrations can be reversed by running

$ npm run migrate:undo

Read more in MIGRATIONS.md

TODOs

• Drone pipeline
• AWS cloudformation
• Remove DB credentials from aws/database.yml, get them from SSM or Drone envs