NodeJs API with MySQL and Docker

Create a patient db and a patients table with fields such as id, first name, last name, email, and created_at timestamp, enforcing a primary key and a unique email constraint.

Configure a MySQL connection pool in a Node.js API by loading env vars, defining host, port, user, password, and database, and exporting the pool for efficient queries.

Create a simple response class for api replies, with a constructor that takes status code, message, and data, automatically adds a timestamp via new Date().toLocaleString(), and exports for frontend responses.

Learn to implement an HTTP response in a NodeJs API by constructing a response object and sending a 200 OK status, optionally including data such as a dummy patients list.

Configure Pino and Pino pretty for the node app, disable process id, enable color and timestamps, export a default logger, and replace console.log with structured logs.

Define a constant object of MySQL queries for the patients table, exported for reuse. Include select all with order by created date and limit 100, and insert, update, and delete.

Create a patient controller in a NodeJs API with MySQL and Docker, wiring it to config, response, logger, and query modules; implement centralized HTTP status codes for clean responses.

Implement a get patients function that logs request method and url. It queries the database for patients and returns a response with data or a 'no patients found' message.

Create a patient from the request body, insert into the database, and return the created patient; fetch a patient by id with not found and error handling.

Learn to update a patient record in a NodeJs API with MySQL by validating existence, merging request data, executing the update, and logging errors securely.

Learn how to delete a patient in a Node.js API with MySQL, checking affected rows for success, handling not found cases, and wiring routes and controller logic.

Configure Express routes for patient resources using an Express router, with get, post, put, and delete handlers, including dynamic id paths for individual patients.

Wire up express routes for a node api and mount patient routes under /patients with middleware. Dockerize the app to spin up the database and run with a single command.

Explore docker fundamentals and docker compose to run apps in isolated containers with all dependencies, enabling deployment and hosting on a single machine.

Define a Docker Compose service for a MySQL 8.0 master database, configure environment, volumes, port mappings, an init script, and a dedicated network to connect apps.

Test the docker compose setup, verify no errors, then connect to the mysql server on localhost:306, inspect patients db and patients table, and load configuration from the env file.

Start the dev environment, create and save a patient via the api, and verify CRUD operations get update and delete against a dockerized MySQL database.

Define and call a stored procedure to create a patient and return the newly inserted patient by ID, using delimiter handling, begin...end, and last_insert_id in MySQL.

Learn to set up a dockerized Node.js MySQL environment, create and call a stored procedure, and verify the returned patient data in the patient database.

Learn to dockerize a node.js api with a node alpine dockerfile, install dependencies, copy code, expose port 3000, and compose a node app service that depends on my school db.

Demonstrates dockerizing a Node.js API with Docker Compose, including environment variables, port mapping (3000 and 5000), and image building. Run containers, map volumes, and test the MySQL-backed app end-to-end.