def semester_config(request, semester_name=None):
if semester_name:
semester = get_object_or_404(Semester, name=semester_name)
else:
semester = Semester.next_starting()
unit_choices = [(u.id, u.name) for u in request.units]
if request.method == 'POST':
form = SemesterConfigForm(request.POST)
form.fields['unit'].choices = unit_choices
if form.is_valid():
config = SemesterConfig.get_config(
units=[form.cleaned_data['unit']], semester=semester)
config.set_start_date(form.cleaned_data['start_date'])
config.set_end_date(form.cleaned_data['end_date'])
config.save()
messages.success(
request,
'Updated semester configuration for %s.' % (semester.name))
return HttpResponseRedirect(reverse('ra.views.search'))
else:
config = SemesterConfig.get_config(units=request.units,
semester=semester)
form = SemesterConfigForm(initial={
'start_date': config.start_date(),
'end_date': config.end_date()
})
form.fields['unit'].choices = unit_choices
return render(request, 'ra/semester_config.html', {
'semester': semester,
'form': form
})
def new(request):
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices = _appointment_defaults(request.units)
if request.method == 'POST':
data = request.POST.copy()
if data['pay_frequency'] == 'L':
# force legal values into the non-submitted (and don't-care) fields for lump sum pay
data['biweekly_pay'] = 1
data['hourly_pay'] = 1
data['hours'] = 1
data['pay_periods'] = 1
raform = RAForm(data)
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
if raform.is_valid():
userid = raform.cleaned_data['person'].userid_or_emplid()
appointment = raform.save(commit=False)
appointment.set_use_hourly(raform.cleaned_data['use_hourly'])
appointment.save()
messages.success(request, 'Created RA Appointment for ' + appointment.person.name())
return HttpResponseRedirect(reverse(student_appointments, kwargs=({'userid': userid})))
else:
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(initial={'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80 })
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
return render(request, 'ra/new.html', { 'raform': raform })
def new(request):
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices =_appointment_defaults(request.units)
if request.method == 'POST':
data = request.POST.copy()
if data['pay_frequency'] == 'L':
# force legal values into the non-submitted (and don't-care) fields for lump sum pay
data['biweekly_pay'] = 1
data['hourly_pay'] = 1
data['hours'] = 1
data['pay_periods'] = 1
raform = RAForm(data)
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
if raform.is_valid():
userid = raform.cleaned_data['person'].userid_or_emplid()
appointment = raform.save(commit=False)
appointment.set_use_hourly(raform.cleaned_data['use_hourly'])
appointment.save()
messages.success(request, 'Created RA Appointment for ' + appointment.person.name())
return HttpResponseRedirect(reverse(student_appointments, kwargs=({'userid': userid})))
else:
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(initial={'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80 })
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
return render(request, 'ra/new.html', { 'raform': raform })
def new_student(request, userid):
person = get_object_or_404(Person, find_userid_or_emplid(userid))
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
student = get_object_or_404(Person, find_userid_or_emplid(userid))
initial = {
'person': student.emplid,
'start_date': semesterconfig.start_date(),
'end_date': semesterconfig.end_date(),
'hours': 80
}
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices = _appointment_defaults(
request.units, emplid=student.emplid)
gss = GradStudent.objects.filter(person=student)
if gss:
gradstudent = gss[0]
initial['sin'] = gradstudent.person.sin()
raform = RAForm(initial=initial)
raform.fields['person'] = forms.CharField(widget=forms.HiddenInput())
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
return render(request, 'ra/new.html', {'raform': raform, 'person': person})
def create_ra_data():
unit = Unit.objects.get(slug='cmpt')
s = Semester.objects.get(name=TEST_SEMESTER)
superv = list(possible_supervisor_people([unit]))
empl = list(itertools.chain(Person.objects.filter(userid__endswith='grad'), random.sample(Person.objects.filter(last_name='Student'), 10)))
cats = [c for c,d in HIRING_CATEGORY_CHOICES if c not in HIRING_CATEGORY_DISABLED]
config = SemesterConfig.get_config([unit], s)
acct = Account(account_number=12349, position_number=12349, title='NSERC RA', unit=unit)
acct.save()
proj1 = Project(project_number=987654, fund_number=31, unit=unit)
proj1.save()
proj2 = Project(project_number=876543, fund_number=13, unit=unit)
proj2.save()
for i in range(30):
p = random.choice(empl)
s = random.choice(superv)
c = random.choice(cats)
freq = random.choice(['B', 'L'])
if freq == 'B':
payargs = {'lump_sum_pay': 10000, 'biweekly_pay': 1250, 'pay_periods': 8, 'hourly_pay': 31, 'hours': 40}
else:
payargs = {'lump_sum_pay': 4000, 'biweekly_pay': 0, 'pay_periods': 8, 'hourly_pay': 0, 'hours': 0}
ra = RAAppointment(person=p, sin=123456789, hiring_faculty=s, unit=unit, hiring_category=c,
project=random.choice([proj1,proj2]), account=acct, pay_frequency=freq,
start_date=config.start_date(), end_date=config.end_date(),
**payargs)
ra.set_use_hourly(random.choice([True, False]))
ra.save()
def create_ra_data():
unit = Unit.objects.get(slug='cmpt')
s = Semester.objects.get(name=TEST_SEMESTER)
superv = list(possible_supervisor_people([unit]))
empl = list(itertools.chain(Person.objects.filter(userid__endswith='grad'), random.sample(Person.objects.filter(last_name='Student'), 10)))
cats = [c for c,d in HIRING_CATEGORY_CHOICES if c not in HIRING_CATEGORY_DISABLED]
config = SemesterConfig.get_config([unit], s)
acct = Account(account_number=12349, position_number=12349, title='NSERC RA', unit=unit)
acct.save()
proj1 = Project(project_number=987654, fund_number=31, unit=unit)
proj1.save()
proj2 = Project(project_number=876543, fund_number=13, unit=unit)
proj2.save()
for i in range(30):
p = random.choice(empl)
s = random.choice(superv)
c = random.choice(cats)
freq = random.choice(['B', 'L'])
if freq == 'B':
payargs = {'lump_sum_pay': 10000, 'biweekly_pay': 1250, 'pay_periods': 8, 'hourly_pay': 31, 'hours': 40}
else:
payargs = {'lump_sum_pay': 4000, 'biweekly_pay': 0, 'pay_periods': 8, 'hourly_pay': 0, 'hours': 0}
ra = RAAppointment(person=p, sin=123456789, hiring_faculty=s, unit=unit, hiring_category=c,
project=random.choice([proj1,proj2]), account=acct, pay_frequency=freq,
start_date=config.start_date(), end_date=config.end_date(),
**payargs)
ra.set_use_hourly(random.choice([True, False]))
ra.save()
def reappoint(request, ra_slug):
appointment = get_object_or_404(RAAppointment,
slug=ra_slug,
deleted=False,
unit__in=request.units)
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(instance=appointment,
initial={
'person': appointment.person.emplid,
'reappointment': True,
'start_date': semesterconfig.start_date(),
'end_date': semesterconfig.end_date(),
'hours': 80,
'use_hourly': appointment.use_hourly()
})
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices, program_choices = \
_appointment_defaults(request.units, emplid=appointment.person.emplid)
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
raform.fields['program'].choices = program_choices
return render(request, 'ra/new.html', {
'raform': raform,
'appointment': appointment
})
def semester_config(request, semester_name=None):
if semester_name:
semester = get_object_or_404(Semester, name=semester_name)
else:
semester = Semester.next_starting()
unit_choices = [(u.id, u.name) for u in request.units]
if request.method == 'POST':
form = SemesterConfigForm(request.POST)
form.fields['unit'].choices = unit_choices
if form.is_valid():
config = SemesterConfig.get_config(units=[form.cleaned_data['unit']], semester=semester)
config.set_start_date(form.cleaned_data['start_date'])
config.set_end_date(form.cleaned_data['end_date'])
config.save()
messages.success(request, 'Updated semester configuration for %s.' % (semester.name))
return HttpResponseRedirect(reverse('ra.views.search'))
else:
config = SemesterConfig.get_config(units=request.units, semester=semester)
form = SemesterConfigForm(initial={'start_date': config.start_date(), 'end_date': config.end_date()})
form.fields['unit'].choices = unit_choices
return render(request, 'ra/semester_config.html', {'semester': semester, 'form': form})
def reappoint(request, ra_slug):
appointment = get_object_or_404(RAAppointment, slug=ra_slug, deleted=False, unit__in=request.units)
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(instance=appointment, initial={'person': appointment.person.emplid, 'reappointment': True,
'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80,
'use_hourly': appointment.use_hourly() })
raform.fields['hiring_faculty'].choices = possible_supervisors(request.units)
scholarship_choices = [("", "---------")]
for s in Scholarship.objects.filter(student__person__emplid = appointment.person.emplid):
scholarship_choices.append((s.pk, s.scholarship_type.unit.label + ": " + s.scholarship_type.name + " (" + s.start_semester.name + " to " + s.end_semester.name + ")"))
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['unit'].choices = [(u.id, u.name) for u in request.units]
raform.fields['project'].choices = [(p.id, unicode(p.project_number)) for p in Project.objects.filter(unit__in=request.units)]
raform.fields['account'].choices = [(a.id, u'%s (%s)' % (a.account_number, a.title)) for a in Account.objects.filter(unit__in=request.units)]
return render(request, 'ra/new.html', { 'raform': raform, 'appointment': appointment })
def reappoint(request, ra_slug):
appointment = get_object_or_404(RAAppointment, slug=ra_slug, deleted=False)
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(instance=appointment, initial={'person': appointment.person.emplid, 'reappointment': True,
'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80,
'use_hourly': appointment.use_hourly() })
raform.fields['hiring_faculty'].choices = possible_supervisors(request.units)
scholarship_choices = [("", "---------")]
for s in Scholarship.objects.filter(student__person__emplid = appointment.person.emplid):
scholarship_choices.append((s.pk, s.scholarship_type.unit.label + ": " + s.scholarship_type.name + " (" + s.start_semester.name + " to " + s.end_semester.name + ")"))
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['unit'].choices = [(u.id, u.name) for u in request.units]
raform.fields['project'].choices = [(p.id, unicode(p.project_number)) for p in Project.objects.filter(unit__in=request.units)]
raform.fields['account'].choices = [(a.id, u'%s (%s)' % (a.account_number, a.title)) for a in Account.objects.filter(unit__in=request.units)]
return render(request, 'ra/new.html', { 'raform': raform, 'appointment': appointment })
def reappoint(request, ra_slug):
appointment = get_object_or_404(RAAppointment, slug=ra_slug, deleted=False, unit__in=request.units)
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
raform = RAForm(instance=appointment, initial={'person': appointment.person.emplid, 'reappointment': True,
'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80,
'use_hourly': appointment.use_hourly() })
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices, program_choices = \
_appointment_defaults(request.units, emplid=appointment.person.emplid)
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
raform.fields['program'].choices = program_choices
return render(request, 'ra/new.html', { 'raform': raform, 'appointment': appointment })
def new_student(request, userid):
person = get_object_or_404(Person, find_userid_or_emplid(userid))
semester = Semester.next_starting()
semesterconfig = SemesterConfig.get_config(request.units, semester)
student = get_object_or_404(Person, find_userid_or_emplid(userid))
initial = {'person': student.emplid, 'start_date': semesterconfig.start_date(), 'end_date': semesterconfig.end_date(), 'hours': 80 }
scholarship_choices, hiring_faculty_choices, unit_choices, project_choices, account_choices =_appointment_defaults(request.units, emplid=student.emplid)
gss = GradStudent.objects.filter(person=student)
if gss:
gradstudent = gss[0]
initial['sin'] = gradstudent.person.sin()
raform = RAForm(initial=initial)
raform.fields['person'] = forms.CharField(widget=forms.HiddenInput())
raform.fields['scholarship'].choices = scholarship_choices
raform.fields['hiring_faculty'].choices = hiring_faculty_choices
raform.fields['unit'].choices = unit_choices
raform.fields['project'].choices = project_choices
raform.fields['account'].choices = account_choices
return render(request, 'ra/new.html', { 'raform': raform, 'person': person })
def create_ta_ra():
"""
Build test data for the ta and ra modules.
"""
from ta.models import CourseDescription, TAPosting, TAApplication, CoursePreference, TAContract, TACourse
from ta.models import TAKEN_CHOICES, EXPER_CHOICES
from ra.models import Account, Project, SemesterConfig, RAAppointment
from ra.models import HIRING_CATEGORY_CHOICES, HIRING_CATEGORY_DISABLED
# TAs
d = Person.objects.get(userid='dzhao')
unit = Unit.objects.get(slug='cmpt')
r1 = Role(person=d, role='TAAD', unit=unit, expiry=role_expiry)
r1.save()
r2 = Role(person=d, role='FUND', unit=unit, expiry=role_expiry)
r2.save()
s = Semester.current().next_semester()
admin = Person.objects.get(userid='dixon')
CourseDescription(unit=unit, description="Office/Marking",
labtut=False).save()
CourseDescription(unit=unit, description="Office/Marking/Lab",
labtut=True).save()
a = Account(account_number=12345,
position_number=12345,
title='MSc TA',
unit=unit)
a.save()
a = Account(account_number=12346,
position_number=12346,
title='PhD TA',
unit=unit)
a.save()
a = Account(account_number=12347,
position_number=12347,
title='External TA',
unit=unit)
a.save()
a = Account(account_number=12348,
position_number=12348,
title='Undergrad TA',
unit=unit)
a.save()
post = TAPosting(semester=s, unit=unit)
post.opens = s.start - datetime.timedelta(100)
post.closes = s.start - datetime.timedelta(20)
post.set_salary([972, 972, 972, 972])
post.set_scholarship([135, 340, 0, 0])
post.set_accounts([
Account.objects.get(account_number=12345).id,
Account.objects.get(account_number=12346).id,
Account.objects.get(account_number=12347).id,
Account.objects.get(account_number=12348).id
])
post.set_start(s.start)
post.set_end(s.end)
post.set_deadline(s.start - datetime.timedelta(10))
post.set_payperiods(7.5)
post.set_contact(admin.id)
post.set_offer_text(
"This is **your** TA öffer.\n\nThere are various conditions that are töö numerous to list here."
)
post.save()
offerings = list(post.selectable_offerings())
for p in Person.objects.filter(last_name='Grad'):
app = TAApplication(posting=post,
person=p,
category=random.choice(['GTA1', 'GTA2']),
current_program='CMPT',
sin='123456789',
base_units=random.choice([3, 4, 5]))
app.save()
will_ta = []
for i, o in enumerate(random.sample(offerings, 5)):
t = random.choice(TAKEN_CHOICES)[0]
e = random.choice(EXPER_CHOICES)[0]
cp = CoursePreference(app=app,
course=o.course,
rank=i + 1,
taken=t,
exper=e)
cp.save()
if random.random() < 0.07 * (5 - i):
will_ta.append(o)
if will_ta and random.random() < 0.75:
c = TAContract(status=random.choice(['NEW', 'OPN', 'ACC']))
c.first_assign(app, post)
c.save()
for o in will_ta:
tac = TACourse(course=o, contract=c, bu=app.base_units)
tac.description = tac.default_description()
tac.save()
# RAs
s = Semester.current()
superv = list(
m.person
for m in Member.objects.filter(role='INST').select_related('person'))
empl = list(
itertools.chain(
Person.objects.filter(last_name='Grad'),
random.sample(Person.objects.filter(last_name='Student'), 10)))
cats = [
c for c, d in HIRING_CATEGORY_CHOICES
if c not in HIRING_CATEGORY_DISABLED
]
config = SemesterConfig.get_config([unit], s)
acct = Account(account_number=12349,
position_number=12349,
title='NSERC RA',
unit=unit)
acct.save()
proj1 = Project(project_number=987654, fund_number=31, unit=unit)
proj1.save()
proj2 = Project(project_number=876543, fund_number=13, unit=unit)
proj2.save()
for i in range(30):
p = random.choice(empl)
s = random.choice(superv)
c = random.choice(cats)
freq = random.choice(['B', 'L'])
if freq == 'B':
payargs = {
'lump_sum_pay': 10000,
'biweekly_pay': 1250,
'pay_periods': 8,
'hourly_pay': 31,
'hours': 40
}
else:
payargs = {
'lump_sum_pay': 4000,
'biweekly_pay': 0,
'pay_periods': 8,
'hourly_pay': 0,
'hours': 0
}
ra = RAAppointment(person=p,
sin=123456789,
hiring_faculty=s,
unit=unit,
hiring_category=c,
project=random.choice([proj1, proj2]),
account=acct,
pay_frequency=freq,
start_date=config.start_date(),
end_date=config.end_date(),
**payargs)
ra.set_use_hourly(random.choice([True, False]))
ra.save()
return itertools.chain(
[r1, r2],
Account.objects.all(),
Project.objects.all(),
SemesterConfig.objects.all(),
RAAppointment.objects.all(),
TAPosting.objects.all(),
CourseDescription.objects.all(),
TAApplication.objects.all(),
CoursePreference.objects.all(),
TAContract.objects.all(),
TACourse.objects.all(),
)
def create_ta_ra():
"""
Build test data for the ta and ra modules.
"""
from ta.models import CourseDescription, TAPosting, TAApplication, CoursePreference, TAContract, TACourse
from ta.models import TAKEN_CHOICES, EXPER_CHOICES
from ra.models import Account, Project, SemesterConfig, RAAppointment
from ra.models import HIRING_CATEGORY_CHOICES, HIRING_CATEGORY_DISABLED
# TAs
d = Person.objects.get(userid='dzhao')
unit = Unit.objects.get(slug='cmpt')
r1 = Role(person=d, role='TAAD', unit=unit)
r1.save()
r2 = Role(person=d, role='FUND', unit=unit)
r2.save()
s = Semester.current().next_semester()
admin = Person.objects.get(userid='dixon')
CourseDescription(unit=unit, description="Office/Marking", labtut=False).save()
CourseDescription(unit=unit, description="Office/Marking/Lab", labtut=True).save()
a = Account(account_number=12345, position_number=12345, title='MSc TA', unit=unit)
a.save()
a = Account(account_number=12346, position_number=12346, title='PhD TA', unit=unit)
a.save()
a = Account(account_number=12347, position_number=12347, title='External TA', unit=unit)
a.save()
a = Account(account_number=12348, position_number=12348, title='Undergrad TA', unit=unit)
a.save()
post = TAPosting(semester=s, unit=unit)
post.opens = s.start - datetime.timedelta(100)
post.closes = s.start - datetime.timedelta(20)
post.set_salary([972,972,972,972])
post.set_scholarship([135,340,0,0])
post.set_accounts([Account.objects.get(account_number=12345).id, Account.objects.get(account_number=12346).id, Account.objects.get(account_number=12347).id, Account.objects.get(account_number=12348).id])
post.set_start(s.start)
post.set_end(s.end)
post.set_deadline(s.start - datetime.timedelta(10))
post.set_payperiods(7.5)
post.set_contact(admin.id)
post.set_offer_text("This is **your** TA offer.\n\nThere are various conditions that are too numerous to list here.")
post.save()
offerings = list(post.selectable_offerings())
for p in Person.objects.filter(last_name='Grad'):
app = TAApplication(posting=post, person=p, category=random.choice(['GTA1','GTA2']), current_program='CMPT', sin='123456789',
base_units=random.choice([3,4,5]))
app.save()
will_ta = []
for i,o in enumerate(random.sample(offerings, 5)):
t = random.choice(TAKEN_CHOICES)[0]
e = random.choice(EXPER_CHOICES)[0]
cp = CoursePreference(app=app, course=o.course, rank=i+1, taken=t, exper=e)
cp.save()
if random.random() < 0.07*(5-i):
will_ta.append(o)
if will_ta and random.random() < 0.75:
c = TAContract(status=random.choice(['NEW','OPN','ACC']))
c.first_assign(app, post)
c.save()
for o in will_ta:
tac = TACourse(course=o, contract=c, bu=app.base_units)
tac.description = tac.default_description()
tac.save()
# RAs
s = Semester.current()
superv = list(m.person for m in Member.objects.filter(role='INST').select_related('person'))
empl = list(itertools.chain(Person.objects.filter(last_name='Grad'), random.sample(Person.objects.filter(last_name='Student'), 10)))
cats = [c for c,d in HIRING_CATEGORY_CHOICES if c not in HIRING_CATEGORY_DISABLED]
config = SemesterConfig.get_config([unit], s)
acct = Account(account_number=12349, position_number=12349, title='NSERC RA', unit=unit)
acct.save()
proj1 = Project(project_number=987654, fund_number=31, unit=unit)
proj1.save()
proj2 = Project(project_number=876543, fund_number=13, unit=unit)
proj2.save()
for i in range(30):
p = random.choice(empl)
s = random.choice(superv)
c = random.choice(cats)
freq = random.choice(['B', 'L'])
if freq == 'B':
payargs = {'lump_sum_pay': 10000, 'biweekly_pay': 1250, 'pay_periods': 8, 'hourly_pay': 31, 'hours': 40}
else:
payargs = {'lump_sum_pay': 4000, 'biweekly_pay': 0, 'pay_periods': 8, 'hourly_pay': 0, 'hours': 0}
ra = RAAppointment(person=p, sin=123456789, hiring_faculty=s, unit=unit, hiring_category=c,
project=random.choice([proj1,proj2]), account=acct, pay_frequency=freq,
start_date=config.start_date(), end_date=config.end_date(),
**payargs)
ra.set_use_hourly(random.choice([True, False]))
ra.save()
return itertools.chain(
[r1, r2],
Account.objects.all(),
Project.objects.all(),
SemesterConfig.objects.all(),
RAAppointment.objects.all(),
TAPosting.objects.all(),
CourseDescription.objects.all(),
TAApplication.objects.all(),
CoursePreference.objects.all(),
TAContract.objects.all(),
TACourse.objects.all(),
)