## Script (Python) "cleanPymentsCatalog.py"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=
##title=
##
# $Id: upgradePayments.py 2918 2007-12-10 23:57:23Z henrik $
"""
"""
try:
    from Products.zdb import set_trace
except:
    def set_trace():
        pass

mtool = context.portal_membership
member = mtool.getAuthenticatedMember()
if str(member) not in ('admin','joachim'):
    return


import logging
import DateTime
logger = logging.getLogger('Skins.cleanPaymentsCatalog')

count = 1
d = {}
l = []
sum_total = 0.0
log_after = 100
logger.info("start")


payments = context.payments_catalog()
count = 0
total = 0
to_del = []

for payment_brain in payments:
    total += 1
    logger.info("%s" % (payment_brain.order_id))
    if payment_brain.order_id.startswith('p'):
        to_del.append(payment_brain.order_id)
        count += 1
        
for uid in to_del:
    context.payments_catalog.deleteRecord(uid)        
    logger.info("%s deleted" % (uid))
        
        
logger.info("%d of %d payment records deleted" % (count,total))