| 1 | ## $Id: test_export.py 17769 2024-05-13 06:26:57Z henrik $ |
|---|
| 2 | ## |
|---|
| 3 | ## Copyright (C) 2011 Uli Fouquet & Henrik Bettermann |
|---|
| 4 | ## This program is free software; you can redistribute it and/or modify |
|---|
| 5 | ## it under the terms of the GNU General Public License as published by |
|---|
| 6 | ## the Free Software Foundation; either version 2 of the License, or |
|---|
| 7 | ## (at your option) any later version. |
|---|
| 8 | ## |
|---|
| 9 | ## This program is distributed in the hope that it will be useful, |
|---|
| 10 | ## but WITHOUT ANY WARRANTY; without even the implied warranty of |
|---|
| 11 | ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|---|
| 12 | ## GNU General Public License for more details. |
|---|
| 13 | ## |
|---|
| 14 | ## You should have received a copy of the GNU General Public License |
|---|
| 15 | ## along with this program; if not, write to the Free Software |
|---|
| 16 | ## Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|---|
| 17 | ## |
|---|
| 18 | |
|---|
| 19 | import os |
|---|
| 20 | import grok |
|---|
| 21 | import datetime |
|---|
| 22 | from cStringIO import StringIO |
|---|
| 23 | from zope.component import queryUtility, getUtility, createObject |
|---|
| 24 | from zope.event import notify |
|---|
| 25 | from zope.interface.verify import verifyObject, verifyClass |
|---|
| 26 | from waeup.kofa.interfaces import ( |
|---|
| 27 | ICSVExporter, IExtFileStore, IFileStoreNameChooser) |
|---|
| 28 | from waeup.kofa.students.catalog import StudentsQuery |
|---|
| 29 | from waeup.kofa.university.course import Course |
|---|
| 30 | from waeup.kofa.university.certificate import CertificateCourse |
|---|
| 31 | from waeup.kofa.students.export import ( |
|---|
| 32 | StudentExporter, |
|---|
| 33 | StudentStudyCourseExporter, |
|---|
| 34 | FirstStudentStudyCourseExporter, |
|---|
| 35 | SecondStudentStudyCourseExporter, |
|---|
| 36 | StudentStudyLevelExporter, |
|---|
| 37 | FirstStudentStudyLevelExporter, |
|---|
| 38 | SecondStudentStudyLevelExporter, |
|---|
| 39 | CourseTicketExporter, |
|---|
| 40 | FirstCourseTicketExporter, |
|---|
| 41 | SecondCourseTicketExporter, |
|---|
| 42 | StudentPaymentExporter, BedTicketExporter, |
|---|
| 43 | SchoolFeePaymentsOverviewExporter, StudyLevelsOverviewExporter, |
|---|
| 44 | ComboCardDataExporter, DataForBursaryExporter, |
|---|
| 45 | UnpaidPaymentsExporter, SessionPaymentsOverviewExporter, |
|---|
| 46 | OutstandingCoursesExporter, |
|---|
| 47 | AccommodationPaymentsExporter, |
|---|
| 48 | TranscriptDataExporter, |
|---|
| 49 | TrimmedDataExporter, |
|---|
| 50 | StudentTrimmedPaymentExporter, |
|---|
| 51 | get_students,) |
|---|
| 52 | from waeup.kofa.students.accommodation import BedTicket |
|---|
| 53 | from waeup.kofa.students.interfaces import ICSVStudentExporter |
|---|
| 54 | from waeup.kofa.students.payments import StudentOnlinePayment |
|---|
| 55 | from waeup.kofa.students.student import Student |
|---|
| 56 | from waeup.kofa.students.studycourse import StudentStudyCourse |
|---|
| 57 | from waeup.kofa.students.studylevel import StudentStudyLevel, CourseTicket |
|---|
| 58 | from waeup.kofa.students.tests.test_batching import StudentImportExportSetup |
|---|
| 59 | from waeup.kofa.testing import FunctionalLayer |
|---|
| 60 | |
|---|
| 61 | curr_year = datetime.datetime.now().year |
|---|
| 62 | year_range = range(curr_year - 11, curr_year + 1) |
|---|
| 63 | year_range_str = ','.join([str(i) for i in year_range]) |
|---|
| 64 | |
|---|
| 65 | class ExportHelperTests(StudentImportExportSetup): |
|---|
| 66 | layer = FunctionalLayer |
|---|
| 67 | def setUp(self): |
|---|
| 68 | super(ExportHelperTests, self).setUp() |
|---|
| 69 | student = Student() |
|---|
| 70 | self.app['students'].addStudent(student) |
|---|
| 71 | student = self.setup_student(student) |
|---|
| 72 | notify(grok.ObjectModifiedEvent(student)) |
|---|
| 73 | self.student = self.app['students'][student.student_id] |
|---|
| 74 | return |
|---|
| 75 | |
|---|
| 76 | def test_get_students_plain(self): |
|---|
| 77 | # without a filter we get all students |
|---|
| 78 | result = get_students(self.app) |
|---|
| 79 | self.assertEqual(len(list(result)), 1) |
|---|
| 80 | return |
|---|
| 81 | |
|---|
| 82 | def test_get_students_by_session(self): |
|---|
| 83 | # we can filter out students of a certain session |
|---|
| 84 | my_filter1 = StudentsQuery(current_session=2012) |
|---|
| 85 | result = get_students(self.app, stud_filter=my_filter1) |
|---|
| 86 | self.assertEqual(len(list(result)), 1) |
|---|
| 87 | |
|---|
| 88 | my_filter2 = StudentsQuery(current_session=1964) |
|---|
| 89 | result = get_students(self.app, stud_filter=my_filter2) |
|---|
| 90 | self.assertEqual(len(list(result)), 0) |
|---|
| 91 | return |
|---|
| 92 | |
|---|
| 93 | def test_get_students_by_level(self): |
|---|
| 94 | # we can filter out students of a certain level |
|---|
| 95 | my_filter1 = StudentsQuery(current_level=200) |
|---|
| 96 | result = get_students(self.app, stud_filter=my_filter1) |
|---|
| 97 | self.assertEqual(len(list(result)), 1) |
|---|
| 98 | |
|---|
| 99 | my_filter2 = StudentsQuery(current_level=300) |
|---|
| 100 | result = get_students(self.app, stud_filter=my_filter2) |
|---|
| 101 | self.assertEqual(len(list(result)), 0) |
|---|
| 102 | return |
|---|
| 103 | |
|---|
| 104 | def test_get_students_by_deptcode(self): |
|---|
| 105 | # we can filter out students of a certain dept. |
|---|
| 106 | my_filter1 = StudentsQuery(depcode='NA') |
|---|
| 107 | result = get_students(self.app, stud_filter=my_filter1) |
|---|
| 108 | self.assertEqual(len(list(result)), 1) |
|---|
| 109 | |
|---|
| 110 | my_filter2 = StudentsQuery(depcode='NOTEXISTING') |
|---|
| 111 | result = get_students(self.app, stud_filter=my_filter2) |
|---|
| 112 | self.assertEqual(len(list(result)), 0) |
|---|
| 113 | return |
|---|
| 114 | |
|---|
| 115 | def test_get_students_by_faccode(self): |
|---|
| 116 | # we can filter out students of a certain faculty. |
|---|
| 117 | my_filter1 = StudentsQuery(faccode='NA') |
|---|
| 118 | result = get_students(self.app, stud_filter=my_filter1) |
|---|
| 119 | self.assertEqual(len(list(result)), 1) |
|---|
| 120 | |
|---|
| 121 | my_filter2 = StudentsQuery(faccode='NOTEXISTING') |
|---|
| 122 | result = get_students(self.app, stud_filter=my_filter2) |
|---|
| 123 | self.assertEqual(len(list(result)), 0) |
|---|
| 124 | return |
|---|
| 125 | |
|---|
| 126 | def test_get_students_by_current_mode(self): |
|---|
| 127 | # we can filter out students in a certain mode. |
|---|
| 128 | my_filter1 = StudentsQuery(current_mode='ug_ft') |
|---|
| 129 | result = get_students(self.app, stud_filter=my_filter1) |
|---|
| 130 | self.assertEqual(len(list(result)), 1) |
|---|
| 131 | |
|---|
| 132 | my_filter2 = StudentsQuery(current_mode='NOTEXISTING') |
|---|
| 133 | result = get_students(self.app, stud_filter=my_filter2) |
|---|
| 134 | self.assertEqual(len(list(result)), 0) |
|---|
| 135 | return |
|---|
| 136 | |
|---|
| 137 | |
|---|
| 138 | class StudentExporterTest(StudentImportExportSetup): |
|---|
| 139 | |
|---|
| 140 | layer = FunctionalLayer |
|---|
| 141 | |
|---|
| 142 | std_csv_entry = ( |
|---|
| 143 | 'my adm code,my clr code,1981-02-04#,anna@sample.com,,' |
|---|
| 144 | 'Anna,,Tester,234,M.,NG,,,"Studentroad 21\nLagos 123456\n",,' |
|---|
| 145 | '+234-123-12345#,123,f,A111111,0,,,created' |
|---|
| 146 | ) |
|---|
| 147 | |
|---|
| 148 | def setUp(self): |
|---|
| 149 | super(StudentExporterTest, self).setUp() |
|---|
| 150 | self.setup_for_export() |
|---|
| 151 | return |
|---|
| 152 | |
|---|
| 153 | def test_ifaces(self): |
|---|
| 154 | # make sure we fullfill interface contracts |
|---|
| 155 | obj = StudentExporter() |
|---|
| 156 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 157 | verifyClass(ICSVStudentExporter, StudentExporter) |
|---|
| 158 | return |
|---|
| 159 | |
|---|
| 160 | def test_get_as_utility(self): |
|---|
| 161 | # we can get an student exporter as utility |
|---|
| 162 | result = queryUtility(ICSVExporter, name="students") |
|---|
| 163 | self.assertTrue(result is not None) |
|---|
| 164 | return |
|---|
| 165 | |
|---|
| 166 | def test_export(self): |
|---|
| 167 | # we can really export students |
|---|
| 168 | # set values we can expect in export file |
|---|
| 169 | self.setup_student(self.student) |
|---|
| 170 | exporter = StudentExporter() |
|---|
| 171 | exporter.export([self.student], self.outfile) |
|---|
| 172 | result = open(self.outfile, 'rb').read() |
|---|
| 173 | self.assertTrue( |
|---|
| 174 | 'adm_code,clr_code,date_of_birth,email,' |
|---|
| 175 | 'employer,firstname,flash_notice,lastname,matric_number,middlename,' |
|---|
| 176 | 'nationality,officer_comment,parents_email,' |
|---|
| 177 | 'perm_address,personal_updated,' |
|---|
| 178 | 'phone,reg_number,sex,student_id,suspended,suspended_comment,' |
|---|
| 179 | 'password,state,history,certcode,is_postgrad,' |
|---|
| 180 | 'current_level,current_session,entry_session\r\n' |
|---|
| 181 | 'my adm code,my clr code,' |
|---|
| 182 | '1981-02-04#,anna@sample.com,,Anna,,Tester,234,M.,NG,,,' |
|---|
| 183 | '"Studentroad 21\nLagos 123456\n",,+234-123-12345#,123,f,' |
|---|
| 184 | 'A111111,0,,,created' |
|---|
| 185 | in result |
|---|
| 186 | ) |
|---|
| 187 | return |
|---|
| 188 | |
|---|
| 189 | def test_export_all(self): |
|---|
| 190 | # we can really export students |
|---|
| 191 | # set values we can expect in export file |
|---|
| 192 | self.setup_student(self.student) |
|---|
| 193 | exporter = StudentExporter() |
|---|
| 194 | exporter.export_all(self.app, self.outfile) |
|---|
| 195 | result = open(self.outfile, 'rb').read() |
|---|
| 196 | self.assertTrue( |
|---|
| 197 | 'adm_code,clr_code,date_of_birth,email,' |
|---|
| 198 | 'employer,firstname,flash_notice,lastname,matric_number,middlename,' |
|---|
| 199 | 'nationality,officer_comment,parents_email,' |
|---|
| 200 | 'perm_address,personal_updated,' |
|---|
| 201 | 'phone,reg_number,sex,student_id,suspended,suspended_comment,' |
|---|
| 202 | 'password,state,history,certcode,is_postgrad,' |
|---|
| 203 | 'current_level,current_session,entry_session\r\n' |
|---|
| 204 | 'my adm code,my clr code,1981-02-04#,anna@sample.com,,' |
|---|
| 205 | 'Anna,,Tester,234,M.,NG,,,"Studentroad 21\nLagos 123456\n"' |
|---|
| 206 | ',,+234-123-12345#,123,f,A111111,0,,,created' |
|---|
| 207 | in result |
|---|
| 208 | ) |
|---|
| 209 | return |
|---|
| 210 | |
|---|
| 211 | def test_export_student(self): |
|---|
| 212 | # we can export a single student |
|---|
| 213 | self.setup_student(self.student) |
|---|
| 214 | exporter = StudentExporter() |
|---|
| 215 | exporter.export_student(self.student, self.outfile) |
|---|
| 216 | result = open(self.outfile, 'rb').read() |
|---|
| 217 | self.assertTrue( |
|---|
| 218 | 'adm_code,clr_code,date_of_birth,email,' |
|---|
| 219 | 'employer,firstname,flash_notice,lastname,matric_number,middlename,' |
|---|
| 220 | 'nationality,officer_comment,parents_email,' |
|---|
| 221 | 'perm_address,personal_updated,' |
|---|
| 222 | 'phone,reg_number,sex,student_id,suspended,suspended_comment,' |
|---|
| 223 | 'password,state,history,certcode,is_postgrad,' |
|---|
| 224 | 'current_level,current_session,entry_session\r\n' |
|---|
| 225 | 'my adm code,my clr code,1981-02-04#,anna@sample.com,,' |
|---|
| 226 | 'Anna,,Tester,234,M.,NG,,,"Studentroad 21\nLagos 123456\n"' |
|---|
| 227 | ',,+234-123-12345#,123,f,A111111,0,,,created' |
|---|
| 228 | in result |
|---|
| 229 | ) |
|---|
| 230 | return |
|---|
| 231 | |
|---|
| 232 | def test_export_filtered(self): |
|---|
| 233 | # we can export a filtered set of students (filtered by session/level) |
|---|
| 234 | self.setup_student(self.student) |
|---|
| 235 | self.app['students'].addStudent(self.student) |
|---|
| 236 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 237 | exporter = StudentExporter() |
|---|
| 238 | |
|---|
| 239 | exporter.export_filtered( |
|---|
| 240 | self.app, self.outfile, |
|---|
| 241 | current_session=None, current_level=None) |
|---|
| 242 | result1 = open(self.outfile, 'rb').read() |
|---|
| 243 | exporter.export_filtered( |
|---|
| 244 | self.app, self.outfile, |
|---|
| 245 | current_session=2012, current_level=None) |
|---|
| 246 | result2 = open(self.outfile, 'rb').read() |
|---|
| 247 | # current_level and current_session can be both a string ... |
|---|
| 248 | exporter.export_filtered( |
|---|
| 249 | self.app, self.outfile, |
|---|
| 250 | current_session='2012', current_level=u'200') |
|---|
| 251 | result3 = open(self.outfile, 'rb').read() |
|---|
| 252 | exporter.export_filtered( |
|---|
| 253 | self.app, self.outfile, |
|---|
| 254 | current_session=2011, current_level=None) |
|---|
| 255 | result4 = open(self.outfile, 'rb').read() |
|---|
| 256 | # ... and an integer |
|---|
| 257 | exporter.export_filtered( |
|---|
| 258 | self.app, self.outfile, |
|---|
| 259 | current_session=None, current_level=100) |
|---|
| 260 | result5 = open(self.outfile, 'rb').read() |
|---|
| 261 | # Also students at probating levels are being exported ... |
|---|
| 262 | self.student['studycourse'].current_level = 210 |
|---|
| 263 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 264 | exporter.export_filtered( |
|---|
| 265 | self.app, self.outfile, |
|---|
| 266 | current_session=None, current_level=200) |
|---|
| 267 | result6 = open(self.outfile, 'rb').read() |
|---|
| 268 | # ... but not in the wrong level range. |
|---|
| 269 | self.student['studycourse'].current_level = 310 |
|---|
| 270 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 271 | exporter.export_filtered( |
|---|
| 272 | self.app, self.outfile, |
|---|
| 273 | current_session=None, current_level=200) |
|---|
| 274 | result7 = open(self.outfile, 'rb').read() |
|---|
| 275 | self.assertTrue(self.std_csv_entry in result1) |
|---|
| 276 | self.assertTrue(self.std_csv_entry in result2) |
|---|
| 277 | self.assertTrue(self.std_csv_entry in result3) |
|---|
| 278 | self.assertFalse(self.std_csv_entry in result4) |
|---|
| 279 | self.assertFalse(self.std_csv_entry in result5) |
|---|
| 280 | self.assertTrue(self.std_csv_entry in result6) |
|---|
| 281 | self.assertFalse(self.std_csv_entry in result7) |
|---|
| 282 | return |
|---|
| 283 | |
|---|
| 284 | def test_export_selected(self): |
|---|
| 285 | # we can export a filtered set of students (filtered by session/level) |
|---|
| 286 | self.setup_student(self.student) |
|---|
| 287 | self.app['students'].addStudent(self.student) |
|---|
| 288 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 289 | exporter = StudentExporter() |
|---|
| 290 | exporter.export_selected( |
|---|
| 291 | self.app, self.outfile, selected=['A111111']) |
|---|
| 292 | result1 = open(self.outfile, 'rb').read() |
|---|
| 293 | exporter.export_selected( |
|---|
| 294 | self.app, self.outfile, selected=[]) |
|---|
| 295 | result2 = open(self.outfile, 'rb').read() |
|---|
| 296 | self.assertTrue(self.std_csv_entry in result1) |
|---|
| 297 | self.assertFalse(self.std_csv_entry in result2) |
|---|
| 298 | return |
|---|
| 299 | |
|---|
| 300 | def test_export_filtered_by_dept(self): |
|---|
| 301 | # we can export a set of students filtered by department |
|---|
| 302 | self.setup_student(self.student) |
|---|
| 303 | self.app['students'].addStudent(self.student) |
|---|
| 304 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 305 | exporter = StudentExporter() |
|---|
| 306 | # current_session can be both a string ... |
|---|
| 307 | exporter.export_filtered( |
|---|
| 308 | self.app, self.outfile, |
|---|
| 309 | current_session='2012', current_level=u'200', depcode='NA') |
|---|
| 310 | result1 = open(self.outfile, 'rb').read() |
|---|
| 311 | # ... and an integer |
|---|
| 312 | exporter.export_filtered( |
|---|
| 313 | self.app, self.outfile, |
|---|
| 314 | current_session=2012, current_level=200, depcode='NODEPT') |
|---|
| 315 | result2 = open(self.outfile, 'rb').read() |
|---|
| 316 | self.assertTrue(self.std_csv_entry in result1) |
|---|
| 317 | self.assertTrue(self.std_csv_entry not in result2) |
|---|
| 318 | return |
|---|
| 319 | |
|---|
| 320 | def test_export_filtered_by_faculty(self): |
|---|
| 321 | # we can export a set of students filtered by faculty |
|---|
| 322 | self.setup_student(self.student) |
|---|
| 323 | self.app['students'].addStudent(self.student) |
|---|
| 324 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 325 | exporter = StudentExporter() |
|---|
| 326 | |
|---|
| 327 | exporter.export_filtered( |
|---|
| 328 | self.app, self.outfile, |
|---|
| 329 | current_session=2012, current_level='200', faccode='NA') |
|---|
| 330 | result1 = open(self.outfile, 'rb').read() |
|---|
| 331 | exporter.export_filtered( |
|---|
| 332 | self.app, self.outfile, |
|---|
| 333 | current_session=2012, current_level=200, faccode='NOFAC') |
|---|
| 334 | result2 = open(self.outfile, 'rb').read() |
|---|
| 335 | self.assertTrue(self.std_csv_entry in result1) |
|---|
| 336 | self.assertTrue(self.std_csv_entry not in result2) |
|---|
| 337 | return |
|---|
| 338 | |
|---|
| 339 | |
|---|
| 340 | |
|---|
| 341 | class StudentTrimmedDataExporterTest(StudentImportExportSetup): |
|---|
| 342 | |
|---|
| 343 | layer = FunctionalLayer |
|---|
| 344 | |
|---|
| 345 | std_csv_entry = ( |
|---|
| 346 | 'my adm code,my clr code,1981-02-04#,anna@sample.com,,' |
|---|
| 347 | 'Anna,,Tester,234,M.,NG,,,"Studentroad 21\nLagos 123456\n",,' |
|---|
| 348 | '+234-123-12345#,123,f,A111111,0,,,created' |
|---|
| 349 | ) |
|---|
| 350 | |
|---|
| 351 | def setUp(self): |
|---|
| 352 | super(StudentTrimmedDataExporterTest, self).setUp() |
|---|
| 353 | self.setup_for_export() |
|---|
| 354 | return |
|---|
| 355 | |
|---|
| 356 | def test_ifaces(self): |
|---|
| 357 | # make sure we fullfill interface contracts |
|---|
| 358 | obj = TrimmedDataExporter() |
|---|
| 359 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 360 | verifyClass(ICSVStudentExporter, TrimmedDataExporter) |
|---|
| 361 | return |
|---|
| 362 | |
|---|
| 363 | def test_get_as_utility(self): |
|---|
| 364 | # we can get an student exporter as utility |
|---|
| 365 | result = queryUtility(ICSVExporter, name="trimmed") |
|---|
| 366 | self.assertTrue(result is not None) |
|---|
| 367 | return |
|---|
| 368 | |
|---|
| 369 | def test_export_all(self): |
|---|
| 370 | # we can really export students |
|---|
| 371 | # set values we can expect in export file |
|---|
| 372 | self.setup_student(self.student) |
|---|
| 373 | exporter = TrimmedDataExporter() |
|---|
| 374 | exporter.export_all(self.app, self.outfile) |
|---|
| 375 | result = open(self.outfile, 'rb').read() |
|---|
| 376 | self.assertTrue( |
|---|
| 377 | 'student_id,matric_number,reg_number,firstname,middlename,' |
|---|
| 378 | 'lastname,sex,email,phone,nationality,date_of_birth,state,' |
|---|
| 379 | 'current_mode,certcode,faccode,depcode,current_level,' |
|---|
| 380 | 'current_session,current_verdict,entry_session\r\n' |
|---|
| 381 | 'A111111,234,123,Anna,M.,Tester,f,anna@sample.com,+234-123-12345#,' |
|---|
| 382 | 'NG,1981-02-04#,created,ug_ft,CERT1,NA,NA,200,2012,0,2010' |
|---|
| 383 | in result |
|---|
| 384 | ) |
|---|
| 385 | return |
|---|
| 386 | |
|---|
| 387 | class StudentStudyCourseExporterTest(StudentImportExportSetup): |
|---|
| 388 | |
|---|
| 389 | layer = FunctionalLayer |
|---|
| 390 | |
|---|
| 391 | def setUp(self): |
|---|
| 392 | super(StudentStudyCourseExporterTest, self).setUp() |
|---|
| 393 | self.setup_for_export() |
|---|
| 394 | return |
|---|
| 395 | |
|---|
| 396 | def test_ifaces(self): |
|---|
| 397 | # make sure we fullfill interface contracts |
|---|
| 398 | obj = StudentStudyCourseExporter() |
|---|
| 399 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 400 | verifyClass(ICSVStudentExporter, StudentStudyCourseExporter) |
|---|
| 401 | return |
|---|
| 402 | |
|---|
| 403 | def test_get_as_utility(self): |
|---|
| 404 | # we can get an student exporter as utility |
|---|
| 405 | result = queryUtility(ICSVExporter, name="studentstudycourses") |
|---|
| 406 | self.assertTrue(result is not None) |
|---|
| 407 | return |
|---|
| 408 | |
|---|
| 409 | def test_export_empty(self): |
|---|
| 410 | # we can export a nearly empty study course |
|---|
| 411 | study_course = StudentStudyCourse() |
|---|
| 412 | exporter = StudentStudyCourseExporter() |
|---|
| 413 | exporter.export([study_course], self.outfile) |
|---|
| 414 | result = open(self.outfile, 'rb').read() |
|---|
| 415 | self.assertEqual( |
|---|
| 416 | result, |
|---|
| 417 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 418 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 419 | |
|---|
| 420 | ',,,0,,,0,,0\r\n' |
|---|
| 421 | ) |
|---|
| 422 | return |
|---|
| 423 | |
|---|
| 424 | def test_export(self): |
|---|
| 425 | # we can really export study courses. |
|---|
| 426 | # set values we can expect in export file |
|---|
| 427 | self.setup_student(self.student) |
|---|
| 428 | study_course = self.student.get('studycourse') |
|---|
| 429 | exporter = StudentStudyCourseExporter() |
|---|
| 430 | exporter.export([study_course], self.outfile) |
|---|
| 431 | result = open(self.outfile, 'rb').read() |
|---|
| 432 | self.assertEqual( |
|---|
| 433 | result, |
|---|
| 434 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 435 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 436 | |
|---|
| 437 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 438 | ) |
|---|
| 439 | return |
|---|
| 440 | |
|---|
| 441 | def test_export_all(self): |
|---|
| 442 | # we can really export students |
|---|
| 443 | # set values we can expect in export file |
|---|
| 444 | self.setup_student(self.student) |
|---|
| 445 | exporter = StudentStudyCourseExporter() |
|---|
| 446 | exporter.export_all(self.app, self.outfile) |
|---|
| 447 | result = open(self.outfile, 'rb').read() |
|---|
| 448 | self.assertEqual( |
|---|
| 449 | result, |
|---|
| 450 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 451 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 452 | |
|---|
| 453 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 454 | ) |
|---|
| 455 | return |
|---|
| 456 | |
|---|
| 457 | def test_export_student(self): |
|---|
| 458 | # we can export studycourse of a certain student |
|---|
| 459 | self.setup_student(self.student) |
|---|
| 460 | exporter = StudentStudyCourseExporter() |
|---|
| 461 | exporter.export_student(self.student, self.outfile) |
|---|
| 462 | result = open(self.outfile, 'rb').read() |
|---|
| 463 | self.assertEqual( |
|---|
| 464 | result, |
|---|
| 465 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 466 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 467 | |
|---|
| 468 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 469 | ) |
|---|
| 470 | return |
|---|
| 471 | |
|---|
| 472 | def test_export_filtered(self): |
|---|
| 473 | # we can export studycourses of a filtered set of students |
|---|
| 474 | self.setup_student(self.student) |
|---|
| 475 | self.app['students'].addStudent(self.student) |
|---|
| 476 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 477 | |
|---|
| 478 | exporter = StudentStudyCourseExporter() |
|---|
| 479 | exporter.export_filtered( |
|---|
| 480 | self.student, self.outfile, current_session=2012) |
|---|
| 481 | result = open(self.outfile, 'rb').read() |
|---|
| 482 | self.assertEqual( |
|---|
| 483 | result, |
|---|
| 484 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 485 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 486 | |
|---|
| 487 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 488 | ) |
|---|
| 489 | return |
|---|
| 490 | |
|---|
| 491 | def test_export_selected_student_id(self): |
|---|
| 492 | # we can export a filtered set of students (filtered by session/level) |
|---|
| 493 | self.setup_student(self.student) |
|---|
| 494 | self.app['students'].addStudent(self.student) |
|---|
| 495 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 496 | exporter = StudentStudyCourseExporter() |
|---|
| 497 | exporter.export_selected( |
|---|
| 498 | self.app, self.outfile, selected=['A111111']) |
|---|
| 499 | result = open(self.outfile, 'rb').read() |
|---|
| 500 | self.assertEqual( |
|---|
| 501 | result, |
|---|
| 502 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 503 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 504 | |
|---|
| 505 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 506 | ) |
|---|
| 507 | return |
|---|
| 508 | |
|---|
| 509 | def test_export_selected_matric_number(self): |
|---|
| 510 | # we can export a filtered set of students (filtered by session/level) |
|---|
| 511 | self.setup_student(self.student) |
|---|
| 512 | self.app['students'].addStudent(self.student) |
|---|
| 513 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 514 | exporter = StudentStudyCourseExporter() |
|---|
| 515 | exporter.export_selected( |
|---|
| 516 | self.app, self.outfile, selected=['234']) |
|---|
| 517 | result = open(self.outfile, 'rb').read() |
|---|
| 518 | self.assertEqual( |
|---|
| 519 | result, |
|---|
| 520 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 521 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 522 | |
|---|
| 523 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 524 | ) |
|---|
| 525 | return |
|---|
| 526 | |
|---|
| 527 | def test_export_selected_pid(self): |
|---|
| 528 | # we can export a filtered set of students (filtered by session/level) |
|---|
| 529 | self.setup_student(self.student) |
|---|
| 530 | self.app['students'].addStudent(self.student) |
|---|
| 531 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 532 | exporter = StudentStudyCourseExporter() |
|---|
| 533 | exporter.export_selected( |
|---|
| 534 | self.app, self.outfile, selected=[self.payment.p_id]) |
|---|
| 535 | result = open(self.outfile, 'rb').read() |
|---|
| 536 | self.assertEqual( |
|---|
| 537 | result, |
|---|
| 538 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 539 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 540 | |
|---|
| 541 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,0\r\n' |
|---|
| 542 | ) |
|---|
| 543 | return |
|---|
| 544 | |
|---|
| 545 | class PreviousStudyCourseExporterTests(StudentImportExportSetup): |
|---|
| 546 | |
|---|
| 547 | layer = FunctionalLayer |
|---|
| 548 | |
|---|
| 549 | def setUp(self): |
|---|
| 550 | super(PreviousStudyCourseExporterTests, self).setUp() |
|---|
| 551 | self.setup_for_export() |
|---|
| 552 | self.certificate2 = createObject('waeup.Certificate') |
|---|
| 553 | self.certificate2.code = 'CERT2' |
|---|
| 554 | self.certificate2.application_category = 'basic' |
|---|
| 555 | self.certificate2.start_level = 200 |
|---|
| 556 | self.certificate2.end_level = 500 |
|---|
| 557 | self.app['faculties']['fac1']['dep1'].certificates.addCertificate( |
|---|
| 558 | self.certificate2) |
|---|
| 559 | return |
|---|
| 560 | |
|---|
| 561 | def test_export_studycourses(self): |
|---|
| 562 | self.setup_student(self.student) |
|---|
| 563 | exporter = FirstStudentStudyCourseExporter() |
|---|
| 564 | exporter.export_all(self.app, self.outfile) |
|---|
| 565 | result = open(self.outfile, 'rb').read() |
|---|
| 566 | self.assertEqual( |
|---|
| 567 | result, |
|---|
| 568 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 569 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 570 | ) |
|---|
| 571 | exporter = SecondStudentStudyCourseExporter() |
|---|
| 572 | exporter.export_all(self.app, self.outfile) |
|---|
| 573 | result = open(self.outfile, 'rb').read() |
|---|
| 574 | self.assertEqual( |
|---|
| 575 | result, |
|---|
| 576 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 577 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 578 | ) |
|---|
| 579 | |
|---|
| 580 | # First Transfer |
|---|
| 581 | error = self.student.transfer(self.certificate2, |
|---|
| 582 | current_session=2013) |
|---|
| 583 | self.assertTrue(error == None) |
|---|
| 584 | exporter = FirstStudentStudyCourseExporter() |
|---|
| 585 | exporter.export_all(self.app, self.outfile) |
|---|
| 586 | result = open(self.outfile, 'rb').read() |
|---|
| 587 | # This is the original study course |
|---|
| 588 | self.assertEqual( |
|---|
| 589 | result, |
|---|
| 590 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 591 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 592 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,1\r\n') |
|---|
| 593 | exporter = SecondStudentStudyCourseExporter() |
|---|
| 594 | exporter.export_all(self.app, self.outfile) |
|---|
| 595 | result = open(self.outfile, 'rb').read() |
|---|
| 596 | self.assertEqual( |
|---|
| 597 | result, |
|---|
| 598 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 599 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 600 | ) |
|---|
| 601 | |
|---|
| 602 | # Second transfer |
|---|
| 603 | error = self.student.transfer(self.certificate, |
|---|
| 604 | current_session=2014, |
|---|
| 605 | current_level=300) |
|---|
| 606 | self.assertTrue(error == None) |
|---|
| 607 | exporter = FirstStudentStudyCourseExporter() |
|---|
| 608 | exporter.export_all(self.app, self.outfile) |
|---|
| 609 | result = open(self.outfile, 'rb').read() |
|---|
| 610 | # This is the original study course |
|---|
| 611 | self.assertEqual( |
|---|
| 612 | result, |
|---|
| 613 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 614 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 615 | 'CERT1,200,2012,0,ug_ft,2010,0,A111111,1\r\n') |
|---|
| 616 | # This is the second study course |
|---|
| 617 | exporter = SecondStudentStudyCourseExporter() |
|---|
| 618 | exporter.export_all(self.app, self.outfile) |
|---|
| 619 | result = open(self.outfile, 'rb').read() |
|---|
| 620 | self.assertEqual( |
|---|
| 621 | result, |
|---|
| 622 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 623 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 624 | 'CERT2,,2013,,transferred,2010,,A111111,2\r\n') |
|---|
| 625 | # This is the third study course |
|---|
| 626 | exporter = StudentStudyCourseExporter() |
|---|
| 627 | exporter.export_all(self.app, self.outfile) |
|---|
| 628 | result = open(self.outfile, 'rb').read() |
|---|
| 629 | self.assertEqual( |
|---|
| 630 | result, |
|---|
| 631 | 'certificate,current_level,current_session,current_verdict,' |
|---|
| 632 | 'entry_mode,entry_session,previous_verdict,student_id,previous\r\n' |
|---|
| 633 | 'CERT1,300,2014,,transferred,2010,,A111111,0\r\n') |
|---|
| 634 | return |
|---|
| 635 | |
|---|
| 636 | def test_export_studylevels(self): |
|---|
| 637 | self.setup_student(self.student) |
|---|
| 638 | exporter = FirstStudentStudyLevelExporter() |
|---|
| 639 | exporter.export_all(self.app, self.outfile) |
|---|
| 640 | result = open(self.outfile, 'rb').read() |
|---|
| 641 | self.assertEqual( |
|---|
| 642 | result, |
|---|
| 643 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 644 | 'transcript_remark,validated_by,validation_date,student_id,' |
|---|
| 645 | 'number_of_tickets,certcode,previous\r\n' |
|---|
| 646 | ) |
|---|
| 647 | error = self.student.transfer(self.certificate2, current_session=2013) |
|---|
| 648 | self.assertTrue(error == None) |
|---|
| 649 | exporter.export_all(self.app, self.outfile) |
|---|
| 650 | result = open(self.outfile, 'rb').read() |
|---|
| 651 | self.assertEqual( |
|---|
| 652 | result, |
|---|
| 653 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 654 | 'transcript_remark,validated_by,validation_date,student_id,' |
|---|
| 655 | 'number_of_tickets,certcode,previous\r\n' |
|---|
| 656 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,1\r\n' ) |
|---|
| 657 | study_level = StudentStudyLevel() |
|---|
| 658 | study_level.level_session = 2015 |
|---|
| 659 | study_level.level_verdict = "C" |
|---|
| 660 | study_level.level = 400 |
|---|
| 661 | self.student['studycourse'].addStudentStudyLevel( |
|---|
| 662 | self.certificate2, study_level) |
|---|
| 663 | error = self.student.transfer(self.certificate, |
|---|
| 664 | current_session=2014, |
|---|
| 665 | current_level=300) |
|---|
| 666 | self.assertTrue(error == None) |
|---|
| 667 | exporter = SecondStudentStudyLevelExporter() |
|---|
| 668 | exporter.export_all(self.app, self.outfile) |
|---|
| 669 | result = open(self.outfile, 'rb').read() |
|---|
| 670 | self.assertEqual( |
|---|
| 671 | result, |
|---|
| 672 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 673 | 'transcript_remark,validated_by,validation_date,student_id,' |
|---|
| 674 | 'number_of_tickets,certcode,previous\r\n' |
|---|
| 675 | '0.00,400,2015,C,0,,,,A111111,0,CERT2,2\r\n') |
|---|
| 676 | exporter = StudentStudyLevelExporter() |
|---|
| 677 | exporter.export_all(self.app, self.outfile) |
|---|
| 678 | result = open(self.outfile, 'rb').read() |
|---|
| 679 | self.assertEqual( |
|---|
| 680 | result, |
|---|
| 681 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 682 | 'transcript_remark,validated_by,validation_date,student_id,' |
|---|
| 683 | 'number_of_tickets,certcode,previous\r\n') |
|---|
| 684 | return |
|---|
| 685 | |
|---|
| 686 | def test_export_coursetickets(self): |
|---|
| 687 | self.setup_student(self.student) |
|---|
| 688 | exporter = FirstCourseTicketExporter() |
|---|
| 689 | exporter.export_all(self.app, self.outfile) |
|---|
| 690 | result = open(self.outfile, 'rb').read() |
|---|
| 691 | self.assertEqual( |
|---|
| 692 | result, |
|---|
| 693 | 'automatic,carry_over,code,course_category,credits,dcode,' |
|---|
| 694 | 'fcode,level,level_session,mandatory,outstanding,passmark,' |
|---|
| 695 | 'score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 696 | 'display_fullname,previous\r\n' |
|---|
| 697 | ) |
|---|
| 698 | error = self.student.transfer(self.certificate2, current_session=2013) |
|---|
| 699 | self.assertTrue(error == None) |
|---|
| 700 | exporter.export_all(self.app, self.outfile) |
|---|
| 701 | result = open(self.outfile, 'rb').read() |
|---|
| 702 | self.assertEqual( |
|---|
| 703 | result, |
|---|
| 704 | 'automatic,carry_over,code,course_category,credits,dcode,' |
|---|
| 705 | 'fcode,level,level_session,mandatory,outstanding,passmark,' |
|---|
| 706 | 'score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 707 | 'display_fullname,previous\r\n' |
|---|
| 708 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,' |
|---|
| 709 | 'A111111,CERT1,Anna M. Tester,1\r\n') |
|---|
| 710 | study_level = StudentStudyLevel() |
|---|
| 711 | study_level.level_session = 2015 |
|---|
| 712 | study_level.level_verdict = "C" |
|---|
| 713 | study_level.level = 400 |
|---|
| 714 | self.student['studycourse'].addStudentStudyLevel( |
|---|
| 715 | self.certificate2, study_level) |
|---|
| 716 | ticket = CourseTicket() |
|---|
| 717 | ticket.automatic = True |
|---|
| 718 | ticket.carry_over = True |
|---|
| 719 | ticket.code = u'CRS9' |
|---|
| 720 | ticket.title = u'Course 9' |
|---|
| 721 | ticket.fcode = u'FAC9' |
|---|
| 722 | ticket.dcode = u'DEP9' |
|---|
| 723 | ticket.credits = 150 |
|---|
| 724 | ticket.passmark = 100 |
|---|
| 725 | ticket.semester = 2 |
|---|
| 726 | study_level[ticket.code] = ticket |
|---|
| 727 | error = self.student.transfer(self.certificate, |
|---|
| 728 | current_session=2014, |
|---|
| 729 | current_level=300) |
|---|
| 730 | self.assertTrue(error == None) |
|---|
| 731 | exporter = SecondCourseTicketExporter() |
|---|
| 732 | exporter.export_all(self.app, self.outfile) |
|---|
| 733 | result = open(self.outfile, 'rb').read() |
|---|
| 734 | self.assertEqual( |
|---|
| 735 | result, |
|---|
| 736 | 'automatic,carry_over,code,course_category,credits,dcode,' |
|---|
| 737 | 'fcode,level,level_session,mandatory,outstanding,passmark,' |
|---|
| 738 | 'score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 739 | 'display_fullname,previous\r\n1,1,CRS9,,150,DEP9,FAC9,400,2015,0,0,' |
|---|
| 740 | '100,,2,,Course 9,A111111,CERT2,Anna M. Tester,2\r\n') |
|---|
| 741 | exporter = CourseTicketExporter() |
|---|
| 742 | exporter.export_all(self.app, self.outfile) |
|---|
| 743 | result = open(self.outfile, 'rb').read() |
|---|
| 744 | self.assertEqual( |
|---|
| 745 | result, |
|---|
| 746 | 'automatic,carry_over,code,course_category,credits,dcode,' |
|---|
| 747 | 'fcode,level,level_session,mandatory,outstanding,passmark,' |
|---|
| 748 | 'score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 749 | 'display_fullname,previous\r\n' |
|---|
| 750 | ) |
|---|
| 751 | return |
|---|
| 752 | |
|---|
| 753 | class StudentStudyLevelExporterTest(StudentImportExportSetup): |
|---|
| 754 | |
|---|
| 755 | layer = FunctionalLayer |
|---|
| 756 | |
|---|
| 757 | def setUp(self): |
|---|
| 758 | super(StudentStudyLevelExporterTest, self).setUp() |
|---|
| 759 | self.setup_for_export() |
|---|
| 760 | return |
|---|
| 761 | |
|---|
| 762 | def test_ifaces(self): |
|---|
| 763 | # make sure we fullfill interface contracts |
|---|
| 764 | obj = StudentStudyLevelExporter() |
|---|
| 765 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 766 | verifyClass(ICSVStudentExporter, StudentStudyLevelExporter) |
|---|
| 767 | return |
|---|
| 768 | |
|---|
| 769 | def test_get_as_utility(self): |
|---|
| 770 | # we can get an student exporter as utility |
|---|
| 771 | result = queryUtility(ICSVExporter, name="studentstudylevels") |
|---|
| 772 | self.assertTrue(result is not None) |
|---|
| 773 | return |
|---|
| 774 | |
|---|
| 775 | def test_export_empty(self): |
|---|
| 776 | # we can export a nearly empty study level |
|---|
| 777 | study_level = StudentStudyLevel() |
|---|
| 778 | exporter = StudentStudyLevelExporter() |
|---|
| 779 | exporter.export([study_level], self.outfile) |
|---|
| 780 | result = open(self.outfile, 'rb').read() |
|---|
| 781 | self.assertEqual( |
|---|
| 782 | result, |
|---|
| 783 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 784 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 785 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 786 | '0.00,,,0,0,,,,,0,,0\r\n' |
|---|
| 787 | ) |
|---|
| 788 | return |
|---|
| 789 | |
|---|
| 790 | def test_export(self): |
|---|
| 791 | # we can really export study levels. |
|---|
| 792 | # set values we can expect in export file |
|---|
| 793 | self.setup_student(self.student) |
|---|
| 794 | study_course = self.student.get('studycourse') |
|---|
| 795 | study_level = study_course[study_course.keys()[0]] |
|---|
| 796 | exporter = StudentStudyLevelExporter() |
|---|
| 797 | exporter.export([study_level], self.outfile) |
|---|
| 798 | result = open(self.outfile, 'rb').read() |
|---|
| 799 | self.assertEqual( |
|---|
| 800 | result, |
|---|
| 801 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 802 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 803 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 804 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,0\r\n' |
|---|
| 805 | ) |
|---|
| 806 | return |
|---|
| 807 | |
|---|
| 808 | def test_export_all(self): |
|---|
| 809 | # we can really export study levels |
|---|
| 810 | # set values we can expect in export file |
|---|
| 811 | self.setup_student(self.student) |
|---|
| 812 | exporter = StudentStudyLevelExporter() |
|---|
| 813 | exporter.export_all(self.app, self.outfile) |
|---|
| 814 | result = open(self.outfile, 'rb').read() |
|---|
| 815 | self.assertEqual( |
|---|
| 816 | result, |
|---|
| 817 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 818 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 819 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 820 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,0\r\n' |
|---|
| 821 | ) |
|---|
| 822 | return |
|---|
| 823 | |
|---|
| 824 | def test_export_student(self): |
|---|
| 825 | # we can really export study levels of a certain student |
|---|
| 826 | self.setup_student(self.student) |
|---|
| 827 | exporter = StudentStudyLevelExporter() |
|---|
| 828 | exporter.export_student(self.student, self.outfile) |
|---|
| 829 | result = open(self.outfile, 'rb').read() |
|---|
| 830 | self.assertEqual( |
|---|
| 831 | result, |
|---|
| 832 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 833 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 834 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 835 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,0\r\n' |
|---|
| 836 | ) |
|---|
| 837 | return |
|---|
| 838 | |
|---|
| 839 | def test_export_filtered(self): |
|---|
| 840 | # we can export studylevels of a filtered set of students |
|---|
| 841 | self.setup_student(self.student) |
|---|
| 842 | self.app['students'].addStudent(self.student) |
|---|
| 843 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 844 | |
|---|
| 845 | exporter = StudentStudyLevelExporter() |
|---|
| 846 | exporter.export_filtered( |
|---|
| 847 | self.student, self.outfile) |
|---|
| 848 | result = open(self.outfile, 'rb').read() |
|---|
| 849 | self.assertEqual( |
|---|
| 850 | result, |
|---|
| 851 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 852 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 853 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 854 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,0\r\n' |
|---|
| 855 | ) |
|---|
| 856 | return |
|---|
| 857 | |
|---|
| 858 | def test_export_selected(self): |
|---|
| 859 | # we can export studylevels of a filtered set of students |
|---|
| 860 | self.setup_student(self.student) |
|---|
| 861 | self.app['students'].addStudent(self.student) |
|---|
| 862 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 863 | |
|---|
| 864 | exporter = StudentStudyLevelExporter() |
|---|
| 865 | exporter.export_selected( |
|---|
| 866 | self.app, self.outfile, selected=['A111111']) |
|---|
| 867 | result = open(self.outfile, 'rb').read() |
|---|
| 868 | self.assertEqual( |
|---|
| 869 | result, |
|---|
| 870 | 'gpa,level,level_session,level_verdict,total_credits,' |
|---|
| 871 | 'transcript_remark,validated_by,validation_date,' |
|---|
| 872 | 'student_id,number_of_tickets,certcode,previous\r\n' |
|---|
| 873 | '0.00,100,2012,A,100,,,,A111111,1,CERT1,0\r\n' |
|---|
| 874 | ) |
|---|
| 875 | return |
|---|
| 876 | |
|---|
| 877 | class CourseTicketExporterTest(StudentImportExportSetup): |
|---|
| 878 | |
|---|
| 879 | layer = FunctionalLayer |
|---|
| 880 | |
|---|
| 881 | def setUp(self): |
|---|
| 882 | super(CourseTicketExporterTest, self).setUp() |
|---|
| 883 | self.setup_for_export() |
|---|
| 884 | return |
|---|
| 885 | |
|---|
| 886 | def test_ifaces(self): |
|---|
| 887 | # make sure we fullfill interface contracts |
|---|
| 888 | obj = CourseTicketExporter() |
|---|
| 889 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 890 | verifyClass(ICSVStudentExporter, CourseTicketExporter) |
|---|
| 891 | return |
|---|
| 892 | |
|---|
| 893 | def test_get_as_utility(self): |
|---|
| 894 | # we can get an student exporter as utility |
|---|
| 895 | result = queryUtility(ICSVExporter, name="coursetickets") |
|---|
| 896 | self.assertTrue(result is not None) |
|---|
| 897 | return |
|---|
| 898 | |
|---|
| 899 | def test_export_empty(self): |
|---|
| 900 | # we can export a nearly empty course ticket |
|---|
| 901 | ticket = CourseTicket() |
|---|
| 902 | exporter = CourseTicketExporter() |
|---|
| 903 | exporter.export([ticket], self.outfile) |
|---|
| 904 | result = open(self.outfile, 'rb').read() |
|---|
| 905 | self.assertEqual( |
|---|
| 906 | result, |
|---|
| 907 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 908 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 909 | 'display_fullname,previous\r\n' |
|---|
| 910 | '0,0,,,,,,,,0,0,,,,,,,,,0\r\n' |
|---|
| 911 | ) |
|---|
| 912 | return |
|---|
| 913 | |
|---|
| 914 | def test_export(self): |
|---|
| 915 | # we can really export course tickets. |
|---|
| 916 | # set values we can expect in export file |
|---|
| 917 | self.setup_student(self.student) |
|---|
| 918 | study_course = self.student.get('studycourse') |
|---|
| 919 | study_level = study_course[study_course.keys()[0]] |
|---|
| 920 | ticket = study_level['CRS1'] |
|---|
| 921 | exporter = CourseTicketExporter() |
|---|
| 922 | exporter.export([ticket], self.outfile) |
|---|
| 923 | result = open(self.outfile, 'rb').read() |
|---|
| 924 | self.assertEqual( |
|---|
| 925 | result, |
|---|
| 926 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 927 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 928 | 'display_fullname,previous\r\n' |
|---|
| 929 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 930 | 'Anna M. Tester,0\r\n' |
|---|
| 931 | ) |
|---|
| 932 | return |
|---|
| 933 | |
|---|
| 934 | def test_export_all(self): |
|---|
| 935 | # we can really export all course tickets |
|---|
| 936 | # set values we can expect in export file |
|---|
| 937 | self.setup_student(self.student) |
|---|
| 938 | exporter = CourseTicketExporter() |
|---|
| 939 | exporter.export_all(self.app, self.outfile) |
|---|
| 940 | result = open(self.outfile, 'rb').read() |
|---|
| 941 | self.assertEqual( |
|---|
| 942 | result, |
|---|
| 943 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 944 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 945 | 'display_fullname,previous\r\n' |
|---|
| 946 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 947 | 'Anna M. Tester,0\r\n' |
|---|
| 948 | ) |
|---|
| 949 | return |
|---|
| 950 | |
|---|
| 951 | def test_export_student(self): |
|---|
| 952 | # we can really export all course tickets of a certain student |
|---|
| 953 | self.setup_student(self.student) |
|---|
| 954 | exporter = CourseTicketExporter() |
|---|
| 955 | exporter.export_student(self.student, self.outfile) |
|---|
| 956 | result = open(self.outfile, 'rb').read() |
|---|
| 957 | self.assertEqual( |
|---|
| 958 | result, |
|---|
| 959 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 960 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 961 | 'display_fullname,previous\r\n' |
|---|
| 962 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 963 | 'Anna M. Tester,0\r\n' |
|---|
| 964 | ) |
|---|
| 965 | return |
|---|
| 966 | |
|---|
| 967 | def test_export_filtered(self): |
|---|
| 968 | # we can export course tickets of a filtered set of students |
|---|
| 969 | self.setup_student(self.student) |
|---|
| 970 | self.app['students'].addStudent(self.student) |
|---|
| 971 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 972 | |
|---|
| 973 | exporter = CourseTicketExporter() |
|---|
| 974 | exporter.export_filtered(self.student, self.outfile) |
|---|
| 975 | result = open(self.outfile, 'rb').read() |
|---|
| 976 | self.assertEqual( |
|---|
| 977 | result, |
|---|
| 978 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 979 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 980 | 'display_fullname,previous\r\n' |
|---|
| 981 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 982 | 'Anna M. Tester,0\r\n' |
|---|
| 983 | ) |
|---|
| 984 | # We can set the course tickets level, semester and level_session |
|---|
| 985 | # without code (used in the datacenter) |
|---|
| 986 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 987 | exporter.export_filtered(self.student, self.outfile, ct_level='100', |
|---|
| 988 | ct_session='2012', ct_semester='2') |
|---|
| 989 | result = open(self.outfile, 'rb').read() |
|---|
| 990 | self.assertEqual( |
|---|
| 991 | result, |
|---|
| 992 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 993 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 994 | 'display_fullname,previous\r\n' |
|---|
| 995 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 996 | 'Anna M. Tester,0\r\n' |
|---|
| 997 | ) |
|---|
| 998 | # 'all' does select all |
|---|
| 999 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 1000 | exporter.export_filtered(self.student, self.outfile, ct_level='all', |
|---|
| 1001 | ct_session='2012', ct_semester='all') |
|---|
| 1002 | result = open(self.outfile, 'rb').read() |
|---|
| 1003 | self.assertEqual( |
|---|
| 1004 | result, |
|---|
| 1005 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1006 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1007 | 'display_fullname,previous\r\n' |
|---|
| 1008 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 1009 | 'Anna M. Tester,0\r\n' |
|---|
| 1010 | ) |
|---|
| 1011 | # Level 200 tickets do not exist. |
|---|
| 1012 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 1013 | exporter.export_filtered(self.student, self.outfile, ct_level='200') |
|---|
| 1014 | result = open(self.outfile, 'rb').read() |
|---|
| 1015 | self.assertEqual( |
|---|
| 1016 | result, |
|---|
| 1017 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1018 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1019 | 'display_fullname,previous\r\n' |
|---|
| 1020 | ) |
|---|
| 1021 | # Session 2013 tickets do not exist. |
|---|
| 1022 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 1023 | exporter.export_filtered(self.student, self.outfile, |
|---|
| 1024 | ct_level='all', ct_session='2013') |
|---|
| 1025 | result = open(self.outfile, 'rb').read() |
|---|
| 1026 | self.assertEqual( |
|---|
| 1027 | result, |
|---|
| 1028 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1029 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1030 | 'display_fullname,previous\r\n' |
|---|
| 1031 | ) |
|---|
| 1032 | # 1st semester tickets do not exist. |
|---|
| 1033 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 1034 | exporter.export_filtered(self.student, self.outfile, |
|---|
| 1035 | ct_level='all', ct_session='all', ct_semester='1') |
|---|
| 1036 | result = open(self.outfile, 'rb').read() |
|---|
| 1037 | self.assertEqual( |
|---|
| 1038 | result, |
|---|
| 1039 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1040 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1041 | 'display_fullname,previous\r\n' |
|---|
| 1042 | ) |
|---|
| 1043 | # If the coursetickets catalog is used to filter students |
|---|
| 1044 | # and (course) code is not None |
|---|
| 1045 | # only course tickets which belong to this course are exported |
|---|
| 1046 | exporter.export_filtered( |
|---|
| 1047 | self.student, self.outfile, catalog='coursetickets', code='CRS1') |
|---|
| 1048 | result = open(self.outfile, 'rb').read() |
|---|
| 1049 | self.assertEqual( |
|---|
| 1050 | result, |
|---|
| 1051 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1052 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1053 | 'display_fullname,previous\r\n' |
|---|
| 1054 | '1,1,CRS1,,100,DEP1,FAC1,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 1055 | 'Anna M. Tester,0\r\n' |
|---|
| 1056 | ) |
|---|
| 1057 | exporter.export_filtered( |
|---|
| 1058 | self.student, self.outfile, catalog='coursetickets', code='any code') |
|---|
| 1059 | result = open(self.outfile, 'rb').read() |
|---|
| 1060 | self.assertEqual( |
|---|
| 1061 | result, |
|---|
| 1062 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1063 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1064 | 'display_fullname,previous\r\n' |
|---|
| 1065 | ) |
|---|
| 1066 | # Also tickets in probating levels are exported. Therefore |
|---|
| 1067 | # we change the level attribute to fake a 110 level. |
|---|
| 1068 | self.student['studycourse']['100'].level = 110 |
|---|
| 1069 | notify(grok.ObjectModifiedEvent(self.student['studycourse']['100']['CRS1'])) |
|---|
| 1070 | exporter.export_filtered( |
|---|
| 1071 | self.student, self.outfile, catalog='coursetickets', code='CRS1', level='100') |
|---|
| 1072 | result = open(self.outfile, 'rb').read() |
|---|
| 1073 | self.assertEqual( |
|---|
| 1074 | result, |
|---|
| 1075 | 'automatic,carry_over,code,course_category,credits,dcode,fcode,level,level_session,' |
|---|
| 1076 | 'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,' |
|---|
| 1077 | 'display_fullname,previous\r\n' |
|---|
| 1078 | '1,1,CRS1,,100,DEP1,FAC1,110,2012,0,0,100,,2,,Course 1,A111111,CERT1,' |
|---|
| 1079 | 'Anna M. Tester,0\r\n' |
|---|
| 1080 | ) |
|---|
| 1081 | return |
|---|
| 1082 | |
|---|
| 1083 | class OutstandingCoursesExporterTest(StudentImportExportSetup): |
|---|
| 1084 | |
|---|
| 1085 | layer = FunctionalLayer |
|---|
| 1086 | |
|---|
| 1087 | def setUp(self): |
|---|
| 1088 | super(OutstandingCoursesExporterTest, self).setUp() |
|---|
| 1089 | self.setup_for_export() |
|---|
| 1090 | return |
|---|
| 1091 | |
|---|
| 1092 | def test_ifaces(self): |
|---|
| 1093 | # make sure we fullfill interface contracts |
|---|
| 1094 | obj = OutstandingCoursesExporter() |
|---|
| 1095 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1096 | verifyClass(ICSVStudentExporter, OutstandingCoursesExporter) |
|---|
| 1097 | return |
|---|
| 1098 | |
|---|
| 1099 | def test_get_as_utility(self): |
|---|
| 1100 | # we can get an student exporter as utility |
|---|
| 1101 | result = queryUtility(ICSVExporter, name="outstandingcourses") |
|---|
| 1102 | self.assertTrue(result is not None) |
|---|
| 1103 | return |
|---|
| 1104 | |
|---|
| 1105 | def test_export_all(self): |
|---|
| 1106 | course1 = Course(u'Cheese Basics', 'C1') |
|---|
| 1107 | course2 = Course(u'Advanced Cheese Making', 'C2') |
|---|
| 1108 | course3 = Course(u'Selling Cheese', 'C3') |
|---|
| 1109 | self.app['faculties']['fac1']['dep1'].courses.addCourse(course1) |
|---|
| 1110 | self.app['faculties']['fac1']['dep1'].courses.addCourse(course2) |
|---|
| 1111 | self.app['faculties']['fac1']['dep1'].courses.addCourse(course3) |
|---|
| 1112 | self.certificate.addCertCourse(course1, 100, True) |
|---|
| 1113 | self.certificate.addCertCourse(course2, 400, False) |
|---|
| 1114 | self.certificate.addCertCourse(course3, 100, False) |
|---|
| 1115 | self.setup_student(self.student) |
|---|
| 1116 | self.student['studycourse']['100']['C3'].score = 25 |
|---|
| 1117 | exporter = OutstandingCoursesExporter() |
|---|
| 1118 | exporter.export_all(self.app, self.outfile) |
|---|
| 1119 | result = open(self.outfile, 'rb').read() |
|---|
| 1120 | # The only student has registered C1, C3 and CRS1 |
|---|
| 1121 | # She missed C2, has failed C3 and did not |
|---|
| 1122 | # take C1 and CRS1 |
|---|
| 1123 | self.assertEqual( |
|---|
| 1124 | result, |
|---|
| 1125 | 'student_id,matric_number,certcode,display_fullname,missed,failed,nottaken\r\n' |
|---|
| 1126 | 'A111111,234,CERT1,Anna M. Tester,C2_400,C3,C1 CRS1\r\n' |
|---|
| 1127 | ) |
|---|
| 1128 | return |
|---|
| 1129 | |
|---|
| 1130 | class StudentPaymentExporterTest(StudentImportExportSetup): |
|---|
| 1131 | |
|---|
| 1132 | layer = FunctionalLayer |
|---|
| 1133 | |
|---|
| 1134 | def setUp(self): |
|---|
| 1135 | super(StudentPaymentExporterTest, self).setUp() |
|---|
| 1136 | self.setup_for_export() |
|---|
| 1137 | return |
|---|
| 1138 | |
|---|
| 1139 | def test_ifaces(self): |
|---|
| 1140 | # make sure we fullfill interface contracts |
|---|
| 1141 | obj = StudentPaymentExporter() |
|---|
| 1142 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1143 | verifyClass(ICSVStudentExporter, StudentPaymentExporter) |
|---|
| 1144 | return |
|---|
| 1145 | |
|---|
| 1146 | def test_get_as_utility(self): |
|---|
| 1147 | # we can get a payments exporter as utility |
|---|
| 1148 | result = queryUtility(ICSVExporter, name="studentpayments") |
|---|
| 1149 | self.assertTrue(result is not None) |
|---|
| 1150 | return |
|---|
| 1151 | |
|---|
| 1152 | def test_export_empty(self): |
|---|
| 1153 | # we can export a nearly empty payment |
|---|
| 1154 | payment = StudentOnlinePayment() |
|---|
| 1155 | payment.creation_date = datetime.datetime(2012, 4, 1, 13, 12, 1) |
|---|
| 1156 | exporter = StudentPaymentExporter() |
|---|
| 1157 | exporter.export([payment], self.outfile) |
|---|
| 1158 | result = open(self.outfile, 'rb').read() |
|---|
| 1159 | self.assertEqual( |
|---|
| 1160 | result, |
|---|
| 1161 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1162 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1163 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1164 | |
|---|
| 1165 | ',0.0,2012-04-01 13:12:01#,,[],1,,,,,unpaid,,0.0,,,,,\r\n' |
|---|
| 1166 | ) |
|---|
| 1167 | return |
|---|
| 1168 | |
|---|
| 1169 | def test_export(self): |
|---|
| 1170 | # we can really export student payments. |
|---|
| 1171 | # set values we can expect in export file |
|---|
| 1172 | self.setup_student(self.student) |
|---|
| 1173 | payment = self.student['payments']['my-payment'] |
|---|
| 1174 | exporter = StudentPaymentExporter() |
|---|
| 1175 | exporter.export([payment], self.outfile) |
|---|
| 1176 | result = open(self.outfile, 'rb').read() |
|---|
| 1177 | self.assertEqual( |
|---|
| 1178 | result, |
|---|
| 1179 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1180 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1181 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1182 | |
|---|
| 1183 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1184 | 'p-item,100,%s,paid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1185 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1186 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1187 | ) |
|---|
| 1188 | return |
|---|
| 1189 | |
|---|
| 1190 | def test_export_all(self): |
|---|
| 1191 | # we can really export all payments |
|---|
| 1192 | # set values we can expect in export file |
|---|
| 1193 | self.setup_student(self.student) |
|---|
| 1194 | exporter = StudentPaymentExporter() |
|---|
| 1195 | exporter.export_all(self.app, self.outfile) |
|---|
| 1196 | result = open(self.outfile, 'rb').read() |
|---|
| 1197 | self.assertEqual( |
|---|
| 1198 | result, |
|---|
| 1199 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1200 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1201 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1202 | |
|---|
| 1203 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1204 | 'p-item,100,%s,paid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1205 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1206 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1207 | ) |
|---|
| 1208 | return |
|---|
| 1209 | |
|---|
| 1210 | def test_export_student(self): |
|---|
| 1211 | # we can really export all payments of a certain student |
|---|
| 1212 | # set values we can expect in export file |
|---|
| 1213 | self.setup_student(self.student) |
|---|
| 1214 | exporter = StudentPaymentExporter() |
|---|
| 1215 | exporter.export_student(self.student, self.outfile) |
|---|
| 1216 | result = open(self.outfile, 'rb').read() |
|---|
| 1217 | self.assertEqual( |
|---|
| 1218 | result, |
|---|
| 1219 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1220 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1221 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1222 | |
|---|
| 1223 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1224 | 'p-item,100,%s,paid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1225 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1226 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1227 | ) |
|---|
| 1228 | return |
|---|
| 1229 | |
|---|
| 1230 | def test_export_filtered(self): |
|---|
| 1231 | # we can export payments of a filtered set of students |
|---|
| 1232 | self.setup_student(self.student) |
|---|
| 1233 | self.app['students'].addStudent(self.student) |
|---|
| 1234 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 1235 | |
|---|
| 1236 | exporter = StudentPaymentExporter() |
|---|
| 1237 | exporter.export_filtered( |
|---|
| 1238 | self.student, self.outfile, current_level=200) |
|---|
| 1239 | result = open(self.outfile, 'rb').read() |
|---|
| 1240 | self.assertEqual( |
|---|
| 1241 | result, |
|---|
| 1242 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1243 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1244 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1245 | |
|---|
| 1246 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1247 | 'p-item,100,%s,paid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1248 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1249 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1250 | ) |
|---|
| 1251 | return |
|---|
| 1252 | |
|---|
| 1253 | def test_export_filtered_by_date(self): |
|---|
| 1254 | # payments_start and payments_end are being ignored |
|---|
| 1255 | self.setup_student(self.student) |
|---|
| 1256 | self.app['students'].addStudent(self.student) |
|---|
| 1257 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 1258 | exporter = StudentPaymentExporter() |
|---|
| 1259 | # A key xxx does not exist |
|---|
| 1260 | self.assertRaises( |
|---|
| 1261 | KeyError, exporter.export_filtered, self.app, self.outfile, |
|---|
| 1262 | current_session=None, |
|---|
| 1263 | current_level=None, xxx='nonsense') |
|---|
| 1264 | # payments_start and payments_end do exist but must match format '%Y-%m-%d' |
|---|
| 1265 | self.assertRaises( |
|---|
| 1266 | ValueError, exporter.export_filtered, self.app, self.outfile, |
|---|
| 1267 | current_session=None, current_level=None, |
|---|
| 1268 | payments_start='nonsense', payments_end='nonsense') |
|---|
| 1269 | # If they match the format they are ignored by get_filtered and the |
|---|
| 1270 | # exporter works properly. |
|---|
| 1271 | # Attention: End day is included! |
|---|
| 1272 | exporter.export_filtered( |
|---|
| 1273 | self.app, self.outfile, |
|---|
| 1274 | current_session=None, current_level=None, |
|---|
| 1275 | payments_start='01/04/%s' % (curr_year-6), |
|---|
| 1276 | payments_end='01/04/%s' % (curr_year-6)) |
|---|
| 1277 | result = open(self.outfile, 'rb').read() |
|---|
| 1278 | self.assertEqual( |
|---|
| 1279 | result, |
|---|
| 1280 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1281 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1282 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1283 | |
|---|
| 1284 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1285 | 'p-item,100,%s,paid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1286 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1287 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1288 | ) |
|---|
| 1289 | # Payment date is 2012-04-01, 14:12:01. |
|---|
| 1290 | # No results if payment_date is outside the given period. |
|---|
| 1291 | exporter.export_filtered( |
|---|
| 1292 | self.app, self.outfile, |
|---|
| 1293 | current_session=None, current_level=None, |
|---|
| 1294 | payments_start='30/03/2012', payments_end='31/03/2012') |
|---|
| 1295 | result = open(self.outfile, 'rb').read() |
|---|
| 1296 | self.assertEqual( |
|---|
| 1297 | result, |
|---|
| 1298 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1299 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1300 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1301 | ) |
|---|
| 1302 | exporter.export_filtered( |
|---|
| 1303 | self.app, self.outfile, |
|---|
| 1304 | current_session=None, current_level=None, |
|---|
| 1305 | payments_start='02/04/2012', payments_end='03/04/2012') |
|---|
| 1306 | result = open(self.outfile, 'rb').read() |
|---|
| 1307 | self.assertEqual( |
|---|
| 1308 | result, |
|---|
| 1309 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1310 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1311 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1312 | ) |
|---|
| 1313 | # No results if payment_date is not set |
|---|
| 1314 | self.payment.payment_date = None |
|---|
| 1315 | exporter.export_filtered( |
|---|
| 1316 | self.app, self.outfile, |
|---|
| 1317 | current_session=None, current_level=None, |
|---|
| 1318 | payments_start='31/03/2012', payments_end='02/04/2012') |
|---|
| 1319 | result = open(self.outfile, 'rb').read() |
|---|
| 1320 | self.assertEqual( |
|---|
| 1321 | result, |
|---|
| 1322 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1323 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1324 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1325 | ) |
|---|
| 1326 | return |
|---|
| 1327 | |
|---|
| 1328 | class StudentTrimmedPaymentExporterTest(StudentImportExportSetup): |
|---|
| 1329 | |
|---|
| 1330 | layer = FunctionalLayer |
|---|
| 1331 | |
|---|
| 1332 | def setUp(self): |
|---|
| 1333 | super(StudentTrimmedPaymentExporterTest, self).setUp() |
|---|
| 1334 | self.setup_for_export() |
|---|
| 1335 | return |
|---|
| 1336 | |
|---|
| 1337 | def test_ifaces(self): |
|---|
| 1338 | # make sure we fullfill interface contracts |
|---|
| 1339 | obj = StudentTrimmedPaymentExporter() |
|---|
| 1340 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1341 | verifyClass(ICSVStudentExporter, StudentTrimmedPaymentExporter) |
|---|
| 1342 | return |
|---|
| 1343 | |
|---|
| 1344 | def test_get_as_utility(self): |
|---|
| 1345 | # we can get a payments exporter as utility |
|---|
| 1346 | result = queryUtility(ICSVExporter, name="trimmedpayments") |
|---|
| 1347 | self.assertTrue(result is not None) |
|---|
| 1348 | return |
|---|
| 1349 | |
|---|
| 1350 | def test_export_all(self): |
|---|
| 1351 | # we can really export all payments |
|---|
| 1352 | # set values we can expect in export file |
|---|
| 1353 | self.setup_student(self.student) |
|---|
| 1354 | exporter = StudentTrimmedPaymentExporter() |
|---|
| 1355 | exporter.export_all(self.app, self.outfile) |
|---|
| 1356 | result = open(self.outfile, 'rb').read() |
|---|
| 1357 | self.assertEqual( |
|---|
| 1358 | result, |
|---|
| 1359 | 'amount_auth,creation_date,p_category,p_combi,p_current,' |
|---|
| 1360 | 'p_id,p_item,p_level,p_session,p_state,payment_date,' |
|---|
| 1361 | 'r_amount_approved,r_code,r_desc,student_id,faccode,' |
|---|
| 1362 | 'depcode,state,current_session\r\n' |
|---|
| 1363 | |
|---|
| 1364 | '12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,p-item,' |
|---|
| 1365 | '100,%s,paid,%s-04-01 14:12:01#,12.12,r-code,,' |
|---|
| 1366 | 'A111111,NA,NA,created,2012\r\n' |
|---|
| 1367 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1368 | ) |
|---|
| 1369 | return |
|---|
| 1370 | |
|---|
| 1371 | |
|---|
| 1372 | class UnpaidPaymentsExporterTest(StudentImportExportSetup): |
|---|
| 1373 | |
|---|
| 1374 | layer = FunctionalLayer |
|---|
| 1375 | |
|---|
| 1376 | def setUp(self): |
|---|
| 1377 | super(UnpaidPaymentsExporterTest, self).setUp() |
|---|
| 1378 | self.setup_for_export() |
|---|
| 1379 | return |
|---|
| 1380 | |
|---|
| 1381 | def test_export_all(self): |
|---|
| 1382 | # we can really export all payments |
|---|
| 1383 | # set values we can expect in export file |
|---|
| 1384 | self.setup_student(self.student) |
|---|
| 1385 | exporter = UnpaidPaymentsExporter() |
|---|
| 1386 | exporter.export_all(self.app, self.outfile) |
|---|
| 1387 | result = open(self.outfile, 'rb').read() |
|---|
| 1388 | # No unpaid ticket exists |
|---|
| 1389 | self.assertEqual( |
|---|
| 1390 | result, |
|---|
| 1391 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1392 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1393 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1394 | ) |
|---|
| 1395 | # Make ticket unpaid |
|---|
| 1396 | self.payment.p_state = 'unpaid' |
|---|
| 1397 | exporter.export_all(self.app, self.outfile) |
|---|
| 1398 | result = open(self.outfile, 'rb').read() |
|---|
| 1399 | self.assertEqual( |
|---|
| 1400 | result, |
|---|
| 1401 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,' |
|---|
| 1402 | 'p_item,p_level,p_session,p_state,payment_date,r_amount_approved,' |
|---|
| 1403 | 'r_code,r_desc,student_id,state,current_session\r\n' |
|---|
| 1404 | |
|---|
| 1405 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,' |
|---|
| 1406 | 'p-item,100,%s,unpaid,%s-04-01 14:12:01#,12.12,' |
|---|
| 1407 | 'r-code,,A111111,created,2012\r\n' |
|---|
| 1408 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1409 | ) |
|---|
| 1410 | return |
|---|
| 1411 | |
|---|
| 1412 | class BursaryDataExporterTest(StudentImportExportSetup): |
|---|
| 1413 | |
|---|
| 1414 | layer = FunctionalLayer |
|---|
| 1415 | |
|---|
| 1416 | def setUp(self): |
|---|
| 1417 | super(BursaryDataExporterTest, self).setUp() |
|---|
| 1418 | self.setup_for_export() |
|---|
| 1419 | return |
|---|
| 1420 | |
|---|
| 1421 | def test_export_all(self): |
|---|
| 1422 | # we can really export all payments |
|---|
| 1423 | # set values we can expect in export file |
|---|
| 1424 | self.setup_student(self.student) |
|---|
| 1425 | exporter = DataForBursaryExporter() |
|---|
| 1426 | exporter.export_all(self.app, self.outfile) |
|---|
| 1427 | result = open(self.outfile, 'rb').read() |
|---|
| 1428 | self.assertEqual( |
|---|
| 1429 | result, |
|---|
| 1430 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,p_item,' |
|---|
| 1431 | 'p_level,p_session,p_state,payment_date,r_amount_approved,r_code,' |
|---|
| 1432 | 'r_desc,student_id,matric_number,reg_number,firstname,middlename,lastname,' |
|---|
| 1433 | 'sex,state,current_session,entry_session,entry_mode,faccode,depcode,certcode\r\n' |
|---|
| 1434 | |
|---|
| 1435 | '666,12.12,%s-04-01 13:12:01#,schoolfee,[],1,my-id,p-item,100,%s,' |
|---|
| 1436 | 'paid,%s-04-01 14:12:01#,12.12,r-code,,A111111,234,123,' |
|---|
| 1437 | 'Anna,M.,Tester,f,created,2012,2010,ug_ft,NA,NA,CERT1\r\n' |
|---|
| 1438 | % (curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1439 | ) |
|---|
| 1440 | return |
|---|
| 1441 | |
|---|
| 1442 | class AccommodationPaymentsExporterTest(StudentImportExportSetup): |
|---|
| 1443 | |
|---|
| 1444 | layer = FunctionalLayer |
|---|
| 1445 | |
|---|
| 1446 | def setUp(self): |
|---|
| 1447 | super(AccommodationPaymentsExporterTest, self).setUp() |
|---|
| 1448 | self.setup_for_export() |
|---|
| 1449 | return |
|---|
| 1450 | |
|---|
| 1451 | def test_export_all(self): |
|---|
| 1452 | self.setup_student(self.student) |
|---|
| 1453 | # add accommodation payments |
|---|
| 1454 | payment = StudentOnlinePayment() |
|---|
| 1455 | payment.creation_date = datetime.datetime(curr_year-6, 4, 1, 13, 12, 1) |
|---|
| 1456 | payment.p_id = 'id1' |
|---|
| 1457 | payment.p_category = u'bed_allocation' |
|---|
| 1458 | payment.p_state = 'paid' |
|---|
| 1459 | payment.ac = u'abc' |
|---|
| 1460 | payment.p_item = u'xyz' |
|---|
| 1461 | payment.p_level = 100 |
|---|
| 1462 | payment.p_session = curr_year - 6 |
|---|
| 1463 | payment.payment_date = datetime.datetime(curr_year-6, 4, 1, 14, 12, 1) |
|---|
| 1464 | payment.amount_auth = 12.12 |
|---|
| 1465 | payment.r_amount_approved = 12.12 |
|---|
| 1466 | payment.r_code = u'cde' |
|---|
| 1467 | payment2 = StudentOnlinePayment() |
|---|
| 1468 | payment2.creation_date = datetime.datetime(curr_year-6, 4, 1, 13, 12, 1) |
|---|
| 1469 | payment2.p_id = 'id2' |
|---|
| 1470 | payment2.p_category = u'hostel_maintenance' |
|---|
| 1471 | payment2.p_state = 'paid' |
|---|
| 1472 | payment2.ac = u'abc' |
|---|
| 1473 | payment2.p_item = u'xyz' |
|---|
| 1474 | payment2.p_level = 100 |
|---|
| 1475 | payment2.p_session = curr_year - 6 |
|---|
| 1476 | payment2.payment_date = datetime.datetime(curr_year-6, 4, 1, 14, 12, 1) |
|---|
| 1477 | payment2.amount_auth = 12.12 |
|---|
| 1478 | payment2.r_amount_approved = 12.12 |
|---|
| 1479 | payment2.r_code = u'cde' |
|---|
| 1480 | # XXX: there is no addPayment method to give predictable names |
|---|
| 1481 | self.payment = self.student['payments']['id1'] = payment |
|---|
| 1482 | self.payment = self.student['payments']['id2'] = payment2 |
|---|
| 1483 | exporter = AccommodationPaymentsExporter() |
|---|
| 1484 | exporter.export_all(self.app, self.outfile) |
|---|
| 1485 | result = open(self.outfile, 'rb').read() |
|---|
| 1486 | # only accommodation payments are exported |
|---|
| 1487 | self.assertEqual( |
|---|
| 1488 | result, |
|---|
| 1489 | 'ac,amount_auth,creation_date,p_category,p_combi,p_current,p_id,p_item,' |
|---|
| 1490 | 'p_level,p_session,p_state,payment_date,r_amount_approved,r_code,' |
|---|
| 1491 | 'r_desc,student_id,matric_number,reg_number,firstname,middlename,lastname,sex,' |
|---|
| 1492 | 'state,current_session,entry_session,entry_mode,faccode,depcode,certcode\r\n' |
|---|
| 1493 | 'abc,12.12,%s-04-01 13:12:01#,bed_allocation,[],1,id1,xyz,100,%s,' |
|---|
| 1494 | 'paid,%s-04-01 14:12:01#,12.12,cde,,A111111,234,123,' |
|---|
| 1495 | 'Anna,M.,Tester,f,created,2012,2010,ug_ft,NA,NA,CERT1\r\n' |
|---|
| 1496 | 'abc,12.12,%s-04-01 13:12:01#,hostel_maintenance,[],1,id2,xyz,100,%s,' |
|---|
| 1497 | 'paid,%s-04-01 14:12:01#,12.12,cde,,A111111,234,123,' |
|---|
| 1498 | 'Anna,M.,Tester,f,created,2012,2010,ug_ft,NA,NA,CERT1\r\n' |
|---|
| 1499 | % (curr_year-6, curr_year-6, curr_year-6, |
|---|
| 1500 | curr_year-6, curr_year-6, curr_year-6) |
|---|
| 1501 | ) |
|---|
| 1502 | return |
|---|
| 1503 | |
|---|
| 1504 | class BedTicketExporterTest(StudentImportExportSetup): |
|---|
| 1505 | |
|---|
| 1506 | layer = FunctionalLayer |
|---|
| 1507 | |
|---|
| 1508 | def setUp(self): |
|---|
| 1509 | super(BedTicketExporterTest, self).setUp() |
|---|
| 1510 | self.setup_for_export() |
|---|
| 1511 | return |
|---|
| 1512 | |
|---|
| 1513 | def test_ifaces(self): |
|---|
| 1514 | # make sure we fullfill interface contracts |
|---|
| 1515 | obj = BedTicketExporter() |
|---|
| 1516 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1517 | verifyClass(ICSVStudentExporter, BedTicketExporter) |
|---|
| 1518 | return |
|---|
| 1519 | |
|---|
| 1520 | def test_get_as_utility(self): |
|---|
| 1521 | # we can get a bedtickets exporter as utility |
|---|
| 1522 | result = queryUtility(ICSVExporter, name="bedtickets") |
|---|
| 1523 | self.assertTrue(result is not None) |
|---|
| 1524 | return |
|---|
| 1525 | |
|---|
| 1526 | def test_export_empty(self): |
|---|
| 1527 | # we can export a nearly empty bedticket |
|---|
| 1528 | bedticket = BedTicket() |
|---|
| 1529 | bed = self.app['hostels']['hall-1']['hall-1_A_101_A'] |
|---|
| 1530 | bedticket.bed = bed |
|---|
| 1531 | exporter = BedTicketExporter() |
|---|
| 1532 | exporter.export([bedticket], self.outfile) |
|---|
| 1533 | result = open(self.outfile, 'rb').read() |
|---|
| 1534 | self.assertMatches( |
|---|
| 1535 | result, |
|---|
| 1536 | 'bed,bed_coordinates,bed_type,booking_code,booking_date,' |
|---|
| 1537 | 'booking_session,student_id,actual_bed_type\r\n' |
|---|
| 1538 | 'hall-1_A_101_A,,,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,,,regular_male_fr\r\n' |
|---|
| 1539 | ) |
|---|
| 1540 | return |
|---|
| 1541 | |
|---|
| 1542 | def test_export(self): |
|---|
| 1543 | # we can really export student bedtickets. |
|---|
| 1544 | # set values we can expect in export file |
|---|
| 1545 | self.setup_student(self.student) |
|---|
| 1546 | bedticket = self.student['accommodation']['2004'] |
|---|
| 1547 | exporter = BedTicketExporter() |
|---|
| 1548 | exporter.export([bedticket], self.outfile) |
|---|
| 1549 | result = open(self.outfile, 'rb').read() |
|---|
| 1550 | self.assertMatches( |
|---|
| 1551 | result, |
|---|
| 1552 | 'bed,bed_coordinates,bed_type,booking_code,booking_date,' |
|---|
| 1553 | 'booking_session,student_id,actual_bed_type\r\n' |
|---|
| 1554 | 'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,' |
|---|
| 1555 | 'A111111,regular_male_fr\r\n' |
|---|
| 1556 | ) |
|---|
| 1557 | return |
|---|
| 1558 | |
|---|
| 1559 | def test_export_all(self): |
|---|
| 1560 | # we can really export all bedtickets |
|---|
| 1561 | # set values we can expect in export file |
|---|
| 1562 | self.setup_student(self.student) |
|---|
| 1563 | exporter = BedTicketExporter() |
|---|
| 1564 | exporter.export_all(self.app, self.outfile) |
|---|
| 1565 | result = open(self.outfile, 'rb').read() |
|---|
| 1566 | self.assertMatches( |
|---|
| 1567 | result, |
|---|
| 1568 | 'bed,bed_coordinates,bed_type,booking_code,booking_date,' |
|---|
| 1569 | 'booking_session,student_id,actual_bed_type\r\n' |
|---|
| 1570 | 'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,' |
|---|
| 1571 | 'A111111,regular_male_fr\r\n' |
|---|
| 1572 | ) |
|---|
| 1573 | return |
|---|
| 1574 | |
|---|
| 1575 | def test_export_student(self): |
|---|
| 1576 | # we can really export all bedtickets of a certain student |
|---|
| 1577 | # set values we can expect in export file |
|---|
| 1578 | self.setup_student(self.student) |
|---|
| 1579 | exporter = BedTicketExporter() |
|---|
| 1580 | exporter.export_student(self.student, self.outfile) |
|---|
| 1581 | result = open(self.outfile, 'rb').read() |
|---|
| 1582 | self.assertMatches( |
|---|
| 1583 | result, |
|---|
| 1584 | 'bed,bed_coordinates,bed_type,booking_code,booking_date,' |
|---|
| 1585 | 'booking_session,student_id,actual_bed_type\r\n' |
|---|
| 1586 | 'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,2004,' |
|---|
| 1587 | 'A111111,regular_male_fr\r\n' |
|---|
| 1588 | ) |
|---|
| 1589 | return |
|---|
| 1590 | |
|---|
| 1591 | def test_export_filtered(self): |
|---|
| 1592 | # we can export payments of a filtered set of students |
|---|
| 1593 | self.setup_student(self.student) |
|---|
| 1594 | self.app['students'].addStudent(self.student) |
|---|
| 1595 | notify(grok.ObjectModifiedEvent(self.student)) |
|---|
| 1596 | |
|---|
| 1597 | exporter = BedTicketExporter() |
|---|
| 1598 | exporter.export_filtered( |
|---|
| 1599 | self.student, self.outfile, current_level=200) |
|---|
| 1600 | result = open(self.outfile, 'rb').read() |
|---|
| 1601 | self.assertMatches( |
|---|
| 1602 | result, |
|---|
| 1603 | 'bed,bed_coordinates,bed_type,booking_code,booking_date,' |
|---|
| 1604 | 'booking_session,student_id,actual_bed_type\r\n' |
|---|
| 1605 | 'hall-1_A_101_A,,any bed type,,<YYYY-MM-DD hh:mm:ss>.<6-DIGITS>#,' |
|---|
| 1606 | '2004,A111111,regular_male_fr\r\n') |
|---|
| 1607 | return |
|---|
| 1608 | |
|---|
| 1609 | |
|---|
| 1610 | class SchoolFeePaymentsOverviewExporterTest(StudentImportExportSetup): |
|---|
| 1611 | |
|---|
| 1612 | layer = FunctionalLayer |
|---|
| 1613 | |
|---|
| 1614 | def setUp(self): |
|---|
| 1615 | super(SchoolFeePaymentsOverviewExporterTest, self).setUp() |
|---|
| 1616 | self.setup_for_export() |
|---|
| 1617 | return |
|---|
| 1618 | |
|---|
| 1619 | def test_ifaces(self): |
|---|
| 1620 | # make sure we fullfill interface contracts |
|---|
| 1621 | obj = SchoolFeePaymentsOverviewExporter() |
|---|
| 1622 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1623 | verifyClass(ICSVStudentExporter, SchoolFeePaymentsOverviewExporter) |
|---|
| 1624 | return |
|---|
| 1625 | |
|---|
| 1626 | def test_get_as_utility(self): |
|---|
| 1627 | # we can get a payments exporter as utility |
|---|
| 1628 | result = queryUtility(ICSVExporter, name="sfpaymentsoverview") |
|---|
| 1629 | self.assertTrue(result is not None) |
|---|
| 1630 | return |
|---|
| 1631 | |
|---|
| 1632 | def test_export(self): |
|---|
| 1633 | self.setup_student(self.student) |
|---|
| 1634 | exporter = SchoolFeePaymentsOverviewExporter() |
|---|
| 1635 | exporter.export([self.student], self.outfile) |
|---|
| 1636 | result = open(self.outfile, 'rb').read() |
|---|
| 1637 | self.assertTrue( |
|---|
| 1638 | 'student_id,matric_number,display_fullname,state,certcode,' |
|---|
| 1639 | 'faccode,depcode,is_postgrad,' |
|---|
| 1640 | 'current_level,current_session,current_mode,entry_session,' |
|---|
| 1641 | 'reg_number,%s\r\n' |
|---|
| 1642 | 'A111111,234,Anna M. Tester,created,CERT1,NA,NA,0,' |
|---|
| 1643 | '200,2012,ug_ft,2010,' |
|---|
| 1644 | % year_range_str in result |
|---|
| 1645 | ) |
|---|
| 1646 | return |
|---|
| 1647 | |
|---|
| 1648 | def test_export_all(self): |
|---|
| 1649 | # we can really export students |
|---|
| 1650 | # set values we can expect in export file |
|---|
| 1651 | self.setup_student(self.student) |
|---|
| 1652 | # We add successful payments. |
|---|
| 1653 | payment_2 = StudentOnlinePayment() |
|---|
| 1654 | payment_2.p_id = 'my-id' |
|---|
| 1655 | payment_2.p_session = curr_year - 5 |
|---|
| 1656 | payment_2.amount_auth = 13.13 |
|---|
| 1657 | payment_2.p_state = 'paid' |
|---|
| 1658 | payment_2.p_category = u'schoolfee' |
|---|
| 1659 | self.student['payments']['my-2ndpayment'] = payment_2 |
|---|
| 1660 | # This one could be a balance payment. |
|---|
| 1661 | # The amount is being added. |
|---|
| 1662 | payment_3 = StudentOnlinePayment() |
|---|
| 1663 | payment_3.p_id = 'my-id_2' |
|---|
| 1664 | payment_3.p_session = curr_year - 5 |
|---|
| 1665 | payment_3.amount_auth = 1.01 |
|---|
| 1666 | payment_3.p_state = 'paid' |
|---|
| 1667 | payment_3.p_category = u'schoolfee' |
|---|
| 1668 | self.student['payments']['my-3rdpayment'] = payment_3 |
|---|
| 1669 | # One session school fee has been waived |
|---|
| 1670 | payment_4 = StudentOnlinePayment() |
|---|
| 1671 | payment_4.p_id = 'my-id_2' |
|---|
| 1672 | payment_4.p_session = curr_year - 4 |
|---|
| 1673 | payment_4.amount_auth = 1.01 |
|---|
| 1674 | payment_4.p_state = 'waived' |
|---|
| 1675 | payment_4.p_category = u'schoolfee' |
|---|
| 1676 | self.student['payments']['my-4thpayment'] = payment_4 |
|---|
| 1677 | exporter = SchoolFeePaymentsOverviewExporter() |
|---|
| 1678 | exporter.export_all(self.app, self.outfile) |
|---|
| 1679 | result = open(self.outfile, 'rb').read() |
|---|
| 1680 | self.assertTrue( |
|---|
| 1681 | 'student_id,matric_number,display_fullname,state,' |
|---|
| 1682 | 'certcode,faccode,depcode,is_postgrad,' |
|---|
| 1683 | 'current_level,current_session,current_mode,entry_session,' |
|---|
| 1684 | 'reg_number,%s\r\nA111111,234,Anna M. Tester,created,CERT1,NA,NA,0,' |
|---|
| 1685 | '200,2012,ug_ft,2010,123,,,,,,12.12,14.14,waived,,,,\r\n' |
|---|
| 1686 | % year_range_str in result |
|---|
| 1687 | ) |
|---|
| 1688 | return |
|---|
| 1689 | |
|---|
| 1690 | class SessionPaymentsOverviewExporterTest(StudentImportExportSetup): |
|---|
| 1691 | |
|---|
| 1692 | layer = FunctionalLayer |
|---|
| 1693 | |
|---|
| 1694 | def setUp(self): |
|---|
| 1695 | super(SessionPaymentsOverviewExporterTest, self).setUp() |
|---|
| 1696 | self.setup_for_export() |
|---|
| 1697 | paycats = ('schoolfee', 'clearance', 'gown', 'transcript') |
|---|
| 1698 | paycatyears = '' |
|---|
| 1699 | grok.getSite()['configuration'].current_academic_session = curr_year - 4 |
|---|
| 1700 | year_range = range(curr_year-6, curr_year-3) |
|---|
| 1701 | year_range_tuple = tuple([str(year)[2:] for year in year_range]) |
|---|
| 1702 | for cat in paycats: |
|---|
| 1703 | for year in year_range_tuple: |
|---|
| 1704 | paycatyears += '%s,'%(cat+str(year)) |
|---|
| 1705 | self.paycatyears = paycatyears.strip(',') |
|---|
| 1706 | return |
|---|
| 1707 | |
|---|
| 1708 | def test_ifaces(self): |
|---|
| 1709 | # make sure we fullfill interface contracts |
|---|
| 1710 | obj = SessionPaymentsOverviewExporter() |
|---|
| 1711 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1712 | verifyClass(ICSVStudentExporter, SessionPaymentsOverviewExporter) |
|---|
| 1713 | return |
|---|
| 1714 | |
|---|
| 1715 | def test_get_as_utility(self): |
|---|
| 1716 | # we can get a payments exporter as utility |
|---|
| 1717 | result = queryUtility(ICSVExporter, name="sessionpaymentsoverview") |
|---|
| 1718 | self.assertTrue(result is not None) |
|---|
| 1719 | return |
|---|
| 1720 | |
|---|
| 1721 | def test_export(self): |
|---|
| 1722 | self.setup_student(self.student) |
|---|
| 1723 | exporter = SessionPaymentsOverviewExporter() |
|---|
| 1724 | exporter.export([self.student], self.outfile) |
|---|
| 1725 | result = open(self.outfile, 'rb').read() |
|---|
| 1726 | self.assertTrue( |
|---|
| 1727 | 'student_id,matric_number,display_fullname,state,certcode,' |
|---|
| 1728 | 'faccode,depcode,is_postgrad,current_level,current_session,' |
|---|
| 1729 | 'current_mode,entry_session,reg_number,%s\r\n' |
|---|
| 1730 | 'A111111,234,Anna M. Tester,created,CERT1,NA,NA,0,200,' |
|---|
| 1731 | '2012,ug_ft,2010,123,' |
|---|
| 1732 | '12.12,,,,,,,,,,,\r\n' %self.paycatyears in result |
|---|
| 1733 | ) |
|---|
| 1734 | return |
|---|
| 1735 | |
|---|
| 1736 | def test_export_all(self): |
|---|
| 1737 | self.setup_student(self.student) |
|---|
| 1738 | # We add successful payments. |
|---|
| 1739 | payment_2 = StudentOnlinePayment() |
|---|
| 1740 | payment_2.p_id = 'my-id' |
|---|
| 1741 | payment_2.p_session = curr_year - 5 |
|---|
| 1742 | payment_2.amount_auth = 13.13 |
|---|
| 1743 | payment_2.p_state = 'paid' |
|---|
| 1744 | payment_2.p_category = u'schoolfee' |
|---|
| 1745 | self.student['payments']['my-2ndpayment'] = payment_2 |
|---|
| 1746 | # This one could be a balance payment. |
|---|
| 1747 | # The amount is being added. |
|---|
| 1748 | payment_3 = StudentOnlinePayment() |
|---|
| 1749 | payment_3.p_id = 'my-id_2' |
|---|
| 1750 | payment_3.p_session = curr_year - 5 |
|---|
| 1751 | payment_3.amount_auth = 1.01 |
|---|
| 1752 | payment_3.p_state = 'paid' |
|---|
| 1753 | payment_3.p_category = u'schoolfee' |
|---|
| 1754 | self.student['payments']['my-3rdpayment'] = payment_3 |
|---|
| 1755 | # One session school fee has been waived |
|---|
| 1756 | payment_4 = StudentOnlinePayment() |
|---|
| 1757 | payment_4.p_id = 'my-id_2' |
|---|
| 1758 | payment_4.p_session = curr_year - 4 |
|---|
| 1759 | payment_4.amount_auth = 1.01 |
|---|
| 1760 | payment_4.p_state = 'waived' |
|---|
| 1761 | payment_4.p_category = u'schoolfee' |
|---|
| 1762 | self.student['payments']['my-4thpayment'] = payment_4 |
|---|
| 1763 | exporter = SessionPaymentsOverviewExporter() |
|---|
| 1764 | exporter.export_all(self.app, self.outfile) |
|---|
| 1765 | result = open(self.outfile, 'rb').read() |
|---|
| 1766 | self.assertTrue( |
|---|
| 1767 | 'student_id,matric_number,display_fullname,state,certcode,faccode,' |
|---|
| 1768 | 'depcode,is_postgrad,current_level,current_session,' |
|---|
| 1769 | 'current_mode,entry_session,reg_number,%s\r\n' |
|---|
| 1770 | 'A111111,234,Anna M. Tester,created,CERT1,NA,NA,0,200,2012,ug_ft,' |
|---|
| 1771 | '2010,123,' |
|---|
| 1772 | '12.12,14.14,1.01,,,,,,,,,\r\n' |
|---|
| 1773 | %self.paycatyears in result |
|---|
| 1774 | ) |
|---|
| 1775 | return |
|---|
| 1776 | |
|---|
| 1777 | class StudyLevelsOverviewExporterTest(StudentImportExportSetup): |
|---|
| 1778 | |
|---|
| 1779 | layer = FunctionalLayer |
|---|
| 1780 | |
|---|
| 1781 | def setUp(self): |
|---|
| 1782 | super(StudyLevelsOverviewExporterTest, self).setUp() |
|---|
| 1783 | self.setup_for_export() |
|---|
| 1784 | return |
|---|
| 1785 | |
|---|
| 1786 | def test_ifaces(self): |
|---|
| 1787 | obj = StudyLevelsOverviewExporter() |
|---|
| 1788 | verifyObject(ICSVStudentExporter, obj) |
|---|
| 1789 | verifyClass(ICSVStudentExporter, StudyLevelsOverviewExporter) |
|---|
| 1790 | return |
|---|
| 1791 | |
|---|
| 1792 | def test_get_as_utility(self): |
|---|
| 1793 | result = queryUtility(ICSVExporter, name="studylevelsoverview") |
|---|
| 1794 | self.assertTrue(result is not None) |
|---|
| 1795 | return |
|---|
| 1796 | |
|---|
| 1797 | def test_export(self): |
|---|
| 1798 | self.setup_student(self.student) |
|---|
| 1799 | exporter = StudyLevelsOverviewExporter() |
|---|
| 1800 | exporter.export([self.student], self.outfile) |
|---|
| 1801 | result = open(self.outfile, 'rb').read() |
|---|
| 1802 | self.assertEqual( |
|---|
| 1803 | 'student_id,state,certcode,faccode,depcode,is_postgrad,' |
|---|
| 1804 | 'entry_session,current_level,current_session,' |
|---|
| 1805 | '0,10,100,110,120,200,210,220,300,310,320,400,410,420,500,' |
|---|
| 1806 | '510,520,600,610,620,700,710,720,800,810,820,900,910,920,999,1000\r\n' |
|---|
| 1807 | 'A111111,created,CERT1,NA,NA,0,2010,200,2012,,,2012' |
|---|
| 1808 | ',,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n', |
|---|
| 1809 | result |
|---|
| 1810 | ) |
|---|
| 1811 | return |
|---|
| 1812 | |
|---|
| 1813 | def test_export_all(self): |
|---|
| 1814 | self.setup_student(self.student) |
|---|
| 1815 | exporter = StudyLevelsOverviewExporter() |
|---|
| 1816 | exporter.export_all(self.app, self.outfile) |
|---|
| 1817 | result = open(self.outfile, 'rb').read() |
|---|
| 1818 | self.assertEqual( |
|---|
| 1819 | 'student_id,state,certcode,faccode,depcode,is_postgrad,' |
|---|
| 1820 | 'entry_session,current_level,current_session,' |
|---|
| 1821 | '0,10,100,110,120,200,210,220,300,310,320,400,410,420,500,' |
|---|
| 1822 | '510,520,600,610,620,700,710,720,800,810,820,900,910,920,999,1000\r\n' |
|---|
| 1823 | 'A111111,created,CERT1,NA,NA,0,2010,200,2012,,,2012' |
|---|
| 1824 | ',,,,,,,,,,,,,,,,,,,,,,,,,,,,\r\n', |
|---|
| 1825 | result |
|---|
| 1826 | ) |
|---|
| 1827 | return |
|---|
| 1828 | |
|---|
| 1829 | class ComboCardExporterTest(StudentImportExportSetup): |
|---|
| 1830 | |
|---|
| 1831 | layer = FunctionalLayer |
|---|
| 1832 | |
|---|
| 1833 | def setUp(self): |
|---|
| 1834 | super(ComboCardExporterTest, self).setUp() |
|---|
| 1835 | self.setup_for_export() |
|---|
| 1836 | return |
|---|
| 1837 | |
|---|
| 1838 | def create_passport_img(self, student): |
|---|
| 1839 | # create some passport file for `student` |
|---|
| 1840 | storage = getUtility(IExtFileStore) |
|---|
| 1841 | image_path = os.path.join(os.path.dirname(__file__), 'test_image.jpg') |
|---|
| 1842 | self.image_contents = open(image_path, 'rb').read() |
|---|
| 1843 | file_id = IFileStoreNameChooser(student).chooseName( |
|---|
| 1844 | attr='passport.jpg') |
|---|
| 1845 | storage.createFile(file_id, StringIO(self.image_contents)) |
|---|
| 1846 | |
|---|
| 1847 | def test_export_all(self): |
|---|
| 1848 | self.setup_student(self.student) |
|---|
| 1849 | self.create_passport_img(self.student) |
|---|
| 1850 | exporter = ComboCardDataExporter() |
|---|
| 1851 | exporter.export_all(self.app, self.outfile) |
|---|
| 1852 | result = open(self.outfile, 'rb').read() |
|---|
| 1853 | self.assertTrue( |
|---|
| 1854 | 'display_fullname,student_id,matric_number,certificate,faculty,' |
|---|
| 1855 | 'department,passport_path\r\nAnna M. Tester,A111111,234,' |
|---|
| 1856 | 'Unnamed Certificate,Faculty of Unnamed Faculty (NA),' |
|---|
| 1857 | 'Department of Unnamed Department (NA),' |
|---|
| 1858 | 'students/00110/A111111/passport_A111111.jpg\r\n' |
|---|
| 1859 | in result |
|---|
| 1860 | ) |
|---|
| 1861 | return |
|---|
| 1862 | |
|---|
| 1863 | class TranscriptDataExporterTest(StudentImportExportSetup): |
|---|
| 1864 | |
|---|
| 1865 | layer = FunctionalLayer |
|---|
| 1866 | |
|---|
| 1867 | def setUp(self): |
|---|
| 1868 | super(TranscriptDataExporterTest, self).setUp() |
|---|
| 1869 | self.setup_for_export() |
|---|
| 1870 | return |
|---|
| 1871 | |
|---|
| 1872 | def test_export_all(self): |
|---|
| 1873 | self.setup_student(self.student) |
|---|
| 1874 | study_course = self.student.get('studycourse') |
|---|
| 1875 | study_level = study_course[study_course.keys()[0]] |
|---|
| 1876 | ticket = study_level['CRS1'] |
|---|
| 1877 | ticket.score = 20 |
|---|
| 1878 | exporter = TranscriptDataExporter() |
|---|
| 1879 | exporter.export_all(self.app, self.outfile) |
|---|
| 1880 | result = open(self.outfile, 'rb').read() |
|---|
| 1881 | self.assertTrue( |
|---|
| 1882 | 'student_id,state,certcode,faccode,depcode,entry_session,' |
|---|
| 1883 | 'current_level,current_session,transcript_data\r\n' |
|---|
| 1884 | 'A111111,created,CERT1,NA,NA,2010,200,2012,' |
|---|
| 1885 | 'Level 100; 1st: ; 2nd: CRS1; 3rd: ; sgpa: 0.0\r\n' |
|---|
| 1886 | in result |
|---|
| 1887 | ) |
|---|
| 1888 | return |
|---|
