def get_events_from_transactions(self, phtrans):
comments = []
changes = []
for phtr in phtrans:
printdbg("Parsing transaction %s - date: %s" \
% (phtr['transactionPHID'], phtr['dateCreated']))
field = phtr['transactionType']
dt = unix_to_datetime(phtr['dateCreated'])
author = self.get_identity(phtr['authorPHID'])
ov = phtr['oldValue']
nv = phtr['newValue']
text = phtr['comments']
if field == 'core:comment':
comment = Comment(text, author, dt)
comments.append(comment)
else:
old_value = unicode(ov) if ov is not None else None
new_value = unicode(nv) if nv is not None else None
change = Change(field, old_value, new_value, author, dt)
changes.append(change)
return comments, changes
def get_events_from_changes(self, ticket_changes):
comments = []
changes = []
# time, author, field, oldvalue, newvalue, permanent
for ch in ticket_changes:
dt = self.get_datetime_from_json_obj(ch[0])
author = self.get_identity(ch[1])
field = ch[2]
old_value = unicode(ch[3]) if ch[3] else None
new_value = unicode(ch[4]) if ch[4] else None
if field == 'comment' and new_value:
comment = Comment(new_value, author, dt)
comments.append(comment)
else:
change = Change(field, old_value, new_value, author, dt)
changes.append(change)
return comments, changes
def parse_comments(self, review):
if "comments" not in review.keys(): return []
commentsList = []
comments = review['comments']
for comment in comments:
if ("username" not in comment['reviewer'].keys()):
if ("name" in comment['reviewer'].keys()):
comment['reviewer']["username"] = comment['reviewer']["name"]
else:
comment['reviewer']["username"] = None
by = People(comment['reviewer']["username"])
if ("name" in comment['reviewer'].keys()):
by.set_name(comment['reviewer']["name"])
if ("email" in comment['reviewer'].keys()):
by.set_email(comment['reviewer']["email"])
com = Comment(comment["message"], by, self._convert_to_datetime(comment["timestamp"]))
commentsList.append(com)
return commentsList
def _parse_journals(self, issue, issue_id):
issue_url = self._get_issue_url(issue_id)
printdbg("Analyzing issue journals " + issue_url)
f = urllib2.urlopen(issue_url)
data = json.loads(f.read())
journals = data["issue"]["journals"]
for journal in journals:
try:
people = People(
self._get_author_identity(journal["user"]["id"]))
people.set_name(journal["user"]["name"])
except KeyError:
people = People("None")
dt = self._convert_to_datetime(journal["created_on"])
# Comment
notes = journal.get("notes", None)
if notes:
msg = journal["notes"]
comment = Comment(msg, people, dt)
issue.add_comment(comment)
# Changes
for detail in journal["details"]:
field = detail["name"]
old_value = unicode(detail.get("old_value", unicode(None)))
new_value = unicode(detail.get("new_value", unicode(None)))
# Change status value
if field == u"status_id":
field = unicode("status")
old_value = self.statuses.get(old_value, unicode(None))
new_value = self.statuses.get(new_value, unicode(None))
change = Change(field, old_value, new_value, people, dt)
issue.add_change(change)
def analyze_bug(self, bug):
#Retrieving main bug information
##
## all the retrieval can be improved. The method bug.lp_attributes
##offers a list of the available attributes for the object
##
printdbg(bug.web_link + " updated at " +
bug.bug.date_last_updated.isoformat())
issue = bug.web_link[bug.web_link.rfind('/') + 1:]
bug_type = bug.importance
summary = bug.bug.title
desc = bug.bug.description
submitted_by = self._get_person(bug.owner)
submitted_on = self.__drop_timezone(bug.date_created)
if bug.assignee:
assignee = self._get_person(bug.assignee)
else:
assignee = People("nobody")
issue = LaunchpadIssue(issue, bug_type, summary, desc, submitted_by,
submitted_on)
issue.set_assigned(assignee)
issue.set_status(bug.status)
issue.set_description(bug.bug.description)
issue.set_web_link(bug.web_link)
issue.set_target_display_name(bug.bug_target_display_name)
issue.set_target_name(bug.bug_target_name)
try:
if bug.date_assigned:
issue.set_date_assigned(self.__drop_timezone(
bug.date_assigned))
except AttributeError:
pass
try:
if bug.date_closed:
issue.set_date_closed(self.__drop_timezone(bug.date_closed))
except AttributeError:
pass
try:
if bug.date_confirmed:
issue.set_date_confirmed(
self.__drop_timezone(bug.date_confirmed))
except AttributeError:
pass
try:
if bug.date_created:
issue.set_date_created(self.__drop_timezone(bug.date_created))
except AttributeError:
pass
try:
if bug.date_fix_committed:
issue.set_date_fix_committed(
self.__drop_timezone(bug.date_fix_committed))
except AttributeError:
pass
try:
if bug.date_fix_released:
issue.set_date_fix_released(
self.__drop_timezone(bug.date_fix_released))
except AttributeError:
pass
try:
if bug.date_in_progress:
issue.set_date_in_progress(
self.__drop_timezone(bug.date_in_progress))
except AttributeError:
pass
try:
if bug.date_incomplete:
issue.set_date_incomplete(
self.__drop_timezone(bug.date_incomplete))
except AttributeError:
pass
try:
if bug.date_left_closed:
issue.set_date_left_closed(
self.__drop_timezone(bug.date_left_closed))
except AttributeError:
pass
try:
if bug.date_left_new:
issue.set_date_left_new(self.__drop_timezone(
bug.date_left_new))
except AttributeError:
pass
try:
if bug.date_triaged:
issue.set_date_triaged(self.__drop_timezone(bug.date_triaged))
except AttributeError:
pass
try:
if bug.date_last_message:
issue.set_date_last_message(
self.__drop_timezone(bug.date_last_message))
except AttributeError:
pass
try:
if bug.bug.date_last_updated:
issue.set_date_last_updated(
self.__drop_timezone(bug.bug.date_last_updated))
except AttributeError:
pass
if bug.milestone:
issue.set_milestone_code_name(bug.milestone.code_name)
issue.set_milestone_data_targeted(bug.milestone.date_targeted)
issue.set_milestone_name(bug.milestone.name)
issue.set_milestone_summary(bug.milestone.summary)
issue.set_milestone_title(bug.milestone.title)
issue.set_milestone_web_link(bug.milestone.web_link)
try:
if bug.bug.duplicate_of:
temp_rel = TempRelationship(bug.bug.id,
unicode('duplicate_of'),
unicode(bug.bug.duplicate_of.id))
issue.add_temp_relationship(temp_rel)
except NotFound:
printdbg(
"Issue %s is a duplicate of a private issue. Ignoring the private issue."
% issue.issue)
issue.set_heat(bug.bug.heat)
issue.set_linked_branches(bug.bug.linked_branches)
# storing the comments:
# first message of the bugs contains the description
if (bug.bug.messages and len(bug.bug.messages) > 1):
skip = 1
for c in bug.bug.messages:
if (skip == 1):
# we skip the first comment which is the description
skip = 0
continue
by = self._get_person(c.owner)
com = Comment(c.content, by, c.date_created)
issue.add_comment(com)
issue.set_tags(bug.bug.tags)
issue.set_title(bug.bug.title)
issue.set_users_affected_count(bug.bug.users_affected_count)
issue.set_web_link_standalone(bug.bug.web_link)
# activity
for entry in bug.bug.activity.entries:
field = entry['whatchanged']
removed = entry['oldvalue']
added = entry['newvalue']
by = self.__get_people_from_uri(entry['person_link'])
date = self.__to_datetime(entry['datechanged'])
change = Change(field, removed, added, by, date)
issue.add_change(change)
for a in bug.bug.attachments.entries:
a_url = a['data_link']
a_name = a['title']
# author and date are stored in the comment object
aux = a['message_link']
comment_id = int(aux[aux.rfind('/') + 1:])
comment = bug.bug.messages[comment_id]
a_by = self._get_person(comment.owner)
a_on = self.__drop_timezone(comment.date_created)
#a_desc = a['']
att = Attachment(a_url, a_by, a_on)
att.set_name(a_name)
#att.set_description()
issue.add_attachment(att)
return issue
def getIssue(self, bug, conn):
#Return the parse data bug into issue object
issue_id = bug.key_id
issue_type = bug.bug_type
summary = bug.summary
description = bug.description
status = bug.status
resolution = bug.resolution
assigned_by = People(bug.assignee_username)
assigned_by.set_name(bug.assignee)
assigned_by.set_email(BugsHandler.getUserEmail(bug.assignee_username))
submitted_by = People(bug.reporter_username)
submitted_by.set_name(bug.reporter)
submitted_by.set_email(BugsHandler.getUserEmail(bug.reporter_username))
submitted_on = parse(bug.created).replace(tzinfo=None)
issue = JiraIssue(issue_id, issue_type, summary, description,
submitted_by, submitted_on)
issue.set_assigned(assigned_by)
issue.setIssue_key(bug.issue_key)
issue.setTitle(bug.title)
issue.setLink(bug.link)
issue.setEnvironment(bug.environment)
issue.setSecurity(bug.security)
issue.setUpdated(parse(bug.updated).replace(tzinfo=None))
issue.setVersion(bug.version)
issue.setFixVersion(bug.fix_version)
issue.setComponent(bug.component)
issue.setVotes(bug.votes)
issue.setProject(bug.project)
issue.setProject_id(bug.project_id)
issue.setProject_key(bug.project_key)
issue.setStatus(status)
issue.setResolution(resolution)
bug_activity_url = bug.link + '?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel'
printdbg("Bug activity: " + bug_activity_url)
f = conn.urlopen_auth(bug_activity_url)
data_activity = f.read()
parser = SoupHtmlParser(data_activity, bug.key_id)
changes = parser.parse_changes()
for c in changes:
issue.add_change(c)
for comment in bug.comments:
comment_by = People(comment.comment_author)
comment_by.set_email(
BugsHandler.getUserEmail(comment.comment_author))
comment_on = parse(comment.comment_created).replace(tzinfo=None)
com = Comment(comment.comment, comment_by, comment_on)
issue.add_comment(com)
for attachment in bug.attachments:
url = "/secure/attachment/" + attachment.attachment_id + "/" + attachment.attachment_name
attachment_by = People(attachment.attachment_author)
attachment_by.set_email(
BugsHandler.getUserEmail(attachment.attachment_author))
attachment_on = parse(
attachment.attachment_created).replace(tzinfo=None)
attach = Attachment(url, attachment_by, attachment_on)
issue.add_attachment(attach)
#FIXME customfield are not stored in db because is the fields has the same in all the bugs
return issue
def analyze_bug(self, bug):
#Retrieving main bug information
printdbg(bug['url'] + " " + bug['state'] + " updated_at " +
bug['updated_at'] + ' (ratelimit = ' +
str(self.remaining_ratelimit) + ")")
issue = bug['id']
if bug['labels']:
bug_type = bug['labels'][0]['name'] # FIXME
else:
bug_type = unicode('')
summary = bug['title']
desc = bug['body']
submitted_by = self.__get_user(bug['user']['login'])
submitted_on = self.__to_datetime(bug['created_at'])
if bug['assignee']:
assignee = self.__get_user(bug['assignee']['login'])
else:
assignee = People(unicode("nobody"))
issue = GithubIssue(issue, bug_type, summary, desc, submitted_by,
submitted_on)
issue.set_assigned(assignee)
issue.set_status(bug['state'])
issue.set_description(bug['body'])
issue.set_web_link(bug['html_url'])
try:
if bug['closed_at']:
issue.set_closed_at(self.__to_datetime(bug['closed_at']))
except AttributeError:
pass
# updated_at offers ISO 8601 format: YYYY-MM-DDTHH:MM:SSZ
# MySQL doesn't support timezone, we remove it
issue.set_updated_at(self.__to_datetime(bug['updated_at']))
if bug['milestone']:
issue.set_milestone_name(bug['milestone']['id'])
issue.set_milestone_summary(bug['milestone']['description'])
issue.set_milestone_title(bug['milestone']['title'])
issue.set_milestone_web_link(bug['milestone']['url'])
comments = self.__get_batch_comments(bug['number'])
for c in comments:
by = self.__get_user(c['user']['login'])
date = self.__to_datetime(c['created_at'])
com = Comment(c['body'], by, date)
issue.add_comment(com)
# activity
entries = self.__get_batch_activities(bug['number'])
for e in entries:
field = e['event']
added = e['commit_id']
removed = unicode('')
if e['actor']:
by = self.__get_user(e['actor']['login'])
else:
by = People(u"nobody")
## by.setname() FIXME - to be done
date = self.__to_datetime(e['created_at'])
change = Change(field, removed, added, by, date)
issue.add_change(change)
return issue
def parse_issue(self, html):
"""
"""
soup = BeautifulSoup.BeautifulSoup(
html, convertEntities=BeautifulSoup.BeautifulSoup.XHTML_ENTITIES)
self.__prepare_soup(soup)
try:
id = self.__parse_issue_id(soup)
summary = self.__parse_issue_summary(soup)
desc = self.__parse_issue_description(soup)
submission = self.__parse_issue_submission(soup)
priority = self.__parse_issue_priority(soup)
status = self.__parse_issue_status(soup)
resolution = self.__parse_issue_resolution(soup)
asignation = self.__parse_issue_assigned_to(soup)
category = self.__parse_issue_category(soup)
group = self.__parse_issue_group(soup)
# FIXME the visibility var below is never used!!
#visibility = self.__parse_issue_visibility(soup)
try:
comments = self.__parse_issue_comments(soup)
except SourceForgeParserError:
printerr("Error parsing issue's comments")
comments = None
pass
try:
attachments = self.__parse_issue_attachments(soup)
except SourceForgeParserError:
printerr("Error parsing issue's attachments")
attachments = None
pass
try:
changes = self.__parse_issue_changes(soup)
except SourceForgeParserError:
printerr("Error parsing issue's changes")
changes = None
pass
except:
raise
submitted_by = People(submission['id'])
submitted_by.set_name(submission['name'])
submitted_on = submission['date']
#assigned_to = People(asignation)
assigned_to = People('')
assigned_to.set_name(asignation)
issue = SourceForgeIssue(id, 'bug', summary, desc, submitted_by,
submitted_on)
issue.set_priority(priority)
issue.set_status(status, resolution)
issue.set_assigned(assigned_to)
issue.set_category(category)
issue.set_group(group)
if comments:
for comment in comments:
submitted_by = People(comment['by']['id'])
submitted_by.set_name(comment['by']['name'])
issue.add_comment(
Comment(comment['desc'], submitted_by, comment['date']))
if attachments:
for attachment in attachments:
a = Attachment(attachment['url'])
a.set_name(attachment['filename'])
a.set_description(attachment['desc'])
issue.add_attachment(a)
if changes:
for change in changes:
changed_by = People(change['by']['id'])
changed_by.set_name(change['by']['name'])
issue.add_change(
Change(change['field'], change['old_value'], 'unknown',
changed_by, change['date']))
return issue
def get_issue(self):
issue_id = self.atags["bug_id"]
type = self.atags["bug_severity"]
summary = self.atags["short_desc"]
if len(self.ctags["long_desc"]) > 0:
desc = self.ctags["long_desc"][0]["thetext"]
else:
desc = ""
submitted_by = People(self.atags["reporter"])
submitted_by.set_name(self.atags["reporter_name"])
submitted_by.set_email(self.atags["reporter"])
submitted_on = self._convert_to_datetime(self.atags["creation_ts"])
# FIXME: I miss resolution and priority
issue = BugzillaIssue(issue_id, type, summary, desc, submitted_by,
submitted_on)
issue.set_priority(self.atags["priority"])
issue.set_status(self.atags["bug_status"])
assigned_to = People(self.atags["assigned_to"])
assigned_to.set_name(self.atags["assigned_to_name"])
assigned_to.set_email(self.atags["assigned_to"])
issue.set_assigned(assigned_to)
# FIXME = I miss the number of comment and the work_time (useful in
# bugzillas)
# date must be also a datetime
for rc in self._get_raw_comments():
if rc["bug_when"]:
by = People(rc["who"])
by.set_name(rc["who_name"])
by.set_email(rc["who"])
com = Comment(rc["thetext"], by,
self._to_datetime_with_secs(rc["bug_when"]))
issue.add_comment(com)
else:
#FIXME bug_when empty
printdbg("ERROR - Comment")
# FIXME TBD: Attachment is not supported so far
## at = Attachment
#issue.add_attachment()
# FIXME TBD: Relations
# fields in btags: dependson, blocked
# issue.add_relationship() # issue_id, type
issue.set_resolution(self.atags["resolution"])
issue.set_alias(self.atags["alias"])
issue.set_delta_ts(self._to_datetime_with_secs(self.atags["delta_ts"]))
issue.set_reporter_accessible(self.atags["reporter_accessible"])
issue.set_cclist_accessible(self.atags["cclist_accessible"])
issue.set_classification_id(self.atags["classification_id"])
issue.set_classification(self.atags["classification"])
issue.set_product(self.atags["product"])
issue.set_component(self.atags["component"])
issue.set_version(self.atags["version"])
issue.set_rep_platform(self.atags["rep_platform"])
issue.set_op_sys(self.atags["op_sys"])
if self.atags["dup_id"]:
issue.set_dup_id(int(self.atags["dup_id"]))
issue.set_bug_file_loc(self.atags["bug_file_loc"])
issue.set_status_whiteboard(self.atags["status_whiteboard"])
issue.set_target_milestone(self.atags["target_milestone"])
issue.set_votes(self.atags["votes"])
issue.set_everconfirmed(self.atags["everconfirmed"])
issue.set_qa_contact(self.atags["qa_contact"])
issue.set_estimated_time(self.atags["estimated_time"])
issue.set_remaining_time(self.atags["remaining_time"])
issue.set_actual_time(self.atags["actual_time"])
if self.atags["deadline"]:
issue.set_deadline(
self._convert_to_datetime(self.atags["deadline"]))
issue.set_keywords(self.btags["keywords"])
# we also store the list of watchers/CC
for w in self.btags["cc"]:
auxp = People(w)
issue.add_watcher(auxp)
issue.set_group(self.btags["group"])
issue.set_flag(self.btags["flag"])
return issue