#!/usr/bin/env python

# Log Analysis
# Project 2
# Udacity - Full Stack Nanodegree

# import Postgresql library
import psycopg2

# Store global database name
DBNAME = 'news'


def executeQuery(query):
    """executeQuery takes a string as a parameter.  It executes the query
    and returns the results as a list of tuples."""
    try:
        db = psycopg2.connect('dbname=' + DBNAME)
        c = db.cursor()
        c.execute(query)
        rows = c.fetchall()
        db.close()
        return rows
    except BaseException:
        print("Unable to connect to the database")


# Problem 1: What are the most popular three articles of all time?
def top_three_articles():
    """Return the top three articles by most views"""
    query = """ENTER QUERY HERE"""
    top_three = executeQuery(query)
    # Display header and results for Problem 1
    print('**** Top Three Articles by Page View ****')
    ## Print returned data here

# Problem 2: Who are the most popular article authors of all time?
def popular_authors():
    """Return the most popular authors based on overall page views"""
    query = """ENTER QUERY HERE"""
    author_popularity = executeQuery(query)
    # Display header and results for Problem 2
    print('**** Most Popular Authors Based on Total Article Views ****')
    ## Print returned data here

# Problem 3: On which days did more than 1% of requests lead to errors?
def high_error_days():
    """Return the days where errors exceeded 1%"""
    query = """ENTER QUERY HERE"""
    high_error_results = executeQuery(query)
    # Display header and results for Problem 3
    print('**** Days Where Errors Exceeded 1%' + ' of Total Views ****')
    ## Print returned data here

if __name__ == '__main__':
    print(" ")
    print("--- Generating Results ---")
    print(" ")
    ## Call the query functions here!