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 2576 2007-11-08 07:55:07Z henrik $ |
---|
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 | |
---|
24 | entry_session = '07' |
---|
25 | pin_password = False |
---|
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 | |
---|
40 | brains = aq_applicants(In('status',('admitted'),)) |
---|
41 | total = len(brains) |
---|
42 | logger.info("found %d students" % (total)) |
---|
43 | count = 0 |
---|
44 | admitted = 0 |
---|
45 | cocount = 0 |
---|
46 | commit_after = 2 |
---|
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)) |
---|
54 | cocount += 1 |
---|
55 | if cocount > 1: |
---|
56 | break |
---|
57 | brain = aq_applicants(Eq('reg_no',reg_no))[0] |
---|
58 | #logger.info("start creating objects of student %s" % (brain.reg_no)) |
---|
59 | sid = d['student_id'] = context.waeup_tool.admitOneStudent(brain,entry_session,pin_password) |
---|
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: |
---|
66 | logger.info("could not create objects of student %s with pin " % (reg_no,brain.pin)) |
---|
67 | |
---|
68 | msg = "finished admitting %d students" % (admitted) |
---|
69 | logger.info(msg) |
---|
70 | rwrite(msg) |
---|