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