def __make_test_grad(self): gs = self.gs sem = Semester.current() # put some data there so there's something to see in the tests (also, the empty <tbody>s don't validate) req = GradRequirement(program=gs.program, description="Some Requirement") req.save() st = ScholarshipType(unit=gs.program.unit, name="Some Scholarship") st.save() Supervisor(student=gs, supervisor=Person.objects.get(userid='ggbaker'), supervisor_type='SEN').save() GradProgramHistory(student=gs, program=gs.program, start_semester=Semester.current()).save() GradStatus(student=gs, status='ACTI', start=sem).save() CompletedRequirement(student=gs, requirement=req, semester=sem).save() Scholarship(student=gs, scholarship_type=st, amount=1000, start_semester=sem, end_semester=sem).save() OtherFunding(student=gs, amount=100, semester=sem, description="Some Other Funding", comments="Other Funding\n\nComment").save() Promise(student=gs, amount=10000, start_semester=sem, end_semester=sem.next_semester()).save() FinancialComment(student=gs, semester=sem, comment_type='SCO', comment='Some comment.\nMore.', created_by='ggbaker').save() Supervisor(student=gs, supervisor=Person.objects.get(userid='ggbaker'), supervisor_type='SEN').save() return gs
def import_student( emplid, gradprogram, semester_string, dryrun=True ): """ Import student with emplid into gradprogram, using as much SIMS data as possible. """ person = find_or_generate_person(emplid) program = gradprogram print(person, program) english_fluency = "" mother_tongue = get_mother_tongue( emplid ) print(mother_tongue) passport_issued_by = get_passport_issued_by( emplid ) print(passport_issued_by) if passport_issued_by == "Canada": is_canadian = True elif holds_resident_visa( emplid ): is_canadian = True else: is_canadian = False print("Canadian: ", is_canadian) research_area = get_research_area( emplid, program.unit.acad_org ) print(research_area) grad = GradStudent( person=person, program=program, english_fluency=english_fluency, mother_tongue=mother_tongue, is_canadian=is_canadian, research_area=research_area, passport_issued_by=passport_issued_by, comments="" ) grad.config['imported_from'] = "MSE special import " + str(datetime.date.today()) email = get_email(emplid) if email: grad.config['applic_email'] = email print("Creating new Grad Student") print(grad) if not dryrun: grad.save() # Personal data personal_info = coredata.queries.grad_student_info(emplid) print(personal_info) if 'visa' in personal_info: person.config['visa'] = personal_info['visa'] if 'citizen' in personal_info: person.config['citizen'] = personal_info['citizen'] if 'ccredits' in personal_info: person.config['ccredits'] = personal_info['ccredits'] if 'gpa' in personal_info: person.config['gpa'] = personal_info['gpa'] if 'gender' in personal_info: person.config['gender'] = personal_info['gender'] try: semester_object = Semester.objects.get(name=semester_string) except Semester.DoesNotExist: print("Semester " + name + " does not exist") return # GradProgramHistory history = GradProgramHistory( student=grad, program=program, start_semester=semester_object, starting=semester_object.start ) print(history) status = GradStatus(student=grad, status='ACTI', start=semester_object) print(status) # Save all of the actual data. if not dryrun: person.save() history.save() status.save() print("------------------")
def import_student(emplid, gradprogram, semester_string, dryrun=True): """ Import student with emplid into gradprogram, using as much SIMS data as possible. """ person = find_or_generate_person(emplid) program = gradprogram print person, program english_fluency = "" mother_tongue = get_mother_tongue(emplid) print mother_tongue passport_issued_by = get_passport_issued_by(emplid) print passport_issued_by if passport_issued_by == "Canada": is_canadian = True elif holds_resident_visa(emplid): is_canadian = True else: is_canadian = False print "Canadian: ", is_canadian research_area = get_research_area(emplid, program.unit.acad_org) print research_area grad = GradStudent(person=person, program=program, english_fluency=english_fluency, mother_tongue=mother_tongue, is_canadian=is_canadian, research_area=research_area, passport_issued_by=passport_issued_by, comments="") grad.config['imported_from'] = "MSE special import " + str( datetime.date.today()) email = get_email(emplid) if email: grad.config['applic_email'] = email print "Creating new Grad Student" print grad if not dryrun: grad.save() # Personal data personal_info = coredata.queries.grad_student_info(emplid) print personal_info if 'visa' in personal_info: person.config['visa'] = personal_info['visa'] if 'citizen' in personal_info: person.config['citizen'] = personal_info['citizen'] if 'ccredits' in personal_info: person.config['ccredits'] = personal_info['ccredits'] if 'gpa' in personal_info: person.config['gpa'] = personal_info['gpa'] if 'gender' in personal_info: person.config['gender'] = personal_info['gender'] try: semester_object = Semester.objects.get(name=semester_string) except Semester.DoesNotExist: print "Semester " + name + " does not exist" return # GradProgramHistory history = GradProgramHistory(student=grad, program=program, start_semester=semester_object, starting=semester_object.start) print history status = GradStatus(student=grad, status='ACTI', start=semester_object) print status # Save all of the actual data. if not dryrun: person.save() history.save() status.save() print "------------------"
def create_grad(): """ Test data for grad, ta, ra """ from grad.models import GradProgram, GradStudent, GradProgramHistory, GradStatus, ScholarshipType, Scholarship, \ OtherFunding, Promise, GradRequirement, CompletedRequirement, LetterTemplate, GradFlag, GradFlagValue, Supervisor cmpt = Unit.objects.get(slug='cmpt') ensc = Unit.objects.get(slug='ensc') mse = Unit.objects.get(slug='mse') # some admin roles d = Person.objects.get(userid='dzhao') r1 = Role(person=d, role='GRAD', unit=cmpt, expiry=role_expiry) r1.save() r2 = Role(person=Person.objects.get(userid='popowich'), role="GRPD", unit=cmpt, expiry=role_expiry) r2.save() roles = [r1, r2] # departmental data st1 = ScholarshipType(unit=cmpt, name='Scholarship-o-rama', eligible=False) st1.save() st2 = ScholarshipType(unit=cmpt, name='Generic Scholarship #8', eligible=True) st2.save() scholarship_types = [st1, st2] templates = [ { "unit": cmpt, "label": "offer", "content": u"Congratulations, {{first_name}}, we would like to offer you admission to the {{program}} program in Computing Science at SFU.\r\n\r\nThis is gööd news. Really." }, { "unit": cmpt, "label": "visa", "content": "This is to confirm that {{title}} {{first_name}} {{last_name}} is currently enrolled as a full time student in the {{program}} in the School of Computing Science at SFU." }, { "unit": cmpt, "label": "Funding", "content": "This is to confirm that {{title}} {{first_name}} {{last_name}} is a student in the School of Computing Science's {{program}} program. {{He_She}} has been employed as follows:\r\n\r\n{% if tafunding %}Teaching assistant responsibilities include providing tutorials, office hours and marking assignments. {{title}} {{last_name}}'s assignments have been:\r\n\r\n{{ tafunding }}{% endif %}\r\n{% if rafunding %}Research assistants assist/provide research services to faculty. {{title}} {{last_name}}'s assignments have been:\r\n\r\n{{ rafunding }}{% endif %}\r\n{% if scholarships %}{{title}} {{last_name}} has received the following scholarships:\r\n\r\n{{ scholarships }}{% endif %}\r\n\r\n{{title}} {{last_name}} is making satisfactory progress." }, ] for data in templates: t = LetterTemplate(**data) t.save() p = GradProgram(unit=cmpt, label='MSc Course', description='MSc Course option') p.save() p = GradProgram(unit=cmpt, label='MSc Proj', description='MSc Project option') p.save() p = GradProgram(unit=cmpt, label='MSc Thesis', description='MSc Thesis option') p.save() p = GradProgram(unit=cmpt, label='PhD', description='Doctor of Philosophy') p.save() p = GradProgram(unit=cmpt, label='Qualifying', description='Qualifying student') p.save() p = GradProgram(unit=cmpt, label='Special', description='Special Arrangements') p.save() gr = GradRequirement(program=p, description='Achieved Speciality') gr.save() for p in GradProgram.objects.filter(unit=cmpt): gr = GradRequirement(program=p, description='Found campus') gr.save() gf = GradFlag(unit=cmpt, label='Dual Degree Program') gf.save() gf = GradFlag(unit=cmpt, label='Co-op') gf.save() grads = list(Person.objects.filter(last_name='Grad')) programs = list(GradProgram.objects.all()) today = datetime.date.today() starts = Semester.objects.filter(start__gt=today - datetime.timedelta(1000), start__lt=today) supervisors = list( set([ m.person for m in Member.objects.filter( role='INST').select_related('person') ])) # create GradStudents (and associated data) in a vaguely realistic way for g in grads + random.sample(grads, 5): # put a few in two programs p = random.choice(programs) start = random.choice(starts) sstart = start.start if random.randint(1, 2) == 1: end = start.offset(random.randint(3, 9)) else: end = None gs = GradStudent(person=g, program=p, research_area=randname(8) + 'ology', campus=random.choice([x for x, _ in CAMPUS_CHOICES]), is_canadian=randnullbool()) gs.save() gph = GradProgramHistory(student=gs, program=p, start_semester=start) gph.save() if random.randint(1, 3) == 1: p2 = random.choice( [p2 for p2 in programs if p != p2 and p.unit == p2.unit]) gph = GradProgramHistory(student=gs, program=p2, start_semester=start.offset( random.randint(1, 4))) gph.save() s = GradStatus(student=gs, status='COMP', start=start, start_date=sstart - datetime.timedelta(days=100)) s.save() if random.randint(1, 4) == 1: s = GradStatus(student=gs, status='REJE', start=start, start_date=sstart - datetime.timedelta(days=80)) s.save() else: s = GradStatus(student=gs, status='OFFO', start=start, start_date=sstart - datetime.timedelta(days=80)) s.save() s = GradStatus(student=gs, status='ACTI', start=start, start_date=sstart) s.save() if end: if random.randint(1, 3): s = GradStatus(student=gs, status='WIDR', start=end, start_date=end.start) s.save() else: s = GradStatus(student=gs, status='GRAD', start=end, start_date=end.start) s.save() gs.update_status_fields() # give some money sch = Scholarship(student=gs, scholarship_type=random.choice(scholarship_types)) sch.amount = 2000 sch.start_semester = start sch.end_semester = start.offset(2) sch.save() of = OtherFunding(student=gs, semester=start.offset(3)) of.amount = 1300 of.description = "Money fell from the sky" of.save() # promise p = Promise(student=gs, start_semester=start, end_semester=start.offset(2), amount=10000) p.save() p = Promise(student=gs, start_semester=start.offset(3), end_semester=start.offset(5), amount=10000) p.save() # flags if random.randint(1, 3) == 1: cr = CompletedRequirement(requirement=gr, student=gs, semester=start.offset(1)) cr.save() if random.randint(1, 4) == 1: gfv = GradFlagValue(flag=gf, student=gs, value=True) gfv.save() # supervisors if random.randint(1, 3) != 1: p = random.choice(supervisors) s = Supervisor(student=gs, supervisor=p, supervisor_type='POT') s.save() if random.randint(1, 2) == 1: s = Supervisor(student=gs, supervisor=p, supervisor_type='SEN') s.save() s = Supervisor(student=gs, supervisor=random.choice(supervisors), supervisor_type='COM') s.save() return itertools.chain( roles, programs, scholarship_types, GradRequirement.objects.all(), LetterTemplate.objects.all(), GradFlag.objects.all(), GradStudent.objects.all(), GradProgramHistory.objects.all(), GradStatus.objects.all(), Scholarship.objects.all(), OtherFunding.objects.all(), Promise.objects.all(), CompletedRequirement.objects.all(), GradFlagValue.objects.all(), Supervisor.objects.all(), )
def create_grad(): """ Test data for grad, ta, ra """ from grad.models import GradProgram, GradStudent, GradProgramHistory, GradStatus, ScholarshipType, Scholarship, \ OtherFunding, Promise, GradRequirement, CompletedRequirement, LetterTemplate, GradFlag, GradFlagValue, Supervisor cmpt = Unit.objects.get(slug='cmpt') ensc = Unit.objects.get(slug='ensc') mse = Unit.objects.get(slug='mse') # some admin roles d = Person.objects.get(userid='dzhao') r1 = Role(person=d, role='GRAD', unit=cmpt) r1.save() r2 = Role(person=Person.objects.get(userid='popowich'), role="GRPD", unit=cmpt) r2.save() roles = [r1, r2] # departmental data st1 = ScholarshipType(unit=cmpt, name='Scholarship-o-rama', eligible=False) st1.save() st2 = ScholarshipType(unit=cmpt, name='Generic Scholarship #8', eligible=True) st2.save() scholarship_types = [st1, st2] templates = [ {"unit": cmpt, "label": "offer", "content": "Congratulations, {{first_name}}, we would like to offer you admission to the {{program}} program in Computing Science at SFU.\r\n\r\nThis is good news. Really." }, {"unit": cmpt, "label": "visa", "content": "This is to confirm that {{title}} {{first_name}} {{last_name}} is currently enrolled as a full time student in the {{program}} in the School of Computing Science at SFU." }, {"unit": cmpt, "label": "Funding", "content": "This is to confirm that {{title}} {{first_name}} {{last_name}} is a student in the School of Computing Science's {{program}} program. {{He_She}} has been employed as follows:\r\n\r\n{% if tafunding %}Teaching assistant responsibilities include providing tutorials, office hours and marking assignments. {{title}} {{last_name}}'s assignments have been:\r\n\r\n{{ tafunding }}{% endif %}\r\n{% if rafunding %}Research assistants assist/provide research services to faculty. {{title}} {{last_name}}'s assignments have been:\r\n\r\n{{ rafunding }}{% endif %}\r\n{% if scholarships %}{{title}} {{last_name}} has received the following scholarships:\r\n\r\n{{ scholarships }}{% endif %}\r\n\r\n{{title}} {{last_name}} is making satisfactory progress." }, ] for data in templates: t = LetterTemplate(**data) t.save() p = GradProgram(unit=cmpt, label='MSc Course', description='MSc Course option') p.save() p = GradProgram(unit=cmpt, label='MSc Proj', description='MSc Project option') p.save() p = GradProgram(unit=cmpt, label='MSc Thesis', description='MSc Thesis option') p.save() p = GradProgram(unit=cmpt, label='PhD', description='Doctor of Philosophy') p.save() p = GradProgram(unit=cmpt, label='Qualifying', description='Qualifying student') p.save() p = GradProgram(unit=cmpt, label='Special', description='Special Arrangements') p.save() gr = GradRequirement(program=p, description='Achieved Speciality') gr.save() for p in GradProgram.objects.filter(unit=cmpt): gr = GradRequirement(program=p, description='Found campus') gr.save() gf = GradFlag(unit=cmpt, label='Dual Degree Program') gf.save() gf = GradFlag(unit=cmpt, label='Co-op') gf.save() grads = list(Person.objects.filter(last_name='Grad')) programs = list(GradProgram.objects.all()) today = datetime.date.today() starts = Semester.objects.filter(start__gt=today-datetime.timedelta(1000), start__lt=today) supervisors = list(set([m.person for m in Member.objects.filter(role='INST').select_related('person')])) # create GradStudents (and associated data) in a vaguely realistic way for g in grads + random.sample(grads, 5): # put a few in two programs p = random.choice(programs) start = random.choice(starts) sstart = start.start if random.randint(1,2) == 1: end = start.offset(random.randint(3,9)) else: end = None gs = GradStudent(person=g, program=p, research_area=randname(8)+'ology', campus=random.choice([x for x,_ in CAMPUS_CHOICES]), is_canadian=randnullbool()) gs.save() gph = GradProgramHistory(student=gs, program=p, start_semester=start) gph.save() if random.randint(1,3) == 1: p2 = random.choice([p2 for p2 in programs if p != p2 and p.unit == p2.unit]) gph = GradProgramHistory(student=gs, program=p2, start_semester=start.offset(random.randint(1,4))) gph.save() s = GradStatus(student=gs, status='COMP', start=start, start_date=sstart-datetime.timedelta(days=100)) s.save() if random.randint(1,4) == 1: s = GradStatus(student=gs, status='REJE', start=start, start_date=sstart-datetime.timedelta(days=80)) s.save() else: s = GradStatus(student=gs, status='OFFO', start=start, start_date=sstart-datetime.timedelta(days=80)) s.save() s = GradStatus(student=gs, status='ACTI', start=start, start_date=sstart) s.save() if end: if random.randint(1,3): s = GradStatus(student=gs, status='WIDR', start=end, start_date=end.start) s.save() else: s = GradStatus(student=gs, status='GRAD', start=end, start_date=end.start) s.save() gs.update_status_fields() # give some money sch = Scholarship(student=gs, scholarship_type=random.choice(scholarship_types)) sch.amount = 2000 sch.start_semester = start sch.end_semester = start.offset(2) sch.save() of = OtherFunding(student=gs, semester=start.offset(3)) of.amount = 1300 of.description = "Money fell from the sky" of.save() # promise p = Promise(student=gs, start_semester=start, end_semester=start.offset(2), amount=10000) p.save() p = Promise(student=gs, start_semester=start.offset(3), end_semester=start.offset(5), amount=10000) p.save() # flags if random.randint(1,3) == 1: cr = CompletedRequirement(requirement=gr, student=gs, semester=start.offset(1)) cr.save() if random.randint(1,4) == 1: gfv = GradFlagValue(flag=gf, student=gs, value=True) gfv.save() # supervisors if random.randint(1,3) != 1: p = random.choice(supervisors) s = Supervisor(student=gs, supervisor=p, supervisor_type='POT') s.save() if random.randint(1,2) == 1: s = Supervisor(student=gs, supervisor=p, supervisor_type='SEN') s.save() s = Supervisor(student=gs, supervisor=random.choice(supervisors), supervisor_type='COM') s.save() return itertools.chain( roles, programs, scholarship_types, GradRequirement.objects.all(), LetterTemplate.objects.all(), GradFlag.objects.all(), GradStudent.objects.all(), GradProgramHistory.objects.all(), GradStatus.objects.all(), Scholarship.objects.all(), OtherFunding.objects.all(), Promise.objects.all(), CompletedRequirement.objects.all(), GradFlagValue.objects.all(), Supervisor.objects.all(), )
def update_program_history(self, student_info, verbosity, dry_run): """ Find/update GradProgramHistory object for this happening """ programs = student_info['programs'] key = self.import_key() if self.strm < student_info['real_admit_term']: # program change could happen before admit: we take those as effective the student's admit term strm = student_info['real_admit_term'] else: strm = self.strm previous_history = [ p for p in programs if p.start_semester.name <= strm ] need_ph = False if previous_history: # there is a previously-known program: make sure it matches ph = previous_history[-1] if ph.program != self.grad_program: # current program isn't what we found # ... but is there maybe two program changes in one semester? similar_history = [ p for p in programs if p.start_semester.name == strm and p.program == self.grad_program ] if similar_history: ph = similar_history[0] # We need to check if we have a different date for this action than the matching entry. # in some cases (like adding an active status afterwards), we need this date to be maximized # to show the correct current program. if ph.starting != self.effdt: if verbosity > 1: print("Changing start of similar program %s/%s in %s from %s to %s" % \ (self.emplid, self.unit.slug, self.grad_program.slug, ph.starting, self.effdt)) ph.starting = self.effdt if not dry_run: ph.save() else: need_ph = True else: # maybe the next-known program change is to the same program? If so, move it back. next_history = [ p for p in programs if p.start_semester.name > strm ] if next_history and next_history[0].program == self.grad_program: if verbosity > 1: print( "* Adjusting program change start: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm)) ph = next_history[0] ph.start_semester = STRM_MAP[strm] ph.starting = self.effdt else: # no history: create need_ph = True # make sure we don't duplicate: have a last look for an old import existing_history = [ p for p in programs if SIMS_SOURCE in p.config and (p.config[SIMS_SOURCE] == key or p. config[SIMS_SOURCE] == self.oldkey) ] if existing_history: ph = existing_history[0] need_ph = False if need_ph: if (verbosity and previous_history) or verbosity > 1: # don't usually report first ever ProgramHistory because those are boring print("Adding program change: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm)) ph = GradProgramHistory(student=student_info['student'], program=self.grad_program, start_semester=STRM_MAP[strm], starting=self.effdt) ph.config[SIMS_SOURCE] = key student_info['programs'].append(ph) student_info['programs'].sort( key=lambda p: (p.start_semester.name, p.starting)) else: if SIMS_SOURCE not in ph.config or ph.config[ SIMS_SOURCE] == self.oldkey: ph.config[SIMS_SOURCE] = key if not dry_run: ph.save_if_dirty()
def import_student( program_map, semester_object, dryrun, skip_duplicates, unit, emplid, adm_appl_nbr, acad_prog, errors, adm_appl_nbrs ): """ program_map - a dictionary, mapping SIMS indicators ("CPPHD") to GradProgram objects (GradProgram.objects.get(...)) semester - Semester dryrun - if True, do not actually import the student unit - Unit emplid - the emplid of the student to import adm_appl_nbr - admission application number of the student to import acad_prog - acad_prog of the student to import errors - array containing any errors encountered by the system so far adm_appl_nbrs - array containing any adm_appl_nbrs encountered by the system so far. """ print(emplid, adm_appl_nbr) # Find or generate a Person object for this student person = find_or_generate_person(emplid) # Do we already have this student? if is_already_imported( person, adm_appl_nbr ) or adm_appl_nbr in adm_appl_nbrs: print("This GradStudent record already exists in coursys") print(" -------------------------------- ") return errors, adm_appl_nbrs # This additional check shouldn't be necessary, a year or so from now. grad_student_records = GradStudent.objects.filter(person=person) if len(grad_student_records) > 0: print("This GradStudent record may already exist in coursys: ") if skip_duplicates: print(".. so we're not dealing with it for now.") return errors, adm_appl_nbrs else: print("Please select: ") for i in range(0, len(grad_student_records)): student = grad_student_records[i] print(i, "--", student, "--", "http://courses.cs.sfu.ca/grad/"+student.slug) print("N -- None of these are correct; Proceed with import.") n = get_number_or_n( list(range(0, len(grad_student_records))) ) if n != 'n': correct_record = grad_student_records[n] correct_record.config['adm_appl_nbr'] = adm_appl_nbr if not dryrun: correct_record.save() return errors, adm_appl_nbrs adm_appl_nbrs.append(adm_appl_nbr) # Find or generate a Program for this student try: program = program_map[acad_prog] except KeyError: errors.append( emplid + " was not imported" ) errors.append("\tThe program for " + acad_prog + " could not be found. This is a Bad Thing. Fix the program map.") return errors, adm_appl_nbrs print(acad_prog) print(program) english_fluency = "" mother_tongue = get_mother_tongue( emplid ) print(mother_tongue) passport_issued_by = get_passport_issued_by( emplid ) print(passport_issued_by) if passport_issued_by == "Canada": is_canadian = True elif holds_resident_visa( emplid ): is_canadian = True else: is_canadian = False print(is_canadian) research_area = get_research_area( emplid, program.unit.acad_org ) print(research_area) grad = GradStudent( person=person, program=program, english_fluency=english_fluency, mother_tongue=mother_tongue, is_canadian=is_canadian, research_area=research_area, passport_issued_by=passport_issued_by, comments="" ) grad.config['adm_appl_nbr'] = adm_appl_nbr grad.config['imported_from'] = "Grad student import " + str(datetime.date.today()) email = get_email(emplid) if email: grad.config['applic_email'] = email print("Creating new Grad Student") print(grad) if not dryrun: grad.save() # Personal data personal_info = coredata.queries.grad_student_info(emplid) print(personal_info) if 'visa' in personal_info: person.config['visa'] = personal_info['visa'] if 'citizen' in personal_info: person.config['citizen'] = personal_info['citizen'] if 'ccredits' in personal_info: person.config['ccredits'] = personal_info['ccredits'] if 'gpa' in personal_info: person.config['gpa'] = personal_info['gpa'] if 'gender' in personal_info: person.config['gender'] = personal_info['gender'] # GradProgramHistory history = GradProgramHistory( student=grad, program=program, start_semester=semester_object, starting=semester_object.start ) # GradStatus chronological_history = get_status_history( emplid, adm_appl_nbr) admitted = False grad_statuses = [] for event, date, semester in chronological_history: status_code = None if event == "ADMT" or event == "COND": status_code = "OFFO" admitted = True elif event == "APPL": status_code = "COMP" elif event == "MATR": status_code = "CONF" elif event == "DENY": status_code = "REJE" elif event == "WAPP" or event == "WADM": if admitted: status_code = "DECL" else: status_code = "EXPI" else: print("Status " + event + " cannot be converted into a status.") continue start_semester = Semester.objects.get(name=semester) status = GradStatus( student=grad, status=status_code, start=start_semester, start_date=date ) print(status) grad_statuses.append( status ) # Save all of the actual data. if not dryrun: person.save() history.save() for status in grad_statuses: status.save() print("------------------") return errors, adm_appl_nbrs
def import_student(program_map, semester_object, dryrun, skip_duplicates, unit, emplid, adm_appl_nbr, acad_prog, errors, adm_appl_nbrs): """ program_map - a dictionary, mapping SIMS indicators ("CPPHD") to GradProgram objects (GradProgram.objects.get(...)) semester - Semester dryrun - if True, do not actually import the student unit - Unit emplid - the emplid of the student to import adm_appl_nbr - admission application number of the student to import acad_prog - acad_prog of the student to import errors - array containing any errors encountered by the system so far adm_appl_nbrs - array containing any adm_appl_nbrs encountered by the system so far. """ print(emplid, adm_appl_nbr) # Find or generate a Person object for this student person = find_or_generate_person(emplid) # Do we already have this student? if is_already_imported(person, adm_appl_nbr) or adm_appl_nbr in adm_appl_nbrs: print("This GradStudent record already exists in coursys") print(" -------------------------------- ") return errors, adm_appl_nbrs # This additional check shouldn't be necessary, a year or so from now. grad_student_records = GradStudent.objects.filter(person=person) if len(grad_student_records) > 0: print("This GradStudent record may already exist in coursys: ") if skip_duplicates: print(".. so we're not dealing with it for now.") return errors, adm_appl_nbrs else: print("Please select: ") for i in range(0, len(grad_student_records)): student = grad_student_records[i] print(i, "--", student, "--", "http://courses.cs.sfu.ca/grad/" + student.slug) print("N -- None of these are correct; Proceed with import.") n = get_number_or_n(list(range(0, len(grad_student_records)))) if n != 'n': correct_record = grad_student_records[n] correct_record.config['adm_appl_nbr'] = adm_appl_nbr if not dryrun: correct_record.save() return errors, adm_appl_nbrs adm_appl_nbrs.append(adm_appl_nbr) # Find or generate a Program for this student try: program = program_map[acad_prog] except KeyError: errors.append(emplid + " was not imported") errors.append( "\tThe program for " + acad_prog + " could not be found. This is a Bad Thing. Fix the program map.") return errors, adm_appl_nbrs print(acad_prog) print(program) english_fluency = "" mother_tongue = get_mother_tongue(emplid) print(mother_tongue) passport_issued_by = get_passport_issued_by(emplid) print(passport_issued_by) if passport_issued_by == "Canada": is_canadian = True elif holds_resident_visa(emplid): is_canadian = True else: is_canadian = False print(is_canadian) research_area = get_research_area(emplid, program.unit.acad_org) print(research_area) grad = GradStudent(person=person, program=program, english_fluency=english_fluency, mother_tongue=mother_tongue, is_canadian=is_canadian, research_area=research_area, passport_issued_by=passport_issued_by, comments="") grad.config['adm_appl_nbr'] = adm_appl_nbr grad.config['imported_from'] = "Grad student import " + str( datetime.date.today()) email = get_email(emplid) if email: grad.config['applic_email'] = email print("Creating new Grad Student") print(grad) if not dryrun: grad.save() # Personal data personal_info = coredata.queries.grad_student_info(emplid) print(personal_info) if 'visa' in personal_info: person.config['visa'] = personal_info['visa'] if 'citizen' in personal_info: person.config['citizen'] = personal_info['citizen'] if 'ccredits' in personal_info: person.config['ccredits'] = personal_info['ccredits'] if 'gpa' in personal_info: person.config['gpa'] = personal_info['gpa'] if 'gender' in personal_info: person.config['gender'] = personal_info['gender'] # GradProgramHistory history = GradProgramHistory(student=grad, program=program, start_semester=semester_object, starting=semester_object.start) # GradStatus chronological_history = get_status_history(emplid, adm_appl_nbr) admitted = False grad_statuses = [] for event, date, semester in chronological_history: status_code = None if event == "ADMT" or event == "COND": status_code = "OFFO" admitted = True elif event == "APPL": status_code = "COMP" elif event == "MATR": status_code = "CONF" elif event == "DENY": status_code = "REJE" elif event == "WAPP" or event == "WADM": if admitted: status_code = "DECL" else: status_code = "EXPI" else: print("Status " + event + " cannot be converted into a status.") continue start_semester = Semester.objects.get(name=semester) status = GradStatus(student=grad, status=status_code, start=start_semester, start_date=date) print(status) grad_statuses.append(status) # Save all of the actual data. if not dryrun: person.save() history.save() for status in grad_statuses: status.save() print("------------------") return errors, adm_appl_nbrs
def update_program_history(self, student_info, verbosity, dry_run): """ Find/update GradProgramHistory object for this happening """ programs = student_info['programs'] if self.unit.slug == 'cmpt' and programs: # CMPT students get only their initial application gradprogramhistory filled in. return key = self.import_key() if self.strm < student_info['real_admit_term']: # program change could happen before admit: we take those as effective the student's admit term strm = student_info['real_admit_term'] else: strm = self.strm previous_history = [ p for p in programs if p.start_semester.name <= strm ] need_ph = False if previous_history: # there is a previously-known program: make sure it matches ph = previous_history[-1] if ph.program != self.grad_program: # current program isn't what we found # ... but is there maybe two program changes in one semester? similar_history = [ p for p in programs if p.start_semester.name == strm and p.program == self.grad_program ] if similar_history: ph = similar_history[0] else: need_ph = True else: # maybe the next-known program change is to the same program? If so, move it back. next_history = [ p for p in programs if p.start_semester.name > strm ] if next_history and next_history[0].program == self.grad_program: if verbosity > 1: print "* Adjusting program change start: %s/%s in %s as of %s." % ( self.emplid, self.unit.slug, self.grad_program.slug, strm) ph = next_history[0] ph.start_semester = STRM_MAP[strm] ph.starting = self.effdt else: # no history: create need_ph = True # make sure we don't duplicate: have a last look for an old import existing_history = [ p for p in programs if SIMS_SOURCE in p.config and (p.config[SIMS_SOURCE] == key or p. config[SIMS_SOURCE] == self.oldkey) ] if existing_history: ph = existing_history[0] need_ph = False if need_ph: if (verbosity and previous_history) or verbosity > 1: # don't usually report first ever ProgramHistory because those are boring print "Adding program change: %s/%s in %s as of %s." % ( self.emplid, self.unit.slug, self.grad_program.slug, strm) ph = GradProgramHistory(student=student_info['student'], program=self.grad_program, start_semester=STRM_MAP[strm], starting=self.effdt) ph.config[SIMS_SOURCE] = key student_info['programs'].append(ph) student_info['programs'].sort( key=lambda p: (p.start_semester.name, p.starting)) else: if SIMS_SOURCE not in ph.config or ph.config[ SIMS_SOURCE] == self.oldkey: ph.config[SIMS_SOURCE] = key if not dry_run: ph.save_if_dirty()
def update_program_history(self, student_info, verbosity, dry_run): """ Find/update GradProgramHistory object for this happening """ programs = student_info['programs'] if self.unit.slug == 'cmpt' and programs: # CMPT students get only their initial application gradprogramhistory filled in. return key = self.import_key() if self.strm < student_info['real_admit_term']: # program change could happen before admit: we take those as effective the student's admit term strm = student_info['real_admit_term'] else: strm = self.strm previous_history = [p for p in programs if p.start_semester.name <= strm] need_ph = False if previous_history: # there is a previously-known program: make sure it matches ph = previous_history[-1] if ph.program != self.grad_program: # current program isn't what we found # ... but is there maybe two program changes in one semester? similar_history = [p for p in programs if p.start_semester == ph.start_semester and p.program == self.grad_program] if similar_history: ph = similar_history[0] else: need_ph = True else: # maybe the next-known program change is to the same program? If so, move it back. next_history = [p for p in programs if p.start_semester.name > strm] if next_history and next_history[0].program == self.grad_program: if verbosity > 1: print "* Adjusting program change start: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm) ph = next_history[0] ph.start_semester = STRM_MAP[strm] ph.starting = self.effdt else: # no history: create need_ph = True # make sure we don't duplicate: have a last look for an old import existing_history = [p for p in programs if SIMS_SOURCE in p.config and (p.config[SIMS_SOURCE] == key or p.config[SIMS_SOURCE] == self.oldkey)] if existing_history: ph = existing_history[0] need_ph = False if need_ph: if (verbosity and previous_history) or verbosity > 1: # don't usually report first ever ProgramHistory because those are boring print "Adding program change: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm) ph = GradProgramHistory(student=student_info['student'], program=self.grad_program, start_semester=STRM_MAP[strm], starting=self.effdt) ph.config[SIMS_SOURCE] = key student_info['programs'].append(ph) student_info['programs'].sort(key=lambda p: (p.start_semester.name, p.starting)) else: if SIMS_SOURCE not in ph.config or ph.config[SIMS_SOURCE] == self.oldkey: ph.config[SIMS_SOURCE] = key if not dry_run: ph.save_if_dirty()
def update_program_history(self, student_info, verbosity, dry_run): """ Find/update GradProgramHistory object for this happening """ programs = student_info['programs'] key = self.import_key() if self.strm < student_info['real_admit_term']: # program change could happen before admit: we take those as effective the student's admit term strm = student_info['real_admit_term'] else: strm = self.strm previous_history = [p for p in programs if p.start_semester.name <= strm] need_ph = False if previous_history: # there is a previously-known program: make sure it matches ph = previous_history[-1] if ph.program != self.grad_program: # current program isn't what we found # ... but is there maybe two program changes in one semester? similar_history = [p for p in programs if p.start_semester.name == strm and p.program == self.grad_program] if similar_history: ph = similar_history[0] # We need to check if we have a different date for this action than the matching entry. # in some cases (like adding an active status afterwards), we need this date to be maximized # to show the correct current program. if ph.starting != self.effdt: if verbosity > 1: print("Changing start of similar program %s/%s in %s from %s to %s" % \ (self.emplid, self.unit.slug, self.grad_program.slug, ph.starting, self.effdt)) ph.starting = self.effdt if not dry_run: ph.save() else: need_ph = True else: # maybe the next-known program change is to the same program? If so, move it back. next_history = [p for p in programs if p.start_semester.name > strm] if next_history and next_history[0].program == self.grad_program: if verbosity > 1: print("* Adjusting program change start: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm)) ph = next_history[0] ph.start_semester = STRM_MAP[strm] ph.starting = self.effdt else: # no history: create need_ph = True # make sure we don't duplicate: have a last look for an old import existing_history = [p for p in programs if SIMS_SOURCE in p.config and (p.config[SIMS_SOURCE] == key or p.config[SIMS_SOURCE] == self.oldkey)] if existing_history: ph = existing_history[0] need_ph = False if need_ph: if (verbosity and previous_history) or verbosity > 1: # don't usually report first ever ProgramHistory because those are boring print("Adding program change: %s/%s in %s as of %s." % (self.emplid, self.unit.slug, self.grad_program.slug, strm)) ph = GradProgramHistory(student=student_info['student'], program=self.grad_program, start_semester=STRM_MAP[strm], starting=self.effdt) ph.config[SIMS_SOURCE] = key student_info['programs'].append(ph) student_info['programs'].sort(key=lambda p: (p.start_semester.name, p.starting)) else: if SIMS_SOURCE not in ph.config or ph.config[SIMS_SOURCE] == self.oldkey: ph.config[SIMS_SOURCE] = key if not dry_run: ph.save_if_dirty()