From d92abdae989ae53cbd1dba89aeb83596e260dac1 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Sat, 18 Jun 2016 13:58:37 +0000 Subject: reproducible debian: common: collect bug titles too while collecting data about bugs Signed-off-by: Holger Levsen --- bin/reproducible_common.py | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py index d0224b1b..d9704052 100755 --- a/bin/reproducible_common.py +++ b/bin/reproducible_common.py @@ -570,13 +570,13 @@ def get_bugs(): """ This function returns a dict: { "package_name": { - bug1: {patch: True, done: False}, - bug2: {patch: False, done: False}, + bug1: {patch: True, done: False, title: "string"}, + bug2: {patch: False, done: False, title: "string"}, } } """ query = """ - SELECT bugs.id, bugs.source, bugs.done, ARRAY_AGG(tags.tag) + SELECT bugs.id, bugs.source, bugs.done, ARRAY_AGG(tags.tag), bugs.title FROM bugs JOIN bugs_usertags ON bugs.id = bugs_usertags.id LEFT JOIN ( SELECT id, tag FROM bugs_tags @@ -608,9 +608,9 @@ def get_bugs(): if bug[1] not in packages: packages[bug[1]] = {} # bug[0] = bug_id, bug[1] = source_name, bug[2] = who_when_done, - # bug[3] = tag (patch or pending) + # bug[3] = tag (patch or pending), bug[4] = title packages[bug[1]][bug[0]] = { - 'done': False, 'patch': False, 'pending': False + 'done': False, 'patch': False, 'pending': False, 'title': bug[4] } if bug[2]: # if the bug is done packages[bug[1]][bug[0]]['done'] = True -- cgit v1.2.3-70-g09d2