Changeset 8478

Timestamp:

21 May 2012, 07:17:50 (12 years ago)

Author:

Henrik Bettermann

Message:

Prepare script for migration of AAUE data.

File:

• main/waeup.kofa/trunk/tools/fix_import_file.py (modified) (8 diffs)

main/waeup.kofa/trunk/tools/fix_import_file.py

@@ -40 +40 @@
 # Converter (see below)
 OPTIONS = {
+    'student_id': 'student_id',
     'sex': 'gender',
     'birthday': 'date',
@@ -52 +53 @@
     'password': 'password',
     'phone': 'phone',
+    'nationality': 'nationality',
     'level': 'level',
     'start_level': 'level',
@@ -66 +68 @@
 COLNAME_MAPPING = {
     # base data
+    'reg_state': 'state',
     'jamb_reg_no': 'reg_number',
     'matric_no': 'matric_number',
@@ -94 +97 @@
     }
 
-# Mapping input regh_state --> output reg_state
+# Mapping input state --> output state
 REGSTATE_MAPPING = {
     'student_created': 'created',
@@ -128 +131 @@
     """Converters to turn old-style values into new ones.
     """
+
+    @classmethod
+    def student_id(self, value):
+        """ 'A123456' --> 'EA123456'
+        """
+        if len(value) == 7:
+            return 'E' + value
+        return value
+
     @classmethod
     def reg_state(self, value):
@@ -183 +195 @@
     def session(self, value):
         """ '08' --> '2008'
-        """
+        '2008/2009' --> '2008'
+        """
+        if '/' in value:
+            numbers = value.split('/')
+            number = int(numbers[0])
+            if number in range(2000,2015):
+                return number
+            else:
+                return 9999
         try:
             number = int(value)
@@ -274 +294 @@
 
     @classmethod
+    def nationality(self, value):
+        if value == "nigeria":
+            return "NG"
+        return value
+
+    @classmethod
     def phone(self, value):
         """ '<num-seq1>-<num-seq2> asd' -> '--<num-seq1><num-seq2>'
@@ -284 +310 @@
         match = RE_PHONE.match(value)
         phone = match.groups()[0]
-        value = '--%s' % phone
+        value = '-%s' % phone
         return value