VIDEOBEAT BACKEND TEST

Weather API.

The test require to implement a weather measurement service. The initial data incomes in a xlsx file with the following header: date, time, geoposition coordinates, hight under the ground, temperature, wind speed, wind vector direction. The initial data needs to be uploaded through API every minute. The data should be bookkeeped in the service. The algorithm calculates the service output: average temperature and average wind speed / direction in space. The algorithm should be scheduled to run every N minutes as a job. The input data and output results of the service should be accessed through REST API. Caching of the algorithm’s output should be implemented. The results and statuses of scheduled jobs should be bookkeeped and accessed through REST API as well. Requirements: all backend should be written in Python with virtual environment. Database - mysql. OS - linux. Backend - Django. Caching - Redis. Rest frameform: Django Rest Framework.

---

Configure and run the project.

Follow these steps to run the project.

Main topics:

• Periodic tasks with django and celery
• Caching in django with Redis.
• Django REST framework.
• Django and MySQL
• Read xlsx EXCEL 2010+ files with openpyxl

Clone the project:

Clone the project into a local repository:

git clone 'https://github.com/mehemmelbachir/videobeat-weather-api.git'

Create DATABASE:

• open terminal.

• Connect to mysql and create a database named weather_db.

  mysql -u root -p
  CREATE DATABASE weather_db
  

• Ensure you enter the right values of your MySQL connection into your settings.py file:

    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.mysql',
            'NAME': '<weather_db>',
            'USER': '<mysql_username>',
            'PASSWORD': '<mysql_password>',
            'HOST': 'localhost',
            'PORT': '3306'
        }
    }
  

Install requirements:

• open terminal

• activate virtualenv
  path\to\project\env\script\activate.

• run:

  pip install -r requirements.txt
  

Run DJANGO SERVER

• open terminal

• Activate virtualenv.
  path\to\project\env\script\activate.

• Run DJANGO SERVER:

  python manage.py runserver
  

Run Celery Sheduled tasks:

On separated terminals, run the following commands:

celery -A weather worker -l info
celery -A weather beat -l info

On Windows 10 to fix errors run with -P eventlet.

celery -A weather worker -l info -P eventlet
celery -A weather beat -l info