#!/usr/bin/python

from subprocess import check_output
import json, re, datetime
import time

jd = json.JSONDecoder()

def jira_query(query):
    jira_url = "http://eneaissues.enea.com"
    fields   = "key,summary"
    query    = query.replace(" ", "+")

    cmd = ["curl",
           "-s",
           "-D-",
           "-u", "rest_reader:jira123",
           "-X", "GET",
           "-H", "Content-Type: application/json",
           jira_url + "/rest/api/2/search?jql=" + query + "&fields=" + fields
       ]

    tmp = check_output(cmd).splitlines()
    tmp = jd.decode(tmp[-1])
    return tmp["issues"]

conditions = ("project=LXCR",
              "issueType=bug",
              "resolution=Unresolved",
              'affectedversion="Enea Linux 6"'
          )

bugs = []

time_str = time.strftime("%Y-%m-%d, %H:%M:%S (%Z)")

for issue in jira_query(" and ".join(conditions)):
    bugs.append((issue["key"], issue["fields"]["summary"]))

print '<?xml version="1.0" encoding="ISO-8859-1"?>'
print '<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.2//EN"'
print '"http://www.oasis-open.org/docbook/xml/4.2/docbookx.dtd">'
print '<section id="relinfo-extracted-from-jira">'
print '  <title>Extracted from Jira</title>'
print '  '
print '  <para>'
print '    This section lists open bugs in Jira. Extracted at %s.' % time_str
print '  </para>'
print '  '
print '  <para><programlisting>project = "Linux CR" \\'
print '  and issuetype = Bug \\'
print '  and affectedVersion = "Enea Linux 6" \\'
print '  and resolution = Unresolved</programlisting></para>'
print '  '
print '  <informaltable>'
print '    <tgroup cols="2">'
print '      <colspec colwidth="6*" />'
print '      '
print '      <colspec align="center" colwidth="1*" />'
print '      '
print '      <thead>'
print '        <row>'
print '          <entry align="center">Summary</entry>'
print '          '
print '          <entry>Enea Ref</entry>'
print '        </row>'
print '      </thead>'
print '      '
print '      <tbody>',

for bug in sorted(bugs):
    print ''
    print '        <row>'
    print '          <entry>%s</entry>' % bug[1]
    print '          '
    print '          <entry>%s</entry>' % bug[0]
    print '        </row>'

print '      </tbody>'
print '    </tgroup>'
print '  </informaltable>'
print '  <para>'
print '    Number of open bugs: %d' % len(bugs)
print '  </para>'
print '</section>'