Log Analysis
This project is a part of the Udacity Full Stack Web Development Nano Degree Program.
Project Summary
In this project one should create and use SQL queries which will fetch the information from the database "news" which is part of a website. The purpose of this project is to apply and test command over sql queries and make sure he/she fetch the correct information from the database. The code uses queries to fetch the information and uses two views to answer third query.
Software Requirements
- Python - 3.7.3
- Vagrant - 2.2.4
- Virtualbox - 6.0.4
- Git - 2.21.0.windows.1
How to run the project
- Download(Optional): 1.1 Git 1.2 Python3 1.3 VirtualBox 1.4 Vagrant 1.5 Configured Vagrantfile* 1.6 News Database*
- Installation(If not installed): 2.1 Git 2.2 Python3 2.3 VirtualBox 2.4 Vagrant
- Open command prompt or gitbash terminal
- Create new directory or you can use existing one. For creating directory use mkdir 'DirectoryName' on gitbash terminal/cmd.
- Goto the directory where you want to keep your files and paste downloaded files in steps Vagrantfile and newsdata.sql inside the folder.
- Open VirtualBox
- 'vagrant up' on gitbash/cmd.
- 'vagrant ssh' on gitbash/cmd once step 7th successfully completed.
- Run 'cd /vagrant' on gitbash/cmd to goto shared directory between host and guest machine.
- Run 'psql -d news -f newsdata.sql' to load data into database.
- To connect to news database run 'psql -d news'.
- Type 'python3 log-analysis.py' to run the python code.
Create Views
- Create view requestlog as select date(time) as time,count(*) requests from log group by date(time);
- Create view failedlog as select date(time) as time,count(*) requestfailed from log where status like '%404%' group by date(time);
Troubleshooting
If you are unable to access shared folder then close connections and run 'vagrant reload'.
Note
* are required files.