How To Setup The Database:
- Download the advertisement.sql file provided in the src directory of the application
- Make sure MySQL is installed and configured on your laptop
- Navigate to your MySQL server's bin directory using command prompt
- Run the command "mysql -u root -p" and enter the password you set when configuring MySQL as prompted
- Enter the command "CREATE DATABASE advertisement;"
- Enter the command "CREATE USER 'Mahdi'@'3306' IDENTIFIED BY 'ensf380';"
- Enter the command "GRANT ALL PRIVILEGES ON advertisement.* TO 'Mahdi'@'3306';"
- Enter the command "EXIT;"
- Run the command "mysql -u Mahdi -p advertisement < c:/path/to/advertisement.sql" and enter the password 'ensf380' when asked (NOTE: make sure to replace c:/path/to/advertisement.sql with the actual path to the location where you have saved the advertisement.sql file)
How To Run The Program:
- Check if all JAR files in the image below are present
If you do not see the JAR files please do the following:
Click classpath and then Add JARs
Navigate to the libs folder in Project and add all the necessary JAR files. Then apply and close.
- Next, go to run configurations
- Please enter a command line argument. Select a city name (like toronto) and a train number between 1 to 12. Select apply and then run.
The program should run, please give it a few seconds to load. Also note that the test files are located in the src/test/java/ca/ucalgary/edu/ensf380 folder and can be run from there
ALSO, to view WeatherParser.java, please go into WeatherProject > src > ca.ucalgary.ensf380