Log Analysis Project

Submission for Full-Stack Web Developer Nanodegree

This project queries news database, organizes and prints the query results accordingly.

Requirements:

• Virtualbox You can download virtualbox from here.
• Vagrant You can download vagrant from here.
• Python You can download python here.

Usage

1. Clone this project on github

   $ git clone https://github.com/sk15973/Log-Analysis-Project.git

2. Change directory to the project folder

3. run vagrant up from command line

4. Download the sql file from here, extract the file and move it to the project folder.

5. after vagrant set up is complete run vagrant ssh and cd /vagrant folder. Database setup

   • Run the following commands once during the first time execution of the project.
   • sudo su - postgres
   • psql
   • CREATE DATABASE news;
   • CREATE USER vagrant;
   • GRANT ALL PRIVILEGES ON DATABASE news to vagrant;
   • psql -d news -f newsdata.sql

6. run python LogAnalysis.py to the get the results.

SQL file

The SQL file was provided by udacity as part of the project course material. Download the SQL file from news data.

Acknowledgments:

• Providing course and mentorship - Udacity.
• Documentations and code samples - Python.