[$30] Use existent env variable during DB migration

[maxceem]

We have a migration command which migrate DB: npm run migrate. Underneath it calls built-in sequelize command https://sequelize.org/master/manual/migrations.html.

At the moment when we run this script on DEV or PROD we have to pass several environment variables DB_USERNAME, DB_PASSWORD, DB_NAME and DB_HOST. Though we already have env variable which defines DB connection settings using env variable DATABASE_URL with the value which looks like postgres://postgres:postgres@localhost:5432/postgres.

We don't want to provide separate values DB_USERNAME, DB_PASSWORD, DB_NAME and DB_HOST instead, we would like to update this config so it:

• don't use DB_USERNAME, DB_PASSWORD, DB_NAME and DB_HOST anymore

• parses the value inside DATABASE_URL and split it into value required by the sequelize:

  

• It should be done for all envs: development, test, production

  • keep default values for development and test environments, but not for production

• make sure that migration script works only by setting DATABASE_URL

[maxceem]

@yoution feel free to pick up if you like.

[yoution]

@maxceem please assign to me

[maxceem]

Challenge https://www.topcoder.com/challenges/00fdb431-2c2c-47ac-ac30-f42d8b5b7e79 has been created for this ticket.

This is an automated message for maxceem via Topcoder X

[maxceem]

Challenge https://www.topcoder.com/challenges/00fdb431-2c2c-47ac-ac30-f42d8b5b7e79 has been assigned to yoution.

This is an automated message for maxceem via Topcoder X

[maxceem]

Payment task has been updated: https://www.topcoder.com/challenges/00fdb431-2c2c-47ac-ac30-f42d8b5b7e79
Payments Complete
Winner: yoution
Copilot: maxceem
Challenge 00fdb431-2c2c-47ac-ac30-f42d8b5b7e79 has been paid and closed.

This is an automated message for maxceem via Topcoder X