1427623 - jb2bz.py fails to set priority for imported bugs

Status: UNCONFIRMED

(Bugzilla :: Bugzilla-General, defect)

Description

[Quanah Gibson-Mount]

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
Build ID: 20171226083017

Steps to reproduce:

When importing bugs from jitterbugs to bugzilla, I expected to be able to use the search interface to find the imported bugs


Actual results:

The search interface would never return any results.  This is because of the following SQL query that's executed as part of a search:

INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value


Expected results:

The search interface should have returned results, instead it found no issues, as the above query is empty due to priority not being set on import.

Comment 1

[Quanah Gibson-Mount]

Mainly, need to modify this function:

    try:
        cursor.execute( "INSERT INTO bugs SET " \
                        "bug_id=%s," \
                        "bug_severity='normal',"  \
                        "bug_status=%s," \
                        "creation_ts=%s,"  \

to have priority set:

    try:
        cursor.execute( "INSERT INTO bugs SET " \
                        "bug_id=%s," \
                        "bug_priority=---" \
                        "bug_severity='normal',"  \
                        "bug_status=%s," \
                        "creation_ts=%s,"  \

I will submit a pull request later, after I iron out a few other bugs.

Comment 2

[Quanah Gibson-Mount]

s/bug_priority/priority/ in the above

Comment 3

[Quanah Gibson-Mount]

https://github.com/bugzilla/bugzilla/pull/57