def test_query_module_taken_together_specified_mod_specified_aysem(self):
'''
Tests querying the list of modules taken together
with specified module in the specified semester
'''
# Add some dummy students and modules
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Dummy 1', 'Description', 4, 'Active')
model.add_module('AAA1112', 'Dummy 2', 'Description', 4, 'Active')
model.add_student_plan('dummyYr1A', True, 'AAA1111', 'AY 17/18 Sem 2')
model.add_student_plan('dummyYr1A', True, 'AAA1112', 'AY 17/18 Sem 2')
list_of_mod_taken_together = \
model.get_mod_taken_together_with_mod_and_aysem('AAA1111', 'AY 17/18 Sem 2')
required_list = [('AAA1111', 'Dummy 1', 'AAA1112', 'Dummy 2', 1)]
assert_equal(len(list_of_mod_taken_together), len(required_list))
assert_equal(sorted(list_of_mod_taken_together), sorted(required_list))
assert_true(
self.is_count_in_non_ascending_order(list_of_mod_taken_together))
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module('AAA1111')
model.delete_module('AAA1112')
model.delete_student('dummyYr1A')
def test_query_module_taken_together_entire_list(self):
'''
Tests querying the list of modules taken together
in the same semester
'''
# Add some dummy students and modules
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Dummy 1', 'Description', 4, 'Active')
model.add_module('AAA1112', 'Dummy 2', 'Description', 4, 'Active')
model.add_module('AAA1113', 'Dummy 3', 'Description', 4, 'Active')
model.add_student_plan('dummyYr1A', True, 'AAA1111', 'AY 17/18 Sem 1')
model.add_student_plan('dummyYr1A', True, 'AAA1112', 'AY 17/18 Sem 1')
model.add_student_plan('dummyYr1A', True, 'AAA1112', 'AY 17/18 Sem 2')
model.add_student_plan('dummyYr1A', True, 'AAA1113', 'AY 17/18 Sem 2')
list_of_mod_taken_together = \
model.get_all_mods_taken_together()
assert_true(
self.is_count_in_non_ascending_order(list_of_mod_taken_together))
assert ('AAA1111', 'Dummy 1', 'AAA1112', 'Dummy 2', 'AY 17/18 Sem 1',
1) in list_of_mod_taken_together
assert ('AAA1112', 'Dummy 2', 'AAA1113', 'Dummy 3', 'AY 17/18 Sem 2',
1) in list_of_mod_taken_together
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module('AAA1111')
model.delete_module('AAA1112')
model.delete_module('AAA1113')
model.delete_student('dummyYr1A')
def test_query_module_before_internship_with_mod_after_internship(self):
'''
Tests querying the list of modules taken before internship,
in AY/Sem with people doing internship in, and
with some modules taken after or during aysem of internship
'''
# Get list of modules before internship
list_of_modules_before_internship = model.get_mod_before_intern(
self.INTERN_SEM)
# Add some dummy students and plans. They should not affect the list
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Dummy with Intern', 'Description', 4,
'Active')
model.add_module('AAA1112', 'Dummy after Intern', 'Description', 4,
'Active')
model.add_student_plan('dummyYr1A', True, 'AAA1111', self.INTERN_SEM)
model.add_student_plan('dummyYr1A', True, self.INTERN_MOD,
self.INTERN_SEM)
model.add_student_plan('dummyYr1A', True, 'AAA1112', 'AY 17/18 Sem 2')
# Get new list of modules before internship. It should remain unchanged.
new_list_of_modules_before_internship = model.get_mod_before_intern(
self.INTERN_SEM)
assert_equal(len(list_of_modules_before_internship),
len(new_list_of_modules_before_internship))
assert_equal(sorted(list_of_modules_before_internship),
sorted(new_list_of_modules_before_internship))
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module('AAA1111')
model.delete_module('AAA1112')
model.delete_student('dummyYr1A')
def test_list_students_take_module_two_focus(self):
'''
Tests querying the list of students who plan
to take a certain mod in a specified semester,
where these students have exactly 2 focus areas.
'''
# Add some modules and dummy students
model.add_student('dummyYr1A', 1)
model.add_student_focus_area('dummyYr1A', 'Database Systems',
'Computer Graphics and Games')
model.add_student_plan('dummyYr1A', True, 'CS1010', 'AY 16/17 Sem 1')
list_of_students_take_mod = \
model.get_list_students_take_module('CS1010', 'AY 16/17 Sem 1')
required_entry = [
'dummyYr1A', 1, 'Database Systems', 'Computer Graphics and Games'
]
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_student_focus_area('dummyYr1A')
model.delete_student('dummyYr1A')
assert required_entry in list_of_students_take_mod
def test_query_module_before_internship(self):
'''
Tests querying the list of modules taken before internship,
in AY/Sem with people doing internship in.
'''
# Add some modules and dummy students
required_dummy = ('AAA1111', 'Dummy for Intern', 1)
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Dummy for Intern', 'Description', 4,
'Active')
model.add_student_plan('dummyYr1A', True, 'AAA1111', 'AY 16/17 Sem 2')
model.add_student_plan('dummyYr1A', True, self.INTERN_MOD,
self.INTERN_SEM)
# Get list of modules taken before internship
list_of_modules_before_internship = model.get_mod_before_intern(
self.INTERN_SEM)
assert required_dummy in list_of_modules_before_internship
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module('AAA1111')
model.delete_student('dummyYr1A')
# Test that required dummy no longer in list
list_of_modules_before_internship = model.get_mod_before_intern(
self.INTERN_SEM)
assert required_dummy not in list_of_modules_before_internship
def test_additional_query_num_students_in_year_of_study(self):
'''
Additional tests to ensure querying number of students at each year of study
works for year 5 students as well.
'''
# Add a dummy student
model.add_student('dummyYr3A', 3)
# Get current amount of students in each year
table_of_year_of_study_with_count = \
model.get_num_students_by_yr_study()
assert_equal(
self.is_table_sorted_by_first_elem(
table_of_year_of_study_with_count), True)
# Add more students
model.add_student('dummyYr1A', 1)
model.add_student('dummyYr1B', 1)
model.add_student('dummyYr2A', 2)
model.add_student('dummyYr5A', 5)
model.delete_student('dummyYr3A')
expected_difference = [2, 1, -1, 0, 1, 0]
# Get new amount of students in each year
new_table_of_year_of_study_with_count = \
model.get_num_students_by_yr_study()
# Check if new number of students was gotten
for row_index in range(len(table_of_year_of_study_with_count)):
old_year_of_study = table_of_year_of_study_with_count[row_index]
new_year_of_study = new_table_of_year_of_study_with_count[
row_index]
assert_equal(self.num_column_for_each_year, len(new_year_of_study))
current_year = new_year_of_study[0]
current_number_of_student = new_year_of_study[1]
old_number_of_student = old_year_of_study[1]
assert_equal(
old_number_of_student + expected_difference[current_year - 1],
current_number_of_student)
# Clean up database
model.delete_student('dummyYr1A')
model.delete_student('dummyYr1B')
model.delete_student('dummyYr2A')
model.delete_student('dummyYr5A')
def test_query_oversubscribed_modules(self):
'''
Tests querying the list of oversubscribed modules.
'''
# To simulate an oversubscribed module, add a module with 0 quota,
# then add a student who wants to take the module.
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Test Module', 'Description', 4, 'Active')
model.add_student_plan('dummyYr1A', False, 'AAA1111', 'AY 17/18 Sem 1')
list_of_oversub_mod = model.get_oversub_mod()
oversubscribed_module = ('AAA1111', 'Test Module', 'AY 17/18 Sem 1',
'?', 1)
# Clean up the database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module("AAA1111")
model.delete_student('dummyYr1A')
# Test for presence of oversubscribed module
assert oversubscribed_module in list_of_oversub_mod
def test_query_module_taken_together_specified_mod(self):
'''
Tests querying the list of modules taken together
with specified module in the same semester
'''
# Add some dummy students and modules
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Dummy 1', 'Description', 4, 'Active')
model.add_module('AAA1112', 'Dummy 2', 'Description', 4, 'Active')
model.add_student_plan('dummyYr1A', True, 'AAA1111', 'AY 17/18 Sem 2')
model.add_student_plan('dummyYr1A', True, 'AAA1112', 'AY 17/18 Sem 2')
list_of_mod_taken_together = \
model.get_mod_taken_together_with('AAA1111')
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module('AAA1111')
model.delete_module('AAA1112')
model.delete_student('dummyYr1A')
assert ('AAA1111', 'Dummy 1', 'AAA1112', 'Dummy 2', 'AY 17/18 Sem 2',
1) in list_of_mod_taken_together
def test_query_oversubscribed_modules_reworked(self):
'''
Tests querying the list of oversubscribed modules.
(This test uses the reworked function)
'''
# To simulate an oversubscribed module, add a module with 0 quota,
# then add a student who wants to take the module.
oversub_handler = OversubModule()
model.add_student('dummyYr1A', 1)
model.add_module('AAA1111', 'Test Module', 'Description', 4, 'Active')
model.add_student_plan('dummyYr1A', False, 'AAA1111', 'AY 17/18 Sem 1')
list_of_oversub_mod = oversub_handler.GET("AY 17/18 Sem 1")
oversubscribed_module = ('AAA1111', 'Test Module', 'AY 17/18 Sem 1',
'-', 1, 1)
# Clean up the database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_module("AAA1111")
model.delete_student('dummyYr1A')
# Test for presence of oversubscribed module
assert oversubscribed_module in list_of_oversub_mod
def test_query_num_students_in_year_of_study_for_target_module(self):
'''
Tests querying number of students for each year of study for a target module
'''
test_module_code = "CS1010"
test_ay_sem_1 = "AY 16/17 Sem 1"
# Add some students and plans
model.add_student('dummyYr1A', 1)
model.add_student('dummyYr1B', 1)
model.add_student('dummyYr2A', 2)
model.add_student_plan('dummyYr2A', True, 'CS1010', test_ay_sem_1)
# Get current count of students taking CS1010
self.module_view_in_ay_sem_handler.load_focus_areas()
self.module_view_in_ay_sem_handler.load_student_enrollments(
test_module_code, test_ay_sem_1)
student_year_counts = self.module_view_in_ay_sem_handler.student_year_counts
# Add and remove some plans
model.add_student_plan('dummyYr1A', True, 'CS1010', test_ay_sem_1)
model.add_student_plan('dummyYr1B', True, 'CS1010', test_ay_sem_1)
model.delete_student_plan('dummyYr2A', 'CS1010', test_ay_sem_1)
# Get new count of students taking CS1010
self.module_view_in_ay_sem_handler.load_focus_areas()
self.module_view_in_ay_sem_handler.load_student_enrollments(
test_module_code, test_ay_sem_1)
new_student_year_counts = self.module_view_in_ay_sem_handler.student_year_counts
# Check if difference is as expected
assert_equal(new_student_year_counts[0] - student_year_counts[0], 2)
assert_equal(new_student_year_counts[1] - student_year_counts[1], -1)
assert_equal(new_student_year_counts[2] - student_year_counts[2], 0)
assert_equal(new_student_year_counts[3] - student_year_counts[3], 0)
assert_equal(new_student_year_counts[4] - student_year_counts[4], 0)
assert_equal(new_student_year_counts[5] - student_year_counts[5], 0)
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_all_plans_of_student('dummyYr1B')
model.delete_all_plans_of_student('dummyYr2A')
model.delete_student('dummyYr1A')
model.delete_student('dummyYr1B')
model.delete_student('dummyYr2A')
def test_query_num_students_in_focus_area_for_target_module(self):
'''
Tests querying number of students for each focus area for a target module
'''
test_module_code = "CS1010"
test_ay_sem_1 = "AY 16/17 Sem 1"
# Add some students with focus areas and plans
model.add_student('dummyYr1A', 1)
model.add_student('dummyYr1B', 1)
model.add_student('dummyYr2A', 2)
model.add_student_focus_area('dummyYr1A', 'Artificial Intelligence',
None)
model.add_student_focus_area('dummyYr1B', 'Database Systems',
'Algorithms & Theory')
model.add_student_focus_area('dummyYr2A', 'Algorithms & Theory', None)
model.add_student_plan('dummyYr1A', True, 'CS1010', test_ay_sem_1)
# Get current focus count of students taking CS1010
self.module_view_in_ay_sem_handler.load_focus_areas()
self.module_view_in_ay_sem_handler.load_student_enrollments(
test_module_code, test_ay_sem_1)
focus_area_counts = self.module_view_in_ay_sem_handler.focus_area_counts
# Add and remove some plans
model.add_student_plan('dummyYr1B', True, 'CS1010', test_ay_sem_1)
model.add_student_plan('dummyYr2A', True, 'CS1010', test_ay_sem_1)
model.delete_student_plan('dummyYr1A', 'CS1010', test_ay_sem_1)
# Get new count of students taking CS1010
self.module_view_in_ay_sem_handler.load_focus_areas()
self.module_view_in_ay_sem_handler.load_student_enrollments(
test_module_code, test_ay_sem_1)
new_focus_area_counts = self.module_view_in_ay_sem_handler.focus_area_counts
# Check if difference is as expected
assert_equal(new_focus_area_counts["Nil"] - focus_area_counts["Nil"],
0)
assert_equal(new_focus_area_counts["AT"] - focus_area_counts["AT"], 2)
assert_equal(new_focus_area_counts["AI"] - focus_area_counts["AI"], -1)
assert_equal(new_focus_area_counts["CGaG"] - focus_area_counts["CGaG"],
0)
assert_equal(new_focus_area_counts["CS"] - focus_area_counts["CS"], 0)
assert_equal(new_focus_area_counts["DS"] - focus_area_counts["DS"], 1)
assert_equal(new_focus_area_counts["MIR"] - focus_area_counts["MIR"],
0)
assert_equal(new_focus_area_counts["NaDS"] - focus_area_counts["NaDS"],
0)
assert_equal(new_focus_area_counts["PC"] - focus_area_counts["PC"], 0)
assert_equal(new_focus_area_counts["PL"] - focus_area_counts["PL"], 0)
assert_equal(new_focus_area_counts["SE"] - focus_area_counts["SE"], 0)
# Clean up database
model.delete_all_plans_of_student('dummyYr1A')
model.delete_all_plans_of_student('dummyYr1B')
model.delete_all_plans_of_student('dummyYr2A')
model.delete_student_focus_area('dummyYr1A')
model.delete_student_focus_area('dummyYr1B')
model.delete_student_focus_area('dummyYr2A')
model.delete_student('dummyYr1A')
model.delete_student('dummyYr1B')
model.delete_student('dummyYr2A')
def test_query_num_students_in_focus_area(self):
'''
Tests querying number of students for each focus area
'''
# Inject year 5 student temporarily with no focus area
model.add_student('dummyYr5A', 5)
model.add_student_focus_area('dummyYr5A', None, None)
expected_difference = {
'Have Not Indicated': -1,
'Algorithms & Theory': 0,
'Artificial Intelligence': 1,
'Computer Graphics and Games': 0,
'Computer Security': 0,
'Database Systems': 0,
'Multimedia Information Retrieval': 0,
'Networking and Distributed Systems': 0,
'Parallel Computing': 0,
'Programming Languages': 0,
'Software Engineering': 0,
'Interactive Media': 0,
'Visual Computing': 0
}
num_of_focus_area = len(expected_difference)
old_table_of_focus_area_with_count = \
model.get_num_students_by_focus_areas()
# Remove the first row which contains "Have not indicated",
# then test if the remaining is sorted by focus area
have_not_indicated_row = old_table_of_focus_area_with_count.pop(0)
assert_equal(
self.is_table_sorted_by_first_elem(
old_table_of_focus_area_with_count), True)
old_table_of_focus_area_with_count.insert(0, have_not_indicated_row)
assert_equal(len(old_table_of_focus_area_with_count),
num_of_focus_area)
model.add_student('dummyYr1A', 1)
model.add_student_focus_area('dummyYr1A', 'Artificial Intelligence',
None)
model.delete_student_focus_area('dummyYr5A')
model.delete_student('dummyYr5A')
new_table_of_focus_area_with_count = \
model.get_num_students_by_focus_areas()
#Check that get by focus area has gotten the updated values
for index_row in range(0, num_of_focus_area):
old_focus_row = old_table_of_focus_area_with_count[index_row]
new_focus_row = new_table_of_focus_area_with_count[index_row]
assert_equal(self.num_column_for_each_focus, len(old_focus_row))
old_focus_area = old_focus_row[0]
old_number_of_student = old_focus_row[1]
new_number_of_student = new_focus_row[1]
assert_equal(
expected_difference.get(old_focus_area) +
old_number_of_student, new_number_of_student)
# Clean up database
model.delete_student_focus_area('dummyYr1A')
model.delete_student('dummyYr1A')
