jscoobyced/docker-nodejs-mariadb

This is all you need to build a full website using ReactJS and NodeJS.

Welcome to my Github home.

Feel free to look around, submit issues or fork any repository.

docker-nodejs-mariadb's Issues

Enable SQL scripts to manipulate DB on start-up

We need to be able to perform basic DB manipulation. For example:

• configuration/db/setup/current.sql: to drop all tables, indexes, constraints... and re-create them. This should always be updated when there is a DB change
• configuration/db/setup/previous.sql: this must be the content of the current.sql script before making any change to it. It will be used to test the update.sql script.
• configuration/db/setup/stored/xxx.sql: each stored procedure should have it's own file and version in the name (i.e. get_user_by_username_v1.sql. The file name should be the same as the SP name, with the version appended to it (separated with a _ underscore). No change should ever be made to a SP. Instead a new version is added. This allows for easy rollback. The name is important to automatically drop older SP versions automatically and maintain a clean DB schema.
• configuration/db/setup/qa.sql: to populate data for QA environment and testing
• configuration/db/update/update.sql: this script will be run to update the database schema. In the CI environment, the previous.sql script is used to create a DB, then run the update.sql script to update it. Then it uses the current.sql to create another db. Ideally it should compare the entities in both to ensure they are equal.

That's a big story :)

Add testing in Back-End

Need to add in the Back-End project:

• unit tests
• integration tests

Add integration test in Back-End

Add support for integration tests and implement tests in Back-End project.

Make build pass

For now the build can't pass if there is no valid docker credentials in the GH Actions Secret. The build should check for the values first then skip those steps.

Enable MariaDB in Back-End

Database support is not yet enabled. Need to start MariaDB in docker-compose.

Create deployment CI

We need to be able to push to master and get automatically deployed to production, using standard tools rather than custom scripts.
Database should have zero downtime for deployment.
Front-End and Back-End can have downtime, but the process should support for more FE or BE instances to achieve zero downtime too.

Enable CI build

Create GH actions to:

• run all tests and push code coverage to codecov
• create a release on success

Configure docker hub to build production images of front-end and back-end applications based on:

• merge to main branch
• release version

Configure Back-End code quality

Need to add the following:

• add es-lint

Front-End to call Back-End API

We need a sample code to call the back-end API and display the result.