A reporting tool that prints out reports based on data from a web server's database.
The reporting tool built with Python and SQL that uses a newspaper website's raw data. The data contains articles, the author of articles, and entries for each time a user accessed the website. The purpose of this reporting tool is to determine the most popular three articles of all time, the most popular article authors of all time, and the days on which more than 1% of requests lead to errors.
- Install Vagrant and VirtualBox.
- Clone this repository using git or download a zip of the repository.
- Start the virtual machine
- Launch Vagrant VM by running 'vagrant up', then log in with 'vagrant ssh'
- Download the data. Unzip the file after downloading it. The file inside is called newsdata.sql
- Place the file into the vagrant directory
- Setup database with the following command:
psql -d news -f newsdata.sql;
- Run Module
python logs_analysis.py