This application reports the following queries from a sample SQL news database.
- Reports the 3 most popular articles
- Reports the 3 most popular authors
- Report the days where more than 1% of requests on news website lead to errors
- Run a virtual machine Vagrantfile is included in repository. Please run following commands in Terminal:
vagrant up
vagrant ssh
- When virtual machine is up and running, change directory containing files
cd /vagrant
- Create database and import database schemas, by typing in Terminal:
psql -d news -f newsdata.sql
- Run test file to run database queries.
python3 news_query.py
A sample of Terminal output can be viewed in report_sample.txt