本文整理汇总了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