tm-apps-authors-db

tm-apps-authors-db

Apps Authors backend database using the MySQL library. See /models.

• index.js: provides access to the DB using MySQL commands
• connect.js: provides connection to the DB

NPM package

apps-consumer-author is using database joins to aggregate data and hence this repo is delivered as an NPM package.

A new version can be deployed by updating the version number from package.json file by following the semantic versioning syntax and tagging the commit with that version. When pushing the newly tag to git, a new package version will be published.

To bump up the package version, use npm version with --git-tag-version option - this will bump up the package version and it will automatically commit and tag the version change.

Eg:

npm version patch --git-tag-version

The above will increment the third digit of the version and it will tag the commit with that version.

Short description for semantic versioning syntax:

Stage  | Rule                                                            | Example
----------------------------------------------------------------------------------
major  | Increment the first digit and reset 2nd and 3rd digits to zero  | 4.0.0
minor  | Increment the middle digit and reset the 3rd digit to zero      | 3.4.0
patch  | Increment the 3rd digit                                         | 3.4.2

Deploy

Apps Authors database is deployed as a Cloudformation stack through Drone pipelines by promote events to a specific environment. There are 2 Cloudformation stacks that gets deployed:

• tm-apps-db-env containing a RDS instance (MySQL), a security and a subnet group, with alarms set up for CPU and Storage space