Add Database for testing

Preparation

To ensure the application works, we need to load data into the RDS instance. We will use the SQL script in aws-fcaj-container-app/database to insert the data. To do this, first navigate to the aws-fcaj-container-app/database directory to get the script path:

cd aws-fcaj-container-app/database
echo $PWD/init.sql

Copy the path as we will use it later.

Connect to RDS

1. Now, we’ll use the MySQL client installed earlier to connect to the RDS instance. First, go to the RDS Console:

• Select the RDS instance you created earlier.
• Copy the endpoint.

2. Use the following command to connect:

mysql -h "rds-endpoint" -u admin -p

3. Next, we will use the source /project/aws-fcaj-container-app/database/init.sql command to run the SQL script.

Verify Results

1. Check the database: SHOW DATABASES;

2. Check the data: USE fcajresbar then SELECT * FROM Categories;