def getStudentsByBatch(self, department, year_of_passing, course): try: list_students = [student for student in Student.select().where((Student.department == department) & (Student.batch_passing_year == year_of_passing) & (Student.course == course))] except: print("Exception occurred") traceback.print_exc() return [] return list_students
def getAllStudents(self): try: list_students = [student for student in Student.select()] except Exception: print("Exception occurred.") traceback.print_exc() return None return list_students
def updateCGPAForAllStudents(): for student in Student.select(): cgpa = GPACalculator.calculateGpaForStudent(student) update_student = Student() update_student.roll = student.roll update_student.cgpa = cgpa studentDAO = StudentDAO() if(cgpa is not None): studentDAO.createOrUpdateModel(update_student)
def updateCGPAForAllStudents(): for student in Student.select(): cgpa = GPACalculator.calculateGpaForStudent(student) update_student = Student() update_student.roll = student.roll update_student.cgpa = cgpa studentDAO = StudentDAO() if (cgpa is not None): studentDAO.createOrUpdateModel(update_student)
def getStudentsByBatch(self, department, year_of_passing, course): try: list_students = [ student for student in Student.select().where( (Student.department == department) & (Student.batch_passing_year == year_of_passing) & (Student.course == course)) ] except: print("Exception occurred") traceback.print_exc() return [] return list_students
dict_list = csv_reader.csvToDictionaryList(csv_read_filename) print(dict_list) for dict in dict_list: print(dict) studentDAO = StudentDAO() studentDAO.createOrUpdateModel(studentDAO.dictionaryToModel(dict)) # for student in Student.select(): # cgpa = GPACalculator.calculateGpaForStudent(student) #GPACalculator.updateCGPAForAllStudents() # studentDAO = StudentDAO() # list_students = studentDAO.getStudentsByBatch("CSE", "2016", "BE")#[student for student in Student.select()] # list_students_2 = studentDAO.getStudentsByBatch("IT", "2016", "BE") # list_students = list_students + list_students_2 # for student in list_students: # print(student.name, student.roll) if(write_flag): studentDAO = StudentDAO() list_students = [student for student in Student.select().order_by(Student.course, Student.department, Student.batch_passing_year, Student.roll)] #print(list_students) csvDatabaseWriter = CsvDatabaseWriter(*fieldnames_write) print(fieldnames_write) list_students_dictionaries = [student.__dict__.get('_data') for student in list_students] #print(list_students_dictionaries) csvDatabaseWriter.dictionaryListToCsv(csv_write_filename, *list_students_dictionaries)
studentDAO = StudentDAO() studentDAO.createOrUpdateModel(studentDAO.dictionaryToModel(dict)) # for student in Student.select(): # cgpa = GPACalculator.calculateGpaForStudent(student) #GPACalculator.updateCGPAForAllStudents() # studentDAO = StudentDAO() # list_students = studentDAO.getStudentsByBatch("CSE", "2016", "BE")#[student for student in Student.select()] # list_students_2 = studentDAO.getStudentsByBatch("IT", "2016", "BE") # list_students = list_students + list_students_2 # for student in list_students: # print(student.name, student.roll) if (write_flag): studentDAO = StudentDAO() list_students = [ student for student in Student.select().order_by( Student.course, Student.department, Student.batch_passing_year, Student.roll) ] #print(list_students) csvDatabaseWriter = CsvDatabaseWriter(*fieldnames_write) print(fieldnames_write) list_students_dictionaries = [ student.__dict__.get('_data') for student in list_students ] #print(list_students_dictionaries) csvDatabaseWriter.dictionaryListToCsv(csv_write_filename, *list_students_dictionaries)