Link API deployed

• https://lifetravel-api.herokuapp.com/

Requisites

• https://dev.mysql.com/downloads/mysql
• https://www.mysql.com/products/workbench

Run app

$ npm install
$ npm run build
$ npm run start:dev

@nestjs/typeorm 8.0.4 and typeorm 0.3.6 are now compatible

$ npm update

Migrations

$ npm run build
$ npm run typeorm migration:create -- -n InitialSchema
$ npm run typeorm migration:create -- -n MasterData
$ npm run typeorm migration:create -- -n UserEmailUpdate
$ npm run typeorm migration:create -- -n UserEmailReupdate
$ npm run start:dev

Terminal

$ npm install --save typeorm @nestjs/typeorm mysql
$ npm install --save @nestjs/cqrs
$ npm install --save typescript-result
$ npm install --save moment-timezone
$ npm install --save node-sql-reader
$ nest g resource customers

Environment variables

LIFETRAVEL_MYSQL=mysql://{user}:{password}@{host}:{port}/{database}
LIFETRAVEL_MYSQL=mysql://root:root@localhost:3306/lifetravel
Note: Password must be URL encoded, %25 is the url encoding of %.

Fix issue with MySQL 8

Client does not support authentication protocol requested by server; consider upgrading MySQL client. To fix it, run the following command changing the values with your credentials:

ALTER USER '{user}'@'{host}' IDENTIFIED WITH mysql_native_password BY '{password}'
FLUSH PRIVILEGES;

Example:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'
FLUSH PRIVILEGES;