Changeset 73 for emailtotracscript/trunk

Timestamp:

05/22/06 12:46:09 (18 years ago)

Author:

bas

Message:

EmailtoTracScript?:

email2trac.py.in:

• Fixed an error with duplicate attachments Thanks Walter

File:

• emailtotracscript/trunk/email2trac.py.in (modified) (2 diffs)

emailtotracscript/trunk/email2trac.py.in

@@ -563 +563 @@
 
                         # Insert the attachment it differs for the different TRAC versions
-                        #
+                        # 
                         if self.VERSION == 0.8:
                                 cursor = self.db.cursor()
-                                cursor.execute('INSERT INTO attachment VALUES("%s","%s","%s",%d,%d,"%s","%s","%s")' 
-                                        %('ticket', urllib.quote(str(ticket['id'])), filename + '?format=raw', filesize, 
-                                          int(time.time()),'', self.author, 'e-mail') ) 
+                                try:
+                                        cursor.execute('INSERT INTO attachment VALUES("%s","%s","%s",%d,%d,"%s","%s","%s")' 
+                                                %('ticket', urllib.quote(str(ticket['id'])), filename + '?format=raw', filesize, 
+                                                int(time.time()),'', self.author, 'e-mail') ) 
+
+                                # Attachment is already known
+                                #
+                                except sqlite.IntegrityError:   
+                                        self.db.close()
+                                        return 
+
                                 self.db.commit()
+
                         else:
                                 fd = open(path)
@@ -673 +682 @@
                 from trac.Href import Href
                 from trac import util
+                import sqlite
         elif version == 0.9:
                 from trac import attachment