Logs_Analysis.py

#!/usr/bin/env python3

import psycopg2


# DB = "newsdata"

# db = psycopg2.connect(database=DB)
if __name__ == '__main__':
    db = psycopg2.connect("dbname=news")
    c = db.cursor()
    print("\n")
    print("\n")
    print("Most popular three articles of all time:")
    query = """Select title, total_views
    from articles
    join test_03 on test_03.filtered_path = concat(' ', articles.slug)
    limit 3; """
    c.execute(query)
    rows = c.fetchall()
    # db.close()
    for(title, total_views) in rows:
        print("{} - {} views".format(title, total_views))
    print("\n")
    print("Most popular article authors of all time:")
    query2 = """select author_title_slug.name as name,
    sum(test_03.total_views) as total_views
    from author_title_slug, test_03
    where test_03.filtered_path = concat(' ', author_title_slug.slug)
    group by name
    order by total_views desc
    limit 3; """
    c.execute(query2)
    rows = c.fetchall()
    # db.close()
    for(name, total_views) in rows:
        print("{} - {} views".format(name, total_views))
    print("\n")
    print("Days did more than 1% of requests lead to errors")
    query3 = """select total_requests.date,
    round((100.0*error_log.error/total_requests.error), 2) as percent
    from error_log, total_requests
    where error_log.date = total_requests.date
    order by percent desc
    limit 1; """
    c.execute(query3)
    rows = c.fetchall()
    db.close()
    for(date, percent) in rows:
        print("{} - {} %".format(date, percent))
    print("\n")