This programs serves to test if your set-up match our requirements.
See POM file for dependencies, you need to be running a be running a MySQL Server (8.0).
For compiling and running the program, please use...
cd Installation_Test
mvn compile
mvn exec:java -Dexec.mainClass="popbr.InstallationTest"
Expected output after executing:
[INFO] Scanning for projects...
[INFO]
[INFO] ----------------------< popbr:Installation_Test >-----------------------
[INFO] Building Installation_Test 1.0-SNAPSHOT
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- exec-maven-plugin:3.0.0:java (default-cli) @ Installation_Test ---
Attempting to connect to the Test Data file: Success
Attempting to Connect, create, and insert to an SQL database: Success
Attempting to Connect to and output from an SQL database: Success
Attempting to Create and insert into an Excel: Success
Login Information for SQL can be found here:
data-integration/Installation_Test/target/LoginInfoTemplate.xml
To change a specific username and password, like SQL, you must create a new file, titled LoginInfo.xml in the data-integration/Installation_Test/target/ folder. To do this efficiently, copy and rename the LoginInfoTemplate.xml file. Then edit the username and password fields to match the required information.
Do not edit the LoginInfoTemplate.xml file. The LoginInfo.xml file is intended to only be used on one's local machine, with the LoginInfoTemplate.xml file being used as a base.