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

## Script (Python) "createReturningStudent"
##bind container=container
##bind context=context
##bind namespace=
##bind script=script
##bind subpath=traverse_subpath
##parameters=matric_no=None
##title=
##
# $Id: createReturningStudent.py 1151 2006-12-29 22:05:53Z joachim $
''' create the Studentbase folder'''


pm = context.portal_membership
member = pm.getAuthenticatedMember()
wftool = context.portal_workflow
students_folder = context.portal_url.getPortalObject().campus.students
import logging
logger = logging.getLogger('createReturningStudent')

if not matric_no:
    return "No MatricNo"

if matric_no != 'All':
    if context.students_catalog(matric_no=matric_no):
        return "Student with %s already exists" % matric_no
    res = context.returning_import(matric_no = matric_no)
    if len(res) != 1:
        return "MatricNo %s not found in Returning Table" % matric_no
    student_brain = res[0]
    sid,jamb_reg_no = context.waeup_tool.createOne(students_folder,student_brain,'?')
    logger.info('"%s","Created Student","%s", "%s" ' % (member,sid,matric_no))
    return "Student MatricNo %s, StudentId %s (JAMBRegNo %s) created" % (matric_no,sid,jamb_reg_no)

matric_nos = context.returning_import.uniqueValuesFor('matric_no')
count = 1
total = 0
logger.info('"%s","Create Students start"' % (member))
letters = ('ABCDEFGHKLMNPQRSTUVWXYZ')
lc = 0
for matric_no in matric_nos:
    res = context.students_catalog(matric_no = matric_no)
    if len(res) == 1:
        #logger.info('"Student already exists","%s"' % (matric_no))
        continue
    elif len(res) > 1:
        logger.info('"Student with multiple entries","%s","%s" ' % (matric_no,len(res)))
        ids = [r.id for r in res if not r.id.startswith('A')]
        #from Products.zdb import set_trace;set_trace()
        for id in ids:
            context.students_catalog.deleteRecord(id)
        students_folder.manage_delObjects(ids)
        logger.info('"deleted students","%s" ' % " ".join(ids))
        continue
    student = context.returning_import(matric_no=matric_no)[0]
    letter = letters[lc]
    lc += 1
    if lc == len(letters):
        lc = 0
    context.waeup_tool.createOne(students_folder,student,letter)
    logger.info('"Student created","%s"' % (matric_no))
    count += 1
    if count > 10:
        logger.info('"%s","Committed Students","%s", "%s" ' % (member,count,total))
        total += count
        count = 1
logger.info('"%s","Create Students finish","%s"' % (member,total))