當前位置: 首頁>>代碼示例>>Python>>正文


Python DatabaseController.getStudentLessonsWithinTimeSlot方法代碼示例

本文整理匯總了Python中DatabaseController.getStudentLessonsWithinTimeSlot方法的典型用法代碼示例。如果您正苦於以下問題:Python DatabaseController.getStudentLessonsWithinTimeSlot方法的具體用法?Python DatabaseController.getStudentLessonsWithinTimeSlot怎麽用?Python DatabaseController.getStudentLessonsWithinTimeSlot使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在DatabaseController的用法示例。


在下文中一共展示了DatabaseController.getStudentLessonsWithinTimeSlot方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Python代碼示例。

示例1: verifyIfLessonTimeIsUnique

# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import getStudentLessonsWithinTimeSlot [as 別名]
def verifyIfLessonTimeIsUnique(schoolId, studentId, weekdayId, schoolLessonId, lessonStartTime, lessonEndTime, startHour, endHour, startMin, timetableStartHour):
    allLessonsRecord = DatabaseController.getStudentLessonsWithinTimeSlot(schoolId, studentId, weekdayId, startHour, endHour)
    errorString = ""
    for eachLesson in allLessonsRecord:
        nextStartHour = int(eachLesson[0])
        nextStartMin = int(eachLesson[1])
        nextLessonLength = int(eachLesson[2])

        nextStartTime = ((nextStartHour - timetableStartHour) * 60) + nextStartMin
        nextEndTime = nextStartTime + nextLessonLength

        lessonClash = checkIfLessonsAreCollidingInTimeFrame(lessonStartTime, lessonEndTime, nextStartTime, nextEndTime)
        
        # If lessons collide - process the error message
        if lessonClash == True:
            currentErrorMessage = ""
            weekdayNameRecord = DatabaseController.getWeekdayNameById(weekdayId)
            weekdayName = weekdayNameRecord[0][0]
            lessonNameRecord = DatabaseController.getLessonAbbreviatedNameBasedOnSchoolLessonId(schoolLessonId)
            lessonName = lessonNameRecord[0][0]

            currentErrorMessage = "Cannot schedule lesson '" + lessonName + "' on " + weekdayName + " at "
            if startHour < 10:
                currentErrorMessage += "0" + str(startHour) + ":"
            else:
                currentErrorMessage += str(startHour) + ":"
            if startMin < 10:
                currentErrorMessage += "0" + str(startMin) + ".\n"
            else:
                currentErrorMessage += str(startMin) + ".\n"
            currentErrorMessage += "This lessons duration clashes with another lesson scheduled to this student by another school.\n\n" 
            errorString += currentErrorMessage
    return errorString
開發者ID:ajc24,項目名稱:ProjectY4,代碼行數:35,代碼來源:ValidationProcessing.py


注:本文中的DatabaseController.getStudentLessonsWithinTimeSlot方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。