Python command line reporting tool that displays 3 successive set of reports.
- 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?
- Create two views in the 'news database' (views)
- Run the program using the command line python news.py
- Tadaaaaa
create view log_errors as select date_trunc('day',time) as time, count(*) as requests from log where status!='200 OK' group by 1;
create view log_success as select date_trunc('day',time) as time, count(*) as requests from log where status='200 OK' group by 1;
Having a problem getting something to work or want to know more ? Ping me on Twitter @ymedaghri or file a GitHub Issue.