def read_grades(query_key, data): if not Utils.check_whitespace(data): if query_key == 'Course ID': sql = f""" select course_name, courses.course_id, user_id, name, students.school, grade from students, courses, grades where (user_id,grade) in (select student_id,grade from grades where course_id ={data} ) and courses.course_id = {data} """ else: sql = f""" select course_name, courses.course_id, user_id, name, students.school, grade from students, courses, grades where (courses.course_id, grade) in (select course_id,grade from grades where student_id = '{data}' ) and students.user_id = '{data}' """ try: Database.initialize() grades_data = Database.query(sql) return grades_data except pymysql.Error as error: raise error finally: Database.close() else: raise ValueError('Please input data!')
def init_teacher_table(self): self.teacher_tableWidget.setRowCount(0) self.teacher_tableWidget.insertRow(0) text = self.teacher_id_lineEdit.text() teacher_id = text if text and not Utils.check_whitespace( text) else None text = self.teacher_name_lineEdit.text() teacher_name = text if text and not Utils.check_whitespace( text) else None text = self.position_lineEdit.text() position = text if text and not Utils.check_whitespace(text) else None teachers_data = Teacher.read_teachers( self.admin_MainWindow.user.school, teacher_id, teacher_name, position) self.init_table(self.teacher_tableWidget, 'teacher', teachers_data, 8)
def init_student_table(self): self.student_tableWidget.setRowCount(0) self.student_tableWidget.insertRow(0) text = self.department_lineEdit.text() department = text if text and not Utils.check_whitespace( text) else None text = self.class_lineEdit.text() class_name = text if text and not Utils.check_whitespace( text) else None text = self.student_id_lineEdit.text() student_id = text if text and not Utils.check_whitespace( text) else None text = self.student_name_lineEdit.text() student_name = text if text and not Utils.check_whitespace( text) else None students_data = Student.read_students( self.admin_MainWindow.user.school, department, class_name, student_id, student_name) self.init_table(self.student_tableWidget, 'student', students_data, 8)
def init_course_talbe(self): self.course_tableWidget.setRowCount(0) self.course_tableWidget.insertRow(0) text = self.course_id_lineEdit.text() course_id = text if text and not Utils.check_whitespace(text) else None text = self.course_name_lineEdit.text() course_name = text if text and not Utils.check_whitespace( text) else None text = self.course_teacher_name_lineEdit.text() teacher_name = text if text and not Utils.check_whitespace( text) else None text = self.course_teacher_id_lineEdit.text() teacher_id = text if text and not Utils.check_whitespace( text) else None courses_data = Course.read_courses(self.admin_MainWindow.user.school, course_id, course_name, teacher_name, teacher_id) self.init_table(self.course_tableWidget, 'course', courses_data, 2)