Changeset 5610

Timestamp:

10 Dec 2010, 09:28:18 (14 years ago)

Author:

Henrik Bettermann

Message:

Search for substring 'Cumulative total of payment' in resp_desc and remove payment.

File:

• WAeUP_SRP/trunk/skins/waeup_epayment/purgeDefinedPayments.py (modified) (1 diff)

WAeUP_SRP/trunk/skins/waeup_epayment/purgeDefinedPayments.py

@@ -26 +26 @@
 import DateTime
 logger = logging.getLogger('Skins.purgeDefinedPayments')
-from Products.AdvancedQuery import Eq, Between, Le,In
+from Products.AdvancedQuery import Eq, Between, Le,In,MatchGlob,MatchRegexp
 aq_payments = context.payments_catalog.evalAdvancedQuery 
 
 commit_after = 100
 counter = 0
+counter_all = 0
 
-#payments = context.payments_catalog(resp_desc = 'Invalid Card Number') 
-query = Eq('resp_desc','Invalid Card Number') 
-payments = aq_payments(query)
+payments = context.payments_catalog(status = 'failed') 
+#query = In('resp_desc','Invalid*',) 
+#payments = aq_payments(query)
+
+logger.info("started, %d failed payments found" % len(payments))
 
 for payment in payments:
-    to_del = []
+    counter_all += 1
+    if not 'Cumulative total of payment' in payment.resp_desc:
+        continue
     payments_folder = getattr(getattr(students_folder,payment.student_id),'payments',None)       
-    
     counter += 1
     pid = 'p' + payment.order_id[6:]   
     if getattr(payments_folder,pid,False):
-        logger.info('object deleted: %s , %s, %s' % (payment.student_id, pid, payment.resp_desc))
+        logger.info('object deleted: %s , %s, %s, %d of %d' % (payment.student_id, pid, payment.resp_desc, counter, counter_all))
     else:
         logger.info('no object: %s, %s' % (payment.student_id, pid))