当前位置: 首页>>代码示例>>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;未经允许,请勿转载。