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


Python DatabaseController.getLessonAbbreviatedNameBasedOnSchoolLessonId方法代碼示例

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


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

示例1: verifyIfLessonTimeIsUnique

# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import getLessonAbbreviatedNameBasedOnSchoolLessonId [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

示例2: getClassroomTimetable

# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import getLessonAbbreviatedNameBasedOnSchoolLessonId [as 別名]
def getClassroomTimetable(classroomLocationId):
    listOfTimetabledLessons = []
    listOfStoredRecords = DatabaseController.getClassroomLocationTimetable(classroomLocationId)
    for eachRecord in listOfStoredRecords:
        schoolLessonId = int(eachRecord[7])
        abbreviatedNameRecord = DatabaseController.getLessonAbbreviatedNameBasedOnSchoolLessonId(schoolLessonId)
        abbreviatedName = abbreviatedNameRecord[0][0]
        currentLesson = ClassesList.TimetabledLesson(int(eachRecord[0]), int(eachRecord[1]), int(eachRecord[2]), int(eachRecord[3]), int(eachRecord[4]),
                                                     int(eachRecord[5]), int(eachRecord[6]), abbreviatedName, int(eachRecord[8]), int(eachRecord[9]),
                                                     eachRecord[10])
        listOfTimetabledLessons.append(currentLesson)
    return listOfTimetabledLessons
開發者ID:ajc24,項目名稱:ProjectY4,代碼行數:14,代碼來源:DataProcessing.py

示例3: buildSchoolTimetableData

# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import getLessonAbbreviatedNameBasedOnSchoolLessonId [as 別名]
def buildSchoolTimetableData(listOfRecords):
    listOfLessons = []
    for eachRecord in listOfRecords:
        classroomLocationId = int(eachRecord[10])
        classroomNameRecord = DatabaseController.getClassroomNameBasedOnClassroomLocationId(classroomLocationId)
        classroomName = classroomNameRecord[0][0]

        schoolLessonId = int(eachRecord[7])
        abbreviatedNameRecord = DatabaseController.getLessonAbbreviatedNameBasedOnSchoolLessonId(schoolLessonId)
        abbreviatedName = abbreviatedNameRecord[0][0]
        
        currentLesson = ClassesList.TimetabledLesson(int(eachRecord[0]), int(eachRecord[1]), int(eachRecord[2]), int(eachRecord[3]), int(eachRecord[4]),
                                                     int(eachRecord[5]), int(eachRecord[6]), abbreviatedName, int(eachRecord[8]), int(eachRecord[9]),
                                                     classroomName)
        listOfLessons.append(currentLesson)
    return listOfLessons
開發者ID:ajc24,項目名稱:ProjectY4,代碼行數:18,代碼來源:DataProcessing.py


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