## Script (Python) "search_pins"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=REQUEST
##title=
##
# $Id: removeResults.py 1216 2007-01-06 17:40:50Z joachim $
"""
list Students for ClearanceOfficers
"""

request = REQUEST
wftool = context.portal_workflow
mtool = context.portal_membership
member = mtool.getAuthenticatedMember()
roles = member.getRolesInContext(context)
rcat = context.results_import
#from Products.zdb import set_trace;set_trace()
if str(member) not in ('admin','joachim'):
    return 
count = 0
for m in rcat.uniqueValuesFor('matric_no'):
    if m.startswith('ENG'):
        res = rcat(matric_no = m)
        to_del = []
        for r in res:
            to_del.append(r.key)
        for uid in to_del:
            rcat.deleteRecord(uid)
        count += len(to_del)
return "%d deleted" % count