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)
# print(test_stud)
# test_stud.save()
#
# data_dict = {'roll':'12334', 'name':'4564dfg'}
# #Student.create(**data_dict)
# studentDAO = StudentDAO()
# studentDAO.createOrUpdateModel(studentDAO.dictionaryToModel(data_dict))
# print([student.name for student in Student.select()])
if (read_flag):
csv_reader = CsvDatabaseReader(*fieldnames_read)
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()
