3 complex SQL queries to answer specific questions.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.DS_Store
README.md
output.txt
script.py

README.md

Description

Reporting tool that prints out reports (in plain text) based on the data in a database. An example of the output of this program can be found in output.txt file.

Requirements

This reporting tool is a Python program that uses psycopg2 module to connect to a database, install:

Preparation

  • First clone the repository to your machine:
  git clone https://github.com/DOUARA/Logs-Analysis.git Logs-Analysis
  • Create a new database called news:
psql
CREATE DATABASE news;
  • Populate your database with data using the command:
  psql -d news -f newsdata.sql

Download newsdata.sql from here.

Running the program

from within Logs-Analysis folder run script.py file:

python script.py