def create_units(): univ, _ = Unit.objects.get_or_create(label='UNIV', name='Simon Fraser University') fas = Unit(label='FAS', name='Faculty of Applied Sciences', parent=univ).save() ensc = Unit(label='ENSC', name='School of Engineering Science', parent=fas, acad_org='ENG SCI').save() cmpt = Unit(label='CMPT', name='School of Computing Science', parent=fas, acad_org='COMP SCI') cmpt.set_address([ '9971 Applied Sciences Building', '8888 University Drive, Burnaby, BC', 'Canada V5A 1S6' ]) cmpt.set_email('*****@*****.**') cmpt.set_web('http://www.cs.sfu.ca/') cmpt.set_tel('778-782-4277') cmpt.set_fax('778-782-3045') cmpt.set_informal_name('Computing Science') cmpt.config['sessional_pay'] = 10000 cmpt.set_deptid('12345') cmpt.save()
def create_test_offering(): """ Create a CourseOffering (and related stuff) that can be used in tests with no fixtures """ s = create_fake_semester('1144') u = Unit(label='BABL', name="Department of Babbling") u.save() o = CourseOffering(subject='BABL', number='123', section='F104', semester=s, component='LEC', owner=u, title='Babbling for Baferad Ferzizzles', enrl_cap=100, enrl_tot=5, wait_tot=0) o.save() i = Person(first_name='Insley', last_name='Instructorberg', emplid=20000009, userid='instr') i.save() s = Person(first_name='Stanley', last_name='Studentson', emplid=20000010, userid='student') s.save() Member(offering=o, person=i, role='INST').save() Member(offering=o, person=s, role='STUD').save() return o
def create_units(): univ = Unit.objects.get(slug='univ') fas = Unit(label='FAS', name='Faculty of Applied Sciences', parent=univ) fas.save() ensc = Unit(label='ENSC', name='School of Engineering Science', parent=fas, acad_org='ENG SCI') ensc.save() mse = Unit(label='MSE', name='School of Mechatronic Systems Engineering', parent=fas, acad_org='MECH SYS') mse.save() cmpt = Unit(label='CMPT', name='School of Computing Science', parent=fas, acad_org='COMP SCI') cmpt.set_address([ '9971 Applied Sciences Building', '8888 University Drive, Burnaby, BC', 'Canada V5A 1S6' ]) cmpt.set_email('*****@*****.**') cmpt.set_web('http://www.cs.sfu.ca/') cmpt.set_tel('778-782-4277') cmpt.set_fax('778-782-3045') cmpt.set_informal_name('Computing Science') cmpt.set_deptid('12345') cmpt.save()
def create_units(): univ, _ = Unit.objects.get_or_create(label='UNIV', name='Simon Fraser University') fas = Unit(label='FAS', name='Faculty of Applied Sciences', parent=univ).save() ensc = Unit(label='ENSC', name='School of Engineering Science', parent=fas, acad_org='ENG SCI').save() cmpt = Unit(label='CMPT', name='School of Computing Science', parent=fas, acad_org='COMP SCI') cmpt.set_address(['9971 Applied Sciences Building', '8888 University Drive, Burnaby, BC', 'Canada V5A 1S6']) cmpt.set_email('*****@*****.**') cmpt.set_web('http://www.cs.sfu.ca/') cmpt.set_tel('778-782-4277') cmpt.set_fax('778-782-3045') cmpt.set_informal_name('Computing Science') cmpt.config['sessional_pay'] = 10000 cmpt.set_deptid('12345') cmpt.save()
def get_unit(acad_org, create=False): """ Get the corresponding Unit """ # there are some inconsistent acad_org values: normalize. if acad_org == 'GERON': acad_org = 'GERONTOL' elif acad_org == 'GEOG': acad_org = 'GEOGRAPH' elif acad_org == 'BUS': acad_org = 'BUS ADMIN' elif acad_org == 'HUM': acad_org = 'HUMANITIES' elif acad_org == 'EVSC': acad_org = 'ENVIRO SCI' try: unit = Unit.objects.get(acad_org=acad_org) except Unit.DoesNotExist: db = SIMSConn() db.execute( "SELECT descrformal FROM ps_acad_org_tbl " "WHERE eff_status='A' and acad_org=%s", (acad_org, )) name, = db.fetchone() if acad_org == 'COMP SCI': # for test/demo imports label = 'CMPT' elif acad_org == 'ENG SCI': # for test/demo imports label = 'ENSC' elif acad_org == 'ENVIRONMEN': # for test/demo imports label = 'FENV' elif acad_org == 'DEAN GRAD': # for test/demo imports label = 'GRAD' else: label = acad_org[:4].strip() if create: unit = Unit(acad_org=acad_org, label=label, name=name, parent=None) unit.save() else: raise KeyError("Unknown unit: acad_org=%s, label~=%s, name~=%s." % (acad_org, label, name)) return unit
def create_true_core(): """ Just enough data to bootstrap a minimal environment. """ import_semester_info(dry_run=False, verbose=False, long_long_ago=True, bootstrap=True) p = find_person('ggbaker') p.emplid = '200000100' p.save() u = Unit(label='UNIV', name='Simon Fraser University') u.save() r = Role(person=p, role='SYSA', unit=u) r.save() return itertools.chain( Semester.objects.filter(name__gt=SEMESTER_CUTOFF), Person.objects.filter(userid='ggbaker'), Unit.objects.all(), Role.objects.all(), )
def get_unit(acad_org, create=False): """ Get the corresponding Unit """ # there are some inconsistent acad_org values: normalize. if acad_org == 'GERON': acad_org = 'GERONTOL' elif acad_org == 'GEOG': acad_org = 'GEOGRAPH' elif acad_org == 'BUS': acad_org = 'BUS ADMIN' elif acad_org == 'HUM': acad_org = 'HUMANITIES' elif acad_org == 'EVSC': acad_org = 'ENVIRO SCI' try: unit = Unit.objects.get(acad_org=acad_org) except Unit.DoesNotExist: db = SIMSConn() db.execute("SELECT descrformal FROM ps_acad_org_tbl " "WHERE eff_status='A' and acad_org=%s", (acad_org,)) name, = db.fetchone() if acad_org == 'COMP SCI': # for test/demo imports label = 'CMPT' elif acad_org == 'ENG SCI': # for test/demo imports label = 'ENSC' elif acad_org == 'ENVIRONMEN': # for test/demo imports label = 'FENV' elif acad_org == 'DEAN GRAD': # for test/demo imports label = 'GRAD' else: label = acad_org[:4].strip() if create: unit = Unit(acad_org=acad_org, label=label, name=name, parent=None) unit.save() else: raise KeyError("Unknown unit: acad_org=%s, label~=%s, name~=%s." % (acad_org, label, name)) return unit
def create_true_core(): """ Just enough data to bootstrap a minimal environment. """ import_semester_info(dry_run=False, verbose=False, long_long_ago=True, bootstrap=True) p = find_person('ggbaker') p.emplid = '200000100' p.first_name = 'Gregorʏ' p.pref_first_name = 'Greg' p.save() u = Unit(label='UNIV', name='Simon Fraser University') u.save() r = Role(person=p, role='SYSA', unit=u, expiry=role_expiry) r.save() return itertools.chain( Semester.objects.filter(name__gt=SEMESTER_CUTOFF), Person.objects.filter(userid='ggbaker'), Unit.objects.all(), Role.objects.all(), )
def create_units(): univ = Unit.objects.get(slug='univ') fas = Unit(label='FAS', name='Faculty of Applied Sciences', parent=univ) fas.save() ensc = Unit(label='ENSC', name='School of Engineering Science', parent=fas, acad_org='ENG SCI') ensc.save() mse = Unit(label='MSE', name='School of Mechatronic Systems Engineering', parent=fas, acad_org='MECH SYS') mse.save() cmpt = Unit(label='CMPT', name='School of Computing Science', parent=fas, acad_org='COMP SCI') cmpt.set_address(['9971 Applied Sciences Building', '8888 University Drive, Burnaby, BC', 'Canada V5A 1S6']) cmpt.set_email('*****@*****.**') cmpt.set_web('http://www.cs.sfu.ca/') cmpt.set_tel('778-782-4277') cmpt.set_fax('778-782-3045') cmpt.set_informal_name('Computing Science') cmpt.set_deptid('12345') cmpt.save()
def create_unit(): unit = Unit(label="UNIV", name="Testington University") unit.save() return unit
def setUp(self): """ Build a TACategory, TAContract, and two TACourses """ unit = Unit(label="TEST", name="A Fake Unit for Testing") unit.save() person = Person(emplid="300000000", userid="testy", first_name="Testy", last_name="Testerson") person.save() semester = Semester(name="1147", start=datetime.date.today(), end=datetime.date.today()) semester.save() course1 = Course(subject="TEST", number="100", title="Intro to Testing") course1.save() course2 = Course(subject="TEST", number="200", title="Advanced Testing") course2.save() courseoffering1 = CourseOffering(subject="TEST", number="100", section="D100", semester=semester, component="LEC", owner=unit, title="Intro to Testing", campus="BRNBY", enrl_cap=100, enrl_tot=100, wait_tot=50, course=course1) courseoffering1.save() courseoffering2 = CourseOffering(subject="TEST", number="200", section="D200", semester=semester, component="LEC", owner=unit, title="Advanced Testing", campus="BRNBY", enrl_cap=100, enrl_tot=100, wait_tot=50, course=course2) courseoffering2.save() account = Account(unit=unit, account_number=1337, position_number=5, title="A Fake Account for Testing") account.save() four_weeks_later = datetime.date.today() + datetime.timedelta(days=28) hiring_semester = HiringSemester(semester=semester, unit=unit, deadline_for_acceptance=datetime.date.today(), pay_start=datetime.date.today(), pay_end=four_weeks_later, payperiods=2.5) hiring_semester.save() category = TACategory(account=account, hiring_semester=hiring_semester, code="TST", title="Test Contract Category", hours_per_bu=decimal.Decimal("42"), holiday_hours_per_bu=decimal.Decimal("1.1"), pay_per_bu=decimal.Decimal("125.00"), scholarship_per_bu=decimal.Decimal("25.00"), bu_lab_bonus=decimal.Decimal("0.17")) category.save() contract = TAContract(category=category, person=person, status="NEW", sin="123456789", deadline_for_acceptance=datetime.date.today(), pay_start=datetime.date.today(), pay_end=datetime.date.today() + datetime.timedelta(days=10), payperiods=2.5, appointment="INIT", conditional_appointment=True, created_by="classam", tssu_appointment=True) contract.save() tacourse = TACourse(course=courseoffering1, contract=contract, bu=decimal.Decimal('3.0'), labtut=True) tacourse.save() tacourse2 = TACourse(course=courseoffering2, contract=contract, bu=decimal.Decimal('2.0'), labtut=False) tacourse2.save()
def setUp(self): """ Build a TACategory, TAContract, and two TACourses """ unit = Unit(label="TEST", name="A Fake Unit for Testing") unit.save() person = Person(emplid="300000000", userid="testy", first_name="Testy", last_name="Testerson") person.save() semester = Semester(name="1147", start=datetime.date.today(), end=datetime.date.today()) semester.save() course1 = Course(subject="TEST", number="100", title="Intro to Testing") course1.save() course2 = Course(subject="TEST", number="200", title="Advanced Testing") course2.save() courseoffering1 = CourseOffering(subject="TEST", number="100", section="D100", semester=semester, component="LEC", owner=unit, title="Intro to Testing", campus="BRNBY", enrl_cap=100, enrl_tot=100, wait_tot=50, course=course1) courseoffering1.save() courseoffering2 = CourseOffering(subject="TEST", number="200", section="D200", semester=semester, component="LEC", owner=unit, title="Advanced Testing", campus="BRNBY", enrl_cap=100, enrl_tot=100, wait_tot=50, course=course2) courseoffering2.save() account = Account(unit=unit, account_number=1337, position_number=5, title="A Fake Account for Testing") account.save() four_weeks_later = datetime.date.today() + datetime.timedelta(days=28) hiring_semester = HiringSemester(semester=semester, unit=unit, deadline_for_acceptance=datetime.date.today(), pay_start=datetime.date.today(), pay_end=four_weeks_later, payperiods=2.5) hiring_semester.save() category = TACategory(account=account, hiring_semester=hiring_semester, code="TST", title="Test Contract Category", hours_per_bu=decimal.Decimal("42"), holiday_hours_per_bu=decimal.Decimal("1.1"), pay_per_bu=decimal.Decimal("100.00"), scholarship_per_bu=decimal.Decimal("25.00"), bu_lab_bonus=decimal.Decimal("0.17")) category.save() contract = TAContract(category=category, person=person, status="NEW", sin="123456789", deadline_for_acceptance=datetime.date.today(), pay_start=datetime.date.today(), pay_end=datetime.date.today() + datetime.timedelta(days=10), payperiods=2.5, appointment="INIT", conditional_appointment=True, created_by="classam", tssu_appointment=True) contract.save() tacourse = TACourse(course=courseoffering1, contract=contract, bu=decimal.Decimal('3.0'), labtut=True) tacourse.save() tacourse2 = TACourse(course=courseoffering2, contract=contract, bu=decimal.Decimal('2.0'), labtut=False) tacourse2.save()