Changeset 137 for emailtotracscript/trunk/delete_spam.py.in

Timestamp:

12/01/06 12:30:36 (17 years ago)

Author:

bas

Message:

EmailtoTracScript?:

delete_spam.py.in:

• Did not work for version 0.10, fixed it

File:

• emailtotracscript/trunk/delete_spam.py.in (modified) (5 diffs)

emailtotracscript/trunk/delete_spam.py.in

@@ -87 +87 @@
         db = env.get_db_cnx()
 
+        cursor = db.cursor()
         cursor.execute("SELECT id FROM ticket WHERE  component = 'Spam';") 
         while 1: 
@@ -95 +96 @@
                 spam_id =  row[0]
 
+                if debug:
+                        print "Deleting ticket %s" %spam_id
+
                 try:
                         tkt = Ticket(env, spam_id, db)
-                except TracError, detail:
+                except util.TracError, detail:
+                        print detail
                         continue
 
-                if debug:
-                        print "Deleting ticket %s" %spam_id
-                
                 tkt.delete()
 
@@ -124 +126 @@
                         break
                 spam_id =  row[0] 
-                
+        
                 if debug:
+                        print spam_id 
+
                         sql_cmd = "SELECT *  FROM attachment WHERE type='ticket' and id='%s';" %spam_id
                         tkt_cursor.execute(sql_cmd) 
@@ -153 +157 @@
                 # 
                 db.commit() 
+
                 dir = os.path.join(attachment_dir, str(spam_id)) 
                 if os.path.exists(dir):
@@ -202 +207 @@
         if version == 0.8:
                 from trac.Environment import Environment
+                from trac import util
         else:
                 from trac.env import Environment
                 from trac.ticket import Ticket
+                from trac import util
 
         if version == 0.10:
                 new_delete_spam(settings['project'], int(settings['debug']))
+                #new_delete_spam(settings['project'], 1)
+                #old_delete_spam(settings['project'], 0)
         elif version == 0.9:
                 old_delete_spam(settings['project'], int(settings['debug']))