Upraised-Assignment

1.Schema for the database table

2.How to run the assignment

1.Create a virtual environment: virtualenv -p python .
2.To start the virtual environment: source bin/activate
3.Installing the dependencies: pip install -r requirements.txt
4.Migrations: python manage.py makemigrations, python manage.py migrate
5.Create a superuser: python manage.py createsuperuser
6.Run server: python manage.py runserver

3.Input CSV and dumping it into the database

1.You can now open the API in your browser at http://127.0.0.1:[port]/upload to upload the csv file and click on upload
Below:Screenshot of the view

4.APIS

1.Job Search

1.You can now open the API in your browser at localhost:[port]/jobs/<value>
2.This API takes in the value of the skill or title of the required jobs
3.It returns a list in which each list item is a dictionary of job
Below:Screenshot of the API

2.Analytics

1.You can now open the API in your browser at localhost:[port]/startdate/<date>/enddate/<date>
2.This API takes in two values, the startdate and enddate which should be in year-month-day-hour-minute-second format
3.It returns a dictionary with total jobs, jobs grouped by title, jobs grouped by company and jobs grouped by skills
Below:Screenshot of the API