LogsAnalysis

A reporting tool that prints out reports (in plain text) based on the data in a database. This reporting tool is a Python program using the psycopg2 module to connect to the database.

Design

The project consists of two source files, main.py which calls the functions and prints the output and newsdb.py which consist of the methods that grabs the data from the database.

The query statements were done one for each question.

How to Run

First you need to populate your database with the data given in newsdata.sql. You have to be in the same directory level as newsdata.sql in Vagrant virtual machine terminal. Then type:

psql -d news -f newsdata.sql

Which creates a database called news populated by the data of newsdata.sql

You have to be in the same directory level as main.py and newsdb.py in Vagrant virtual machine. Then type:

python main.py

to run the program.