[2540] | 1 | ## Script (Python) "admitStudents" |
---|
| 2 | ##bind container=container |
---|
| 3 | ##bind context=context |
---|
| 4 | ##bind namespace= |
---|
| 5 | ##bind script=script |
---|
| 6 | ##bind subpath=traverse_subpath |
---|
| 7 | ##parameters= |
---|
| 8 | ##title= |
---|
| 9 | ## |
---|
| 10 | # $Id: admitStudents.py 2727 2007-11-21 14:12:30Z joachim $ |
---|
| 11 | """ |
---|
| 12 | """ |
---|
| 13 | try: |
---|
| 14 | from Products.zdb import set_trace |
---|
| 15 | except: |
---|
| 16 | def set_trace(): |
---|
| 17 | pass |
---|
| 18 | |
---|
| 19 | mtool = context.portal_membership |
---|
| 20 | member = mtool.getAuthenticatedMember() |
---|
| 21 | if str(member) not in ('admin','joachim'): |
---|
| 22 | return |
---|
| 23 | |
---|
[2575] | 24 | entry_session = '07' |
---|
[2576] | 25 | pin_password = False |
---|
[2540] | 26 | |
---|
| 27 | import logging |
---|
| 28 | import DateTime |
---|
| 29 | logger = logging.getLogger('Skins.admitStudents') |
---|
| 30 | from Products.AdvancedQuery import Eq, Between, Le,In |
---|
| 31 | aq_applicants = context.applicants_catalog.evalAdvancedQuery |
---|
| 32 | request = context.REQUEST |
---|
| 33 | session = request.SESSION |
---|
| 34 | response = request.RESPONSE |
---|
| 35 | setheader = request.RESPONSE.setHeader |
---|
| 36 | def rwrite(s): |
---|
| 37 | response.setHeader('Content-type','text/html; charset=ISO-8859-15') |
---|
| 38 | response.write("%s<br>\n\r" % s) |
---|
| 39 | |
---|
[2575] | 40 | brains = aq_applicants(In('status',('admitted'),)) |
---|
[2540] | 41 | total = len(brains) |
---|
| 42 | logger.info("found %d students" % (total)) |
---|
| 43 | count = 0 |
---|
| 44 | admitted = 0 |
---|
| 45 | cocount = 0 |
---|
[2671] | 46 | commit_after = 20 |
---|
[2540] | 47 | d = {'status': 'created'} |
---|
| 48 | reg_nos = [brain.reg_no for brain in brains] |
---|
| 49 | for reg_no in reg_nos: |
---|
| 50 | count += 1 |
---|
| 51 | if admitted and not admitted % commit_after: |
---|
| 52 | context.waeup_tool.doCommit() |
---|
| 53 | logger.info("Committing %s transactions, total %s" % (commit_after,count)) |
---|
[2727] | 54 | # cocount += 1 |
---|
| 55 | # if cocount > 1: |
---|
| 56 | # break |
---|
[2540] | 57 | brain = aq_applicants(Eq('reg_no',reg_no))[0] |
---|
| 58 | #logger.info("start creating objects of student %s" % (brain.reg_no)) |
---|
[2576] | 59 | sid = d['student_id'] = context.waeup_tool.admitOneStudent(brain,entry_session,pin_password) |
---|
[2540] | 60 | if sid is not None: |
---|
| 61 | d['reg_no'] = reg_no |
---|
| 62 | context.applicants_catalog.modifyRecord(**d) |
---|
| 63 | logger.info("created objects of student %s with id %s" % (reg_no,sid)) |
---|
| 64 | admitted += 1 |
---|
| 65 | else: |
---|
[2727] | 66 | logger.info("could not create objects of student %s with pin %s" % (reg_no,brain.pin)) |
---|
[2575] | 67 | |
---|
[2540] | 68 | msg = "finished admitting %d students" % (admitted) |
---|
| 69 | logger.info(msg) |
---|
[2671] | 70 | #rwrite(msg) |
---|
| 71 | return |
---|