source: WAeUP_SRP/branches/regebro-noskins/skins/waeup_utilities/increaseReturningLevels.py

## Script (Python) "search_pins"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=REQUEST
##title=
##
# $Id: increaseReturningLevels.py 1393 2007-02-05 21:42:08Z joachim $
"""
increase the Level for returning Students
"""

request = REQUEST
wftool = context.portal_workflow
mtool = context.portal_membership
member = mtool.getAuthenticatedMember()
retcat = context.returning_import
rcat = context.results_import
scat = context.students_catalog
from Products.AdvancedQuery import Eq, Between, Le,In
aq_students = context.students_catalog.evalAdvancedQuery

if str(member) not in ('admin','joachim'):
    return 
count = 0
#from Products.zdb import set_trace;set_trace()
returning = retcat(email='')
l = []
for sb in returning:
    s = context.students_catalog(matric_no=sb.matric_no)
    if s and s[0].level:
        level = "%s" % (int(s[0].level) + 100)
        context.students_catalog.modifyRecord(id = s[0].id,
                                              level=level)
        l.append("%s old/new %s/%s" % (s[0].id,s[0].level,level))
return "\n".join(l)