wack-o-mole database usage

Initial Setup:

1. Configure your AWS profile: aws configure --profile sunwave-dev

2. Log into aws docker registry where wack-o-mole database is: aws ecr get-login-password --region us-east-1 --profile sunwave-dev | docker login --username AWS --password-stdin 517729021141.dkr.ecr.us-east-1.amazonaws.com

3. Pull and run the wack-o-mole image: docker run --platform linux/amd64 -p 3306:3306 --name sunwave-mysql --network sunwave -e MYSQL_ROOT_PASSWORD=Welcome1 -d 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql:1.0.0-SNAPSHOT --lower_case_table_names=1

4. Verify the mysql database container is up and running: docker logs sunwave-mysql

Update to newest version:

1. Stop the existing container: docker stop sunwave-mysql

2. Remove the container: docker rm sunwave-mysql

3. Remove the docker image: docker rmi 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql:1.0.0-SNAPSHOT

4. Login into our aws docker registry: aws ecr get-login-password --region us-east-1 --profile sunwave-dev | docker login --username AWS --password-stdin 517729021141.dkr.ecr.us-east-1.amazonaws.com

5. Pull the new image, create the container and run it: docker run --platform linux/amd64 -p 3306:3306 --name sunwave-mysql --network sunwave -e MYSQL_ROOT_PASSWORD=Welcome1 -d 517729021141.dkr.ecr.us-east-1.amazonaws.com/sunwave-mysql:1.0.0-SNAPSHOT --lower_case_table_names=1

6. Make sure it’s running: docker logs sunwave-mysql Note the initial setup up will take a few minutes:

   

Update the data.

Update the database structure.

Run Integration Tests.

• Run all tests: mvn integration-test -Dsunwave.health.emr.password=Rush__2112 -DskipITs=false

• Run individual tests: mvn integration-test -Dsunwave.health.emr.password=Rush__2112 -DskipITs=false -D it.test=com.sunwave.rest.AccountTimelineIT.java