LogsAnalysis.py

#!/usr/bin/env python3

import psycopg2


def main():
    # Connect to an existing database
    conn = psycopg2.connect("dbname=news")

    # Open a cursor to perform database operations
    cur = conn.cursor()

    # Question 1
    sql_popular_articles = """
      SELECT article_view.title, article_view.view
      FROM article_view
      ORDER BY article_view.view DESC
      LIMIT 3;
    """
    cur.execute(sql_popular_articles)
    print("Most popular articles:")
    for (title, view) in cur.fetchall():
        print("    {} - {} views".format(title, view))
    print("-" * 70)

    # Question 2
    sql_popular_authors = """
    SELECT article_view.name, SUM(article_view.view) AS author_view
    FROM article_view
    GROUP BY article_view.name
    ORDER BY author_view DESC;
    """
    cur.execute(sql_popular_authors)
    print("Most popular authors:")
    for (name, view) in cur.fetchall():
        print("    {} - {} views".format(name, view))
    print("-" * 70)

    # Question 3
    sql_more_than_one_percent_errors = """
    SELECT *
    FROM error_rate
    WHERE error_rate.percentage > 1
    ORDER BY error_rate.percentage DESC;
    """
    cur.execute(sql_more_than_one_percent_errors)
    print("Days with more than 1% errors:")
    for (date, percentage) in cur.fetchall():
        print("    {} - {}% errors".format(date, percentage))
    print("-" * 70)

    # Close communication with the database
    cur.close()
    conn.close()

if __name__ == "__main__":
    main()