this app is designed to analysis the data of a website to answer a question about different articles views which they are:
- What are the most popular three articles of all time?
- Who are the most popular article authors of all time?
- On which days did more than 1% of requests lead to errors?
you just need to run the command:
$ python3 logs_analysis.py
or
$ /.logs_analysis.py
the app consists of three postgresql quiries each answers a question
by joinig the articles and log tables on slug and path columns as slug is a part from path.
Count the visits of every article and joining it with author table.
find the number of all requests on everyday and find the number of all requests errors and compare them.