[PATCH] bugzilla2trac.py: import Bugzilla version 4.0.1

[tapomay.dey@…]

Creating new ticket in lines of ​http://trac.edgewall.org/ticket/7333 as that one is pretty old. Managed to import my bugs from Bugzilla version 4.0.1 into Trac version 0.11.1. Changes in the bugzilla2trac.py:

1. BZ_VERSION = 4010

   Fixed selection of correct query in TracDatabase.getFieldName
   "cursor.execute("SELECT * FROM fielddefs WHERE id = %s",(fieldid))"
   is correct.
   

2. In method TracDatabase.addAttachment

Insert following code to change : TracDatabase.env.path to absolute path

mod_env = os.path.abspath(self.env.path).	
self.env.path = mod_env

Before doing

"attachment = Attachment(self.env, 'ticket', id)"

This fixed an assertion error in attachment.py:

" assert commonprefix == attachments_dir "

System Information:
Trac:	0.11.1
Python:	2.5.2 (r252:60911, Jan 24 2010, 17:44:40) [GCC 4.3.2]
setuptools:	0.6c8
SQLite:	3.5.9
pysqlite:	2.4.1
Genshi:	0.5.1
Subversion:	1.5.1 (r32289)
jQuery:	1.2.6

P.S: Please note that I have no insight into trac codebase nor am I accustomed to python. The changes to the script are completely symptom-solution based.

[Remy Blank]

Would you mind submitting a patch? It's much easier to apply on the code than an English explanation ;)

[tapomay.dey@…]

svn Diff for bugzilla2trac.py changes w.r.t. trac-0.11.1

[tapomay.dey@…]

Please see attachment ​http://trac.edgewall.org/attachment/ticket/10504/bugzilla2py_0_11_1.diff

Is this what you meant by a patch. I followed ​http://trac.edgewall.org/wiki/TracDev/SubmittingPatches

[Remy Blank]

Yes, that's what I meant. Thank you.

[tapomay.dey@…]

svn Diff for bugzilla2trac.py changes w.r.t. trac-0.11.1 and mysql

[tapomay.dey@…]

Added one more diff - ​http://trac.edgewall.org/attachment/ticket/10504/bugzilla2py_mysql_0_11_1.diff

This is for the change I had to make while importing into Mysql database. Only difference from previous attachment (​http://trac.edgewall.org/attachment/ticket/10504/bugzilla2py_0_11_1.diff) is that I had to change table name from "Ticket" to "ticket" in the query in TracDatabase.hasTickets. "Ticket" worked for sqlite but I guess mysql has case-sensitive table names. Actual table is named "ticket". The latest code in trunk has correct table-name "ticket". Just FYI.

[Remy Blank]

Refocusing.

[Remy Blank]

Preparing for 1.0.

[Christian Boos]

Looks like the 'attachments' has to be modified anyway due to r11028.