1 | ## Script (Python) "reindex_entry_mode" |
---|
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: reindex_entry_mode.py 1328 2007-01-19 18:16:32Z joachim $ |
---|
11 | """ |
---|
12 | reindex students_catalog entry_mode index |
---|
13 | """ |
---|
14 | try: |
---|
15 | from Products.zdb import set_trace |
---|
16 | except: |
---|
17 | def set_trace(): |
---|
18 | pass |
---|
19 | |
---|
20 | request = context.REQUEST |
---|
21 | session = request.SESSION |
---|
22 | response = request.RESPONSE |
---|
23 | setheader = request.RESPONSE.setHeader |
---|
24 | students = context.portal_url.getPortalObject().campus.students |
---|
25 | |
---|
26 | def rwrite(s): |
---|
27 | response.setHeader('Content-type','text/html; charset=ISO-8859-15') |
---|
28 | response.write(s) |
---|
29 | |
---|
30 | cat = context.students_catalog |
---|
31 | |
---|
32 | ems = cat.uniqueValuesFor('entry_mode') |
---|
33 | ##rwrite("entry_mode values: %s<br />\n" % (str(ems))) |
---|
34 | ##for em in ems: |
---|
35 | ## res = cat(entry_mode = em) |
---|
36 | ## rwrite("entry_mode: %s = %d<br />\n" % (em,len(res))) |
---|
37 | |
---|
38 | sbrains = cat() |
---|
39 | count = 0 |
---|
40 | lines = [] |
---|
41 | #set_trace() |
---|
42 | for sb in sbrains: |
---|
43 | em = context.getFromData_entry_mode(sb.id) |
---|
44 | level_cat = sb.level |
---|
45 | new_em = context.getEntryMode(sb.jamb_reg_no) |
---|
46 | app_found = False |
---|
47 | if students.hasObject(sb.id): |
---|
48 | student_obj = getattr(students,sb.id) |
---|
49 | if student_obj.hasObject('application'): |
---|
50 | app = getattr(student_obj,'application') |
---|
51 | app.getContent().edit(mapping={'entry_mode': new_em}) |
---|
52 | cat.modifyRecord(id = sb.id,entry_mode = new_em) |
---|
53 | app_found = True |
---|
54 | if not app_found: |
---|
55 | cat.modifyRecord(id = sb.id,entry_mode = "") |
---|
56 | s = '"%s","%s","%s","%s","%s","%s","%s"' % (app_found,sb.id,sb.matric_no,em, |
---|
57 | sb.jamb_reg_no,new_em,level_cat) |
---|
58 | #lines.append('"%s","%s","%s","%s"' % (sb.id,sb.matric_no,moe,new_em)) |
---|
59 | rwrite("%s<br />" %s) |
---|
60 | |
---|
61 | #setheader('Content-type','text/semicolon-seperated-values') |
---|
62 | #setheader('Content-Disposition:', 'attachment; filename="fixLevelExport.csv"') |
---|
63 | #setheader('Expires', 'Mon, 26 Jul 1997 05:00:00GMT') # Date in the past |
---|
64 | #setheader('Cache-Control', 'no-store, no-cache,must-revalidate') # HTTP/1.1 |
---|
65 | #setheader('Cache-Control', 'post-check=0,pre-check=0') |
---|
66 | #setheader('Pragma', 'no-cache') # HTTP/1.0 |
---|
67 | #return '\n'.join(lines) |
---|
68 | |
---|
69 | rwrite("<br />\n Done" ) |
---|
70 | |
---|