def student_courses(root, student_id):
field_list = [
"course_id", "Course_name", "Course_Description", "Teacher_name",
"Credits"
]
study = select.get_specific("students", student_id, db)["Study_id"]
courses = select.get_all_from_field_with_value("course", "Study_id", study,
db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
add_table_cell(field_frame, field_list[column], 0, column)
for row in range(len(courses)):
teacher = select.get_specific("user", courses[row]["Teacher_id"], db)
for column in range(len(field_list)):
if field_list[column] == "Teacher_name":
text = "{} {}".format(teacher["First_name"],
teacher["Last_name"])
else:
text = courses[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def all_results(root):
field_list = ["exams.Exam_id", "students.Student_id"] + list(
fields["results"].keys())
field_list.remove("Student_id")
field_list.remove("Exam_id")
results = select.get_all("results", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["results"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(results)):
exam = select.get_specific("exams", results[row]["Exam_id"], db)
student = select.get_specific("user", results[row]["Student_id"], db)
for column in range(len(field_list)):
if "exams." in field_list[column]:
text = exam[field_list[column].split(".")[1]]
elif "students." in field_list[column]:
text = student["First_name"] + " " + student["Last_name"]
elif field_list[column] == "Passed":
text = "Yes" if results[row][field_list[column]] else "No"
else:
text = results[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def teacher_students(root, teacher_id):
field_list = ["Student_id", "Student_name", "study.Study_id"]
teacher_students = select.get_all_from_field_with_value(
"students", "Counselor_id", teacher_id, db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if col == "Student name":
text = col
elif "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["students"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(teacher_students)):
for column in range(len(field_list)):
if field_list[column] == "study.Study_id":
text = select.get_specific("study",
teacher_students[row]["Study_id"],
db)["study_name"]
elif field_list[column] == "Student_name":
student = select.get_specific(
"user", teacher_students[row]["Student_id"], db)
text = student["First_name"] + " " + student["Last_name"]
else:
text = teacher_students[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def all_admins(root):
field_list = ["user.First_name", "user.Last_name"] + list(
fields["administrator"].keys())
admins = select.get_all("administrator", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["administrator"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(admins)):
user = select.get_specific("user", admins[row]["Admin_id"], db)
for column in range(len(field_list)):
if "." in field_list[column]:
text = user[field_list[column].split(".")[1]]
else:
text = admins[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def all_teachers(root):
field_list = ["user.First_name", "user.Last_name"] + list(
fields["teachers"].keys())
teachers = select.get_all("teachers", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["teachers"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(teachers)):
user = select.get_specific("user", teachers[row]["Teacher_id"], db)
for column in range(len(field_list)):
if "." in field_list[column]:
text = user[field_list[column].split(".")[1]]
elif field_list[column] == "Studycounselor":
text = "Yes" if teachers[row][field_list[column]] else "No"
else:
text = teachers[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def all_exams(root):
field_list = ["course.Course_name"] + list(fields["exams"].keys())
field_list.remove("Course_id")
exams = select.get_all("exams", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["exams"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(exams)):
course = select.get_specific("course", exams[row]["Course_id"], db)
for column in range(len(field_list)):
if "course." in field_list[column]:
text = course[field_list[column].split(".")[1]]
elif field_list[column] == "Resit":
text = "Yes" if exams[row][field_list[column]] else "No"
else:
text = exams[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def student_study_counselor(root, student_id):
field_list = ["teacher_name", "Phone_number", "email"]
field_frame = tk.Frame(root)
counselor = select.get_specific("students", student_id, db)["Counselor_id"]
teacher = select.get_specific("user", counselor, db)
for column in range(len(field_list)):
add_table_cell(field_frame, field_list[column], 0, column)
for column in range(len(field_list)):
if field_list[column] == "teacher_name":
text = "{} {}".format(teacher["First_name"], teacher["Last_name"])
else:
text = teacher[field_list[column]]
add_table_cell(field_frame, text, 1, column)
return field_frame
def all_students(root):
field_list = [
"user.First_name", "user.Last_name", "study.study_name",
"teachers.Teacher_id"
] + list(fields["students"].keys())
field_list.remove("Study_id")
field_list.remove("Counselor_id")
students = select.get_all("students", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
col = field_list[column]
if "." in col:
col = col.split(".")
text = fields[col[0]][col[1]]["text"]
else:
text = fields["students"][col]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(students)):
user = select.get_specific("user", students[row]["Student_id"], db)
study = select.get_specific("study", students[row]["Study_id"], db)
teacher = select.get_specific("user", students[row]["Counselor_id"],
db)
for column in range(len(field_list)):
if "user." in field_list[column]:
text = user[field_list[column].split(".")[1]]
elif "study." in field_list[column]:
text = study[field_list[column].split(".")[1]]
elif "teachers." in field_list[column]:
text = teacher["First_name"] + " " + teacher["Last_name"]
else:
text = students[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def all_courses(root):
field_list = list(fields["course"].keys())
courses = select.get_all("course", db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
text = fields["course"][field_list[column]]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(courses)):
study = select.get_specific("study", courses[row]["Study_id"], db)
teacher = select.get_specific("user", courses[row]["Teacher_id"], db)
for column in range(len(field_list)):
if "study." in field_list[column]:
text = study[field_list[column].split(".")[1]]
elif "teacher." in field_list[column]:
text = teacher["First_name"] + " " + teacher["Last_name"]
else:
text = courses[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame
def teacher_students_results(root, teacher_id):
field_list = ["Student_id", "Student_name", "Exam_id", "Grade", "Passed"]
teacher_students = select.get_all_from_field_with_value(
"students", "Counselor_id", teacher_id, db)
teacher_student_ids = [
student["Student_id"] for student in teacher_students
]
field_frame = tk.Frame(root)
for column in range(len(field_list)):
add_table_cell(field_frame, field_list[column], 0, column)
teacher_students_results = {}
for student_id in teacher_student_ids:
teacher_students_results[
student_id] = select.get_all_from_field_with_value(
"results", "Student_id", student_id, db)
current_row = 1
for student in teacher_students_results:
student_user = select.get_specific("user", student, db)
for row in range(len(teacher_students_results[student])):
for column in range(len(field_list)):
if field_list[column] == "Student_name":
text = student_user["First_name"] + " " + student_user[
"Last_name"]
elif field_list[column] == "Passed":
text = "Yes" if teacher_students_results[student][row][
field_list[column]] else "No"
else:
text = teacher_students_results[student][row][
field_list[column]]
add_table_cell(field_frame, text, current_row, column)
current_row += 1
return field_frame
def teacher_courses(root, teacher_id):
field_list = ["Course_name", "Course_Description", "Study_id", "course_id"]
teacher_courses = select.get_all_from_field_with_value(
"course", "Teacher_id", teacher_id, db)
field_frame = tk.Frame(root)
for column in range(len(field_list)):
text = fields["course"][field_list[column]]["text"]
add_table_cell(field_frame, text, 0, column)
for row in range(len(teacher_courses)):
for column in range(len(field_list)):
if field_list[column] == "Study_id":
text = select.get_specific(
"study", teacher_courses[row][field_list[column]],
db)["study_name"]
else:
text = teacher_courses[row][field_list[column]]
add_table_cell(field_frame, text, row + 1, column)
return field_frame