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)
# 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()
list_strong = soup.find_all("strong") for elem in list_strong: # print("item: ") # print(elem.text) x = elem.text.split(':') # print(x) if('SGPA' in x[0]): # print('yes',x[1].strip()) try: gpa_value = float(x[1].strip()) except Exception: print("Exception occurred in extracting GPA") traceback.print_exc() else: gpa_flag = True if(gpa_flag): list_td = soup.find_all("td", attrs={"align":"center", "class":"underlineresult"}) for elem in list_td: text = elem.text.strip() if(re.search("^0012105010", text)): class_roll = text if(gpa_flag and class_roll): print(exam_roll, class_roll, gpa_value) student = Student() student.roll = class_roll student.gpa5 = gpa_value studentDAO = StudentDAO() studentDAO.createOrUpdateModel(student) except Exception: print("Exception occurred") traceback.print_exc()
# 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() list_students = [
x = elem.text.split(':') # print(x) if ('SGPA' in x[0]): # print('yes',x[1].strip()) try: gpa_value = float(x[1].strip()) except Exception: print("Exception occurred in extracting GPA") traceback.print_exc() else: gpa_flag = True if (gpa_flag): list_td = soup.find_all("td", attrs={ "align": "center", "class": "underlineresult" }) for elem in list_td: text = elem.text.strip() if (re.search("^0012105010", text)): class_roll = text if (gpa_flag and class_roll): print(exam_roll, class_roll, gpa_value) student = Student() student.roll = class_roll student.gpa5 = gpa_value studentDAO = StudentDAO() studentDAO.createOrUpdateModel(student) except Exception: print("Exception occurred") traceback.print_exc()