source: main/waeup.aaue/trunk/src/waeup/aaue/students/tests/test_export.py @ 17540

import datetime
from zope.component import queryUtility
from zope.interface.verify import verifyObject, verifyClass
from waeup.kofa.interfaces import ICSVExporter
from waeup.kofa.schoolgrades import ResultEntry
from waeup.kofa.students.tests.test_batching import (
    StudentImportExportSetup, curr_year)
from waeup.aaue.utils.utils import CustomKofaUtils
from waeup.aaue.students.export import (
    CustomStudentExporter, CustomStudentPaymentExporter,
    CustomStudentStudyLevelExporter,
    CustomCourseTicketExporter,
    LevelReportDataExporter,
    CustomStudentStudyCourseExporter,
    OutstandingCourses2Exporter)
from waeup.aaue.testing import FunctionalLayer


class CustomStudentExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(CustomStudentExporterTest, self).setUp()
        self.setup_for_export()
        result_entry = ResultEntry(
            CustomKofaUtils.EXAM_SUBJECTS_DICT.keys()[0],
            CustomKofaUtils.EXAM_GRADES[0][0]
            )
        self.student.alr_results = [
            result_entry]
        self.student.fst_sit_results = [
            result_entry]
        self.student.scd_sit_results = [
            result_entry]
        return

    def test_ifaces(self):
        # make sure we fullfill interface contracts
        obj = CustomStudentExporter()
        verifyObject(ICSVExporter, obj)
        verifyClass(ICSVExporter, CustomStudentExporter)
        return


    def disabled_test_export_all(self):
        # we can really export students
        # set values we can expect in export file
        self.setup_student(self.student)
        exporter = CustomStudentExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertMatches(
            'adm_code,alr_date,alr_fname,alr_no,alr_results,'
            'application_number,clr_code,'
            'date_of_birth,def_adm,disabled,email,emp2_end,emp2_position,'
            'emp2_reason,emp2_start,emp_end,emp_position,emp_reason,'
            'emp_start,employer,employer2,father_address,father_name,'
            'father_phone,father_work,'
            'financial_clearance_date,financially_cleared_by,'
            'firstname,flash_notice,former_matric,fst_sit_date,'
            'fst_sit_fname,fst_sit_no,fst_sit_results,fst_sit_type,hq2_degree,'
            'hq2_disc,hq2_matric_no,hq2_school,hq2_session,hq2_type,'
            'hq_degree,hq_disc,hq_fname,hq_matric_no,hq_school,hq_session,'
            'hq_type,is_staff,lastname,lga,marit_stat,matric_number,'
            'middlename,mother_address,mother_name,mother_phone,'
            'mother_work,nationality,next_kin_address,next_kin_name,'
            'next_kin_phone,next_kin_relation,nysc_lga,nysc_location,'
            'nysc_year,officer_comment,perm_address,personal_updated,'
            'phone,phone_personal,physical_clearance_date,reg_number,'
            'religion,sc_pin,sc_serial_number,scd_sit_date,'
            'scd_sit_fname,scd_sit_no,scd_sit_results,'
            'scd_sit_type,sex,student_id,suspended,suspended_comment,password,'
            'state,history,certcode,is_postgrad,current_level,current_session'
            '\r\n'
            'my adm code,,,,"[(\'printing_craft_practice\', \'A1\')]",,'
            'my clr code,1981-02-04#,,,anna@sample.com,,,,,,,,,,,,,,,,,Anna,,,,,,'
            '"[(\'printing_craft_practice\', \'A1\')]",,,,,,,,,,,,,,,,Tester,,,'
            '234,M.,,,,,NG,,,,,,,,,"Studentroad 21\nLagos 123456\n",,'
            '+234-123-12345#,,,123,,,,,,,'
            '"[(\'printing_craft_practice\', \'A1\')]",,f,A111111,0,,,'
            'created,[u\'2015-10-26 17:45:56 WAT - Record created by system\'],'
            'CERT1,0,200,2012\r\n',
            result
            )
        return

class CustomStudentPaymentExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(CustomStudentPaymentExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_ifaces(self):
        # make sure we fullfill interface contracts
        obj = CustomStudentPaymentExporter()
        verifyObject(ICSVExporter, obj)
        verifyClass(ICSVExporter, CustomStudentPaymentExporter)
        return

    def test_export_all(self):
        # we can really export students
        # set values we can expect in export file
        self.setup_student(self.student)
        self.student['payments']['my-payment'].r_company = 'interswatch'
        self.student['payments']['my-payment'].r_card_num = '789'
        exporter = CustomStudentPaymentExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertMatches(
            'ac,amount_auth,creation_date,gateway_amt,net_amt,p_category,p_combi,p_currency,p_current,'
            'p_id,p_item,p_level,p_option,p_session,p_split_data,p_state,payment_date,provider_amt,'
            'r_amount_approved,r_card_num,r_code,r_company,r_desc,'
            'r_pay_reference,r_payment_link,thirdparty_amt,student_id,state,'
            'current_session\r\n'
            '666,12.12,%s-04-01 13:12:01#,,,schoolfee,[],,1,my-id,p-item,'
            '100,,%s,,paid,%s-04-01 14:12:01#,,12.12,'
            '789,r-code,interswatch,,,,,A111111,created,2012\r\n'
            % (curr_year-6, curr_year-6, curr_year-6), result
            )
        return

class CustomStudentStudyCourseExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(CustomStudentStudyCourseExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_export_all(self):
        self.setup_student(self.student)
        exporter = CustomStudentStudyCourseExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertEqual(
            result,
            'certificate,current_level,current_session,current_verdict,'
            'entry_mode,entry_session,imported_cgpa,previous_verdict,'
            'matric_number,state,student_id\r\n'
            'CERT1,200,2012,0,ug_ft,2010,,0,234,created,A111111\r\n'
            )
        return


class CustomStudentStudyLevelExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(CustomStudentStudyLevelExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_export_all(self):
        # we can really export study levels
        # set values we can expect in export file
        self.setup_student(self.student)
        exporter = CustomStudentStudyLevelExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertEqual(
            result,
            'gpa,imported_cgpa,imported_gpa,'
            'level,level_session,level_verdict,total_credits,'
            'total_credits_s1,total_credits_s2,transcript_remark,'
            'validated_by,validation_date,'
            'student_id,matric_number,number_of_tickets,certcode,cgpa\r\n'
            '0.00,,,100,2012,A,100,,,,,,A111111,234,1,CERT1,0.0\r\n'
            )
        return

class CustomCourseTicketExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(CustomCourseTicketExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_export_all(self):
        # we can really export all course tickets
        # set values we can expect in export file
        self.setup_student(self.student)
        exporter = CustomCourseTicketExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertEqual(
            result,
            'automatic,ca,carry_over,code,course_category,credits,dcode,fcode,imported_ts,level,level_session,'
            'mandatory,outstanding,passmark,score,semester,ticket_session,title,student_id,certcode,'
            'display_fullname,matric_number,state,grade,total_score,total_credits,previous\r\n'
            '1,,1,CRS1,,100,DEP1,FAC1,,100,2012,0,0,100,,2,,Course 1,A111111,CERT1,'
            '"TESTER, Anna M.",234,created,,,100,0\r\n'
            )
        return

class LevelReportDataExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(LevelReportDataExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_export_all(self):
        # we can really export study levels
        # set values we can expect in export file
        self.setup_student(self.student)
        exporter = LevelReportDataExporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertEqual(
            result,
            'matric_number,display_fullname,level,level_session,'
            'credits_counted,credits_passed,'
            'level_gpa,failed_courses,not_taken_courses,cum_credits_taken,'
            'cum_credits_passed,cgpa,remark\r\n'
            '234,"TESTER, Anna M.",100,2012,0,0,0.000,,CRS1 ,0,0,0.000,\r\n'
            )
        return

class OutstandingCourses2ExporterTest(StudentImportExportSetup):

    layer = FunctionalLayer

    def setUp(self):
        super(OutstandingCourses2ExporterTest, self).setUp()
        self.setup_for_export()
        return

    def test_export_all(self):
        # we can really export all course tickets
        # set values we can expect in export file
        self.setup_student(self.student)
        self.student['studycourse']['100']['CRS1'].course_category = 'C'
        exporter = OutstandingCourses2Exporter()
        exporter.export_all(self.app, self.outfile)
        result = open(self.outfile, 'rb').read()
        self.assertEqual(
            result,
            'student_id,matric_number,certcode,display_fullname,code,'
            'course_category,remark\r\n'
            'A111111,234,CERT1,"TESTER, Anna M.",CRS1,C,nottaken\r\n'
            )
        return