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

Timestamp:

09/29/06 13:07:07 (18 years ago)

Author:

bas

Message:

EmailtoTracScript?:

delete_spam.py.in:

• Now deletes all Spam ticket information form the different SQL tables

debian/changelog, email2trac.spec, ChangeLog?:

• Preparing for new release

File:

• emailtotracscript/trunk/delete_spam.py.in (modified) (1 diff)

emailtotracscript/trunk/delete_spam.py.in

@@ -96 +96 @@
                                 cursor.execute(sql_cmd) 
 
+                                sql_cmd = "DELETE FROM ticket_change WHERE ticket='%s';" %spam_id
+                                cursor.execute(sql_cmd) 
+
+                                sql_cmd = "DELETE FROM ticket_custom WHERE ticket='%s';" %spam_id
+                                cursor.execute(sql_cmd) 
+
                                 dir = os.path.join(attachment_dir, str(spam_id)) 
                                 if os.path.exists(dir):