11. Dirty Hacks

11.1. Manipulacje na bazie

11.2. Django ORM

Django Inspect DB + Jira = Django ORM

11.3. Skryptowanie

11.4. Time tracking

11.5. Atlassian Python API

• https://github.com/atlassian-api/atlassian-python-api

• https://github.com/atlassian-api/atlassian-python-api/tree/master/examples/jira

• pip install atlassian-python-api

Code 11.1. Jira reindex

from pprint import pprint

from atlassian import Jira

jira = Jira(
    url="http://localhost:8000/",
    username="admin",
    password="admin")

status = jira.reindex().json()
pprint(status)

Code 11.2. Jira Project Administrators

import logging

from atlassian import Confluence
from atlassian import Jira

logging.basicConfig(level=logging.DEBUG, format="[%(asctime).19s] [%(levelname)s] %(message)s")
logging.getLogger("requests").setLevel(logging.WARNING)
log = logging.getLogger("jira-projects-administrators")


jira = Jira(
    url="http://localhost:8000/",
    username="admin",
    password="admin")

html = "<table><tr><th>Project Key</th><th>Project Name</th><th>Leader</th><th>Email</th></tr>"

for data in jira.project_leaders():
    log.info("{project_key} leader is {lead_name} <{lead_email}>".format(**data))
    html += "<tr><td>{project_key}</td><td>{project_name}<td></td>{lead_name}<td></td><a href='mailto:{lead_email}'>{lead_email}</a></td></tr>".format(**data)

html += "</table><p></p><p></p>"
html += "<p>Autogenerated with <a href='http://localhost:7999/projects/AGILE/repos/devops-utils-jira/browse/bin/jira-projects-administrators.py'>this script</a></p>"

confluence = Confluence(
    url="http://localhost:8090/",
    username="admin",
    password="admin")

confluence.update_page(
    page_id=13207798,
    parent_id=7471197,
    title="Administratorzy JIRA",
    body=html)

log.info("Confluence Page Created with JRIA Administrators at: http://localhost:8095/pages/viewpage.action?pageId=13207798")

11.6. Atlassian CLI

• https://marketplace.atlassian.com/plugins/org.swift.atlassian.cli/cloud/overview

• https://bobswift.atlassian.net/wiki/spaces/ACLI/overview

11.7. DevTools Ecosystem Integration

• https://dev.astrotech.io/git/internals/hooks.html#branch-hook

• https://dev.astrotech.io/git/tools/git-flow.html#konwencje-nazewnicze

• https://dev.astrotech.io/summary/pictures.html#ecosystem

• https://dev.astrotech.io/summary/pictures.html#jira

• https://dev.astrotech.io/summary/pictures.html#ci-cd

• git log --oneline --format='"%h", "%an", "%ae", "%ad", "%s"' --date=iso > ~/Desktop/git-log.csv

11.8. REST API

• https://developer.atlassian.com/server/jira/platform/rest-apis/

• https://docs.atlassian.com/jira-software/REST/latest/

• https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/

• https://developer.atlassian.com/jiradev/jira-apis/about-the-jira-rest-apis/jira-rest-api-tutorials

• https://jira.atlassian.com/plugins/servlet/restbrowser#/

11.9. Create Issue From URL

• Z menu u góry wybierz Projects -> View All projects -> Inspect Element (źródło strony) -> znajdź: data-project-id (to będzie pid)

• http://18.195.183.213:8080/secure/CreateIssueDetails!init.jspa?pid=10000&issuetype=10002

javascript:window.location='http://18.195.183.213:8080/secure/CreateIssueDetails!init.jspa?pid=10006&issuetype=10003&fixVersions=10015&components=10002&summary=' + document.getElementById('search_form_input').value

11.10. Assignments

11.10.1. Atlassian Python API - Instalacja

1. Zainstaluj bibliotekę Atlassian Python API atlassian-python-api

Note

Kod biblioteki dostępny jest na GitHub https://github.com/atlassian-api/atlassian-python-api

Warning

Wymagany Python 3.6 lub nowszy

11.10.2. Atlassian Python API - Reindeksacja

1. Stwórz skrypt jira-reindex.py

2. Skrypt wykorzystując bibliotekę atlassian-python-api ma reindeksować JIRĘ

3. Skrypt jira-reindex.py dodaj Crontab by był uruchamiany o 4 w nocy

4. Pamiętaj, że cron ma inne zmienne środowiskowe