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

Timestamp:

07/13/06 14:39:25 (17 years ago)

Author:

bas

Message:

EmailtoTracScript?:

delete_spam.py.in:

• Fixed several erros

File:

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

emailtotracscript/trunk/delete_spam.py.in

@@ -79 +79 @@
                         env = Environment(project, create=0)
                         db = env.get_db_cnx()
-                        
+
+                        attachment_dir = os.path.join(env.path, 'attachments', 'ticket')
+
                         cursor = db.cursor()
 
@@ -90 +92 @@
                                         break
                                 spam_id =  row[0]
-                                attachment_dir = os.path.join(env.get_attachments_dir(), 'ticket', str(spam_id)) 
-                                if os.path.exists(attachment_dir):
+
+                                sql_cmd = "DELETE FROM attachment WHERE type='ticket' and id='%s';" %spam_id
+                                cursor.execute(sql_cmd) 
+
+                                dir = os.path.join(attachment_dir, str(spam_id)) 
+                                if os.path.exists(dir):
                                         if debug:
-                                                print 'delete %s : %s' %(spam_id, attachment_dir)
+                                                print 'delete %s : %s' %(spam_id, dir)
                                         try:
-                                                shutil.rmtree(attachment_dir)
+                                                shutil.rmtree(dir)
                                         except OSError, detail:
                                                 print 'Contact system-administrator: %s' %detail