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