本文整理汇总了Python中DatabaseController.getTeacherLessonsWithinTimeSlot方法的典型用法代码示例。如果您正苦于以下问题：Python DatabaseController.getTeacherLessonsWithinTimeSlot方法的具体用法？Python DatabaseController.getTeacherLessonsWithinTimeSlot怎么用？Python DatabaseController.getTeacherLessonsWithinTimeSlot使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DatabaseController的用法示例。
在下文中一共展示了DatabaseController.getTeacherLessonsWithinTimeSlot方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: verifyIfTeacherIsFreeAtThisTime
# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getTeacherLessonsWithinTimeSlot [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