- At root directory, run
npm installoryarn installto install all of the dependencies - Run
npm startto spin up the server
(Reference: https://sequelize.org/master/manual/migrations.html)
- Install postgres client on your local computer https://www.postgresql.org/download/
- Start the postgres service
service postgresql start - Get a
config.jsonfile from project admin, put it under/gaia/db/config/and modify the metadata accordingly - For first time set up, install
sequalize-cli, and runnpx sequelize-cli init - Once the sequelize client is up, create table schema by running
npx sequelize-cli db:migrate - Lastly, for local env, you can optionally seed the table by running
npx sequelize-cli db:seed:all