JXL

Django implementation of JXL to get filtered data from Jira and write values to an excel file.

Instructions

Automated

  • Run installation/ubuntu_postgresql_setup.sh bash script to download postgresql, it’s required files, start it, check to make
    sure it’s port is listening
  • Run installation/ubuntu_geckodriver_install.sh bash script to download Firefox geckodriver and
    add it’s executable to PATH
  • python myscript/manage.py makemigrations jxl
  • python myscript/manage.py migrate jxl
  • python myscript/manage.py test jxl
  • python myscript/manage.py runserver
  • python tests/functional_tests.py

Manual

  • Follow these steps to install postgresql (on Ubuntu 18.04)
  • Start postgresql
    • sudo systemctl start postgresql
    • sudo systemctl enable postgresql
  • Ensure postgresql is running and has access to network
    • sudo service postgresql status – should return as active
    • sudo netstat -nl | grep postgresql – should return a stream
  • Install requirements.txt after postgresql has been installed
    • pip install -r requirements.txt
  • Install geckodriver for selenium to access Firefox
    • Download
      • wget https://github.com/mozilla/geckodriver/releases/download/v0.24.0/geckodriver-v0.24.0-linux64.tar.gz
    • Extract
      • tar -xvzf geckodriver*
    • Make it executable
      • chmod +x geckodriver
    • Add driver to PATH
      • sudo mv geckodriver /usr/local/bin

GitHub

View Github