Python DatabaseController.getClassroomLocationIdBasedOnLocationIdAndClassroomId方法代码示例

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getClassroomLocationIdBasedOnLocationIdAndClassroomId [as 别名]
def updateTimetable(listOfTimetableData):
    if listOfTimetableData.__len__() > 0:
        schoolId = int(listOfTimetableData[4])
        studentId = int(listOfTimetableData[5])
        listOfStoredRecords = DatabaseController.getStudentTimetable(schoolId, studentId)
        currentStateIndex = 0
        storedStateIndex = 0
        while currentStateIndex < listOfTimetableData.__len__():
            weekdayId = int(listOfTimetableData[currentStateIndex])
            startHour = int(listOfTimetableData[currentStateIndex + 1])
            startMin = int(listOfTimetableData[currentStateIndex + 2])
            lessonLength = int(listOfTimetableData[currentStateIndex + 3])
            schoolLessonId = int(listOfTimetableData[currentStateIndex + 6])
            teacherId = int(listOfTimetableData[currentStateIndex + 7])
            locationId = int(listOfTimetableData[currentStateIndex + 8])
            classroomId = int(listOfTimetableData[currentStateIndex + 9])

            # Determine the endHour for the lesson and the classroomLocationId
            endMinutes = startMin + lessonLength
            additionalHours = 0
            while endMinutes > 60:
                additionalHours += 1
                endMinutes -= 60
            endHour = int(startHour + additionalHours)
            classroomLocationIdRecord = DatabaseController.getClassroomLocationIdBasedOnLocationIdAndClassroomId(locationId, classroomId)
            classroomLocationId = int(classroomLocationIdRecord[0][0])
            
            # Overwrite an existing timetable entry or insert a brand new one if required
            if storedStateIndex < listOfStoredRecords.__len__():
                existingRecordId = int(listOfStoredRecords[storedStateIndex][0])
                DatabaseController.updateExistingTimetableRecord(existingRecordId, weekdayId, startHour, startMin, lessonLength, endHour, schoolLessonId,
                                                                 teacherId, locationId, classroomLocationId)
                storedStateIndex += 1
            else:
                maxCountRecord = DatabaseController.countNumberOfTimetableRecords()
                maxCount = int(maxCountRecord[0][0])
                newRecordId = maxCount + 1
                DatabaseController.insertNewTimetableRecord(newRecordId, weekdayId, startHour, startMin, lessonLength, endHour, schoolLessonId, schoolId, studentId,
                                                            teacherId, locationId, classroomLocationId)
            currentStateIndex += 10

        # If there are any remaining existing lessons after all updates are complete - remove them
        while storedStateIndex < listOfStoredRecords.__len__():
            existingRecordId = int(listOfStoredRecords[storedStateIndex][0])
            DatabaseController.deleteTimetableRecord(existingRecordId)
            storedStateIndex += 1
    else:
        # No lessons currently on the timetable - delete all of the records stored in the database
        schoolId = session.get("loginId")
        studentId = session.get("studentId")
        listOfStoredRecords = DatabaseController.getStudentTimetable(schoolId, studentId)
        for eachRecord in listOfStoredRecords:
            existingRecordId = int(eachRecord[0])
            DatabaseController.deleteTimetableRecord(existingRecordId)

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getClassroomLocationIdBasedOnLocationIdAndClassroomId [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

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getClassroomLocationIdBasedOnLocationIdAndClassroomId [as 别名]
def getClassroomLocationIdForTimetable(locationId, classroomId):
    classroomLocationIdRecord = DatabaseController.getClassroomLocationIdBasedOnLocationIdAndClassroomId(locationId, classroomId)
    return int(classroomLocationIdRecord[0][0])

# 需要导入模块: import DatabaseController [as 别名]
# 或者: from DatabaseController import getClassroomLocationIdBasedOnLocationIdAndClassroomId [as 别名]
def deleteClassroomRecord(locationId, classroomId):
    DatabaseController.deleteClassroomLocationRecord(locationId, classroomId)
    classroomLocationIdRecord = DatabaseController.getClassroomLocationIdBasedOnLocationIdAndClassroomId(locationId, classroomId)
    classroomLocationId = int(classroomLocationIdRecord[0][0])
    DatabaseController.deleteTimetableRecordsBasedOnClassroomLocationId(classroomLocationId)
    manageClassroomUsage(classroomId)