本文整理匯總了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