Page History

...

1. Controller: This class contains the main method that controls talking to the Database by calling the "execute" methods from MyDao DataAccess class. Also, it validates the user input of year and month values.
2. MyDaoDataAccess: This class validates the connection to two databases, "md_vpn and "reports". It also has all the execution methods that update the database. Look here https://wiki.geant.org/display/SD/1.1+Initialising+The+Data
3. UserInput: This class is to facilitate receiving year & month entries from the user

The programme connects to two databases, "md_vpn and "reports". Currently, they are local instances on my machine(md_vpn,reports) using my credentials (test password). In order to run this code on production environment; the database URLs and credentials must be changed in "MyDao class".are stored in a config. file named "application.properties"

The "run" method in "Controller" class will execute the basic update statements, as per this wiki page: https://wiki.geant.org/display/SD/1.1+Initialising+The+Data . Also, it executes the Splunk Data and all other steps in 3.2 https://wiki.geant.org/display/SD/3.2+MD+VPN+Availability+Detailed . Finally, it will execute step 3.1 MD-VPN Availability Summary https://wiki.geant.org/display/SD/3.1+MD-VPN+Availability+Summary

...