Changeset 3098 for WAeUP_SRP/base/skins

Timestamp:

4 Feb 2008, 08:58:20 (17 years ago)

Author:

joachim

Message:

fix for #71 fceokene

File:

• WAeUP_SRP/base/skins/waeup_utilities/ti_71fc_resolve.py (modified) (3 diffs)

WAeUP_SRP/base/skins/waeup_utilities/ti_71fc_resolve.py

@@ -29 +29 @@
 aq_students = context.students_catalog.evalAdvancedQuery
 aq_portal = context.portal_catalog_real.evalAdvancedQuery
+course_results = context.course_results
+aq_course_results = course_results.evalAdvancedQuery
 students_folder = context.portal_url.getPortalObject().campus.students
 
@@ -52 +54 @@
     student_id = level.getPath().split('/')[-3]
     students[student_id] = level.getId
-
+course_results_to_change = []
 for student_id,level in students.items():
     study_course = getattr(getattr(students_folder,student_id),'study_course',None)
@@ -59 +61 @@
         continue
     #logger.info('%s renaming level' % (student_id))
-    if level == '110': 
-        if hasattr(study_course,'110'):
-            study_course.manage_renameObjects(('110',),('200',))
-            logger.info('%s renamed level from 110 to 200' % (student_id))
+    for level in ('110','210'): 
+        if hasattr(study_course,level):
+            new_level = "%d" % (int(level) + 90)
+            study_course.manage_renameObjects((level,),(new_level,))
+            logger.info('%s renamed level from %s to %s' % (student_id,level,new_level))
+            query = Eq('student_id',student_id) & Eq('level_id',level)
+            results = aq_course_results(query)
+            if results:
+                for result in results:
+                    d = {}
+                    for field in course_results.schema():
+                        d[field] = getattr(result,field)
+                    d['level_id'] = new_level
+                    d['old_key'] = d['key']
+                    d['key'] = d['key'].replace(level,new_level)
+                    course_results_to_change += d,
+            else:
+                logger.info('%s no course_results for %s' % (student_id,level))
         else:
-            logger.info('%s no level-object for 110' % (student_id))
-    elif level == '210':
-        if hasattr(study_course,'210'):
-            study_course.manage_renameObjects(('210',),('300',))
-            logger.info('%s renamed level from 110 to 200' % (student_id))
-        else:
-            logger.info('%s no level-object for 210' % (student_id))
+            logger.info('%s no level-object for %s' % (student_id,level))
+#set_trace()
+for result in course_results_to_change:
+    try:
+        course_results.addRecord(**result)
+        logger.info('%(student_id)s adding %(key)s' % result)
+    except ValueError:
+        set_trace()
+        logger.info('%(student_id)s %(key)s already there' % result)
+    logger.info('%(student_id)s deleting %(old_key)s' % result)
+    course_results.deleteRecord(result['old_key'])
+    
 logger.info('finished')