Python StudentDAOの例

コード例 #1

ファイル: gpa_calculator.py プロジェクト: siddhanthgupta/pythondbmanager

 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)

コード例 #2

 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)

コード例 #3

ファイル: database_runner.py プロジェクト: siddhanthgupta/pythondbmanager

# 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):

コード例 #4

ファイル: website_gpa_crawler.py プロジェクト: siddhanthgupta/pythondbmanager

        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()

コード例 #5

# 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()

コード例 #6

ファイル: website_gpa_crawler.py プロジェクト: siddhanthgupta/pythondbmanager

            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()