当前位置: 首页>>代码示例>>Python>>正文


Python DatabaseController.getWeekdayNameById方法代码示例

本文整理汇总了Python中DatabaseController.getWeekdayNameById方法的典型用法代码示例。如果您正苦于以下问题:Python DatabaseController.getWeekdayNameById方法的具体用法?Python DatabaseController.getWeekdayNameById怎么用?Python DatabaseController.getWeekdayNameById使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DatabaseController的用法示例。


在下文中一共展示了DatabaseController.getWeekdayNameById方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。

示例1: verifyIfTeacherIsFreeAtThisTime

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getWeekdayNameById [as 别名]
def verifyIfTeacherIsFreeAtThisTime(teacherId, weekdayId, studentId, lessonStartTime, lessonEndTime, startHour, endHour, startMin, timetableStartHour):
    allTeacherLessons = DatabaseController.getTeacherLessonsWithinTimeSlot(teacherId, weekdayId, studentId, startHour, endHour)
    errorString = ""
    for eachLesson in allTeacherLessons:
        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]
            teacherNameRecord = DatabaseController.getPersonNameBasedOnTeacherId(teacherId)
            teacherFirstName = teacherNameRecord[0][0]
            teacherSurname = teacherNameRecord[0][1]

            currentErrorMessage = "Cannot schedule " + teacherFirstName[0:1] + ". " + teacherSurname + " 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 teacher has already been scheduled elsewhere during this lessons time frame.\n\n"
            errorString += currentErrorMessage
    return errorString
开发者ID:ajc24,项目名称:ProjectY4,代码行数:36,代码来源:ValidationProcessing.py

示例2: verifyIfLessonTimeIsUnique

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getWeekdayNameById [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

示例3: verifyIfClassroomIsFreeAtThisTime

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getWeekdayNameById [as 别名]
def verifyIfClassroomIsFreeAtThisTime(schoolId, weekdayId, studentId, locationId, classroomId, lessonStartTime, lessonEndTime, startHour,
                                      endHour, startMin, timetableStartHour):
    classroomLocationIdRecord = DatabaseController.getClassroomLocationIdBasedOnLocationIdAndClassroomId(locationId, classroomId)
    classroomLocationId = int(classroomLocationIdRecord[0][0])
    allClassroomLessons = DatabaseController.getClassroomLessonsWithinTimeSlot(classroomLocationId, weekdayId, studentId, startHour, endHour)
    errorString = ""
    for eachLesson in allClassroomLessons:
        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]
            classroomNameRecord = DatabaseController.getClassroomNameBasedOnIdAndLocation(locationId, classroomId)
            classroomName = classroomNameRecord[0][0]
    
            currentErrorMessage = "The lesson scheduled on " + weekdayName + " at "
            if startHour < 10:
                currentErrorMessage += "0" + str(startHour) + ":"
            else:
                currentErrorMessage += str(startHour) + ":"
            if startMin < 10:
                currentErrorMessage += "0" + str(startMin) + " "
            else:
                currentErrorMessage += str(startMin) + " "
            currentErrorMessage += "cannot be scheduled.\n"
            currentErrorMessage += "The classroom " + classroomName + " is unavailable during this lessons time frame.\n\n"
            errorString += currentErrorMessage
    return errorString
开发者ID:ajc24,项目名称:ProjectY4,代码行数:39,代码来源:ValidationProcessing.py


注:本文中的DatabaseController.getWeekdayNameById方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。