本文整理匯總了Python中DatabaseController.setOpeningHoursTimeId方法的典型用法代碼示例。如果您正苦於以下問題:Python DatabaseController.setOpeningHoursTimeId方法的具體用法?Python DatabaseController.setOpeningHoursTimeId怎麽用?Python DatabaseController.setOpeningHoursTimeId使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DatabaseController
的用法示例。
在下文中一共展示了DatabaseController.setOpeningHoursTimeId方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Python代碼示例。
示例1: updateSchoolOpeningHours
# 需要導入模塊: import DatabaseController [as 別名]
# 或者: from DatabaseController import setOpeningHoursTimeId [as 別名]
def updateSchoolOpeningHours(schoolId, weekdayId, openOrClosed, openingTime, closingTime):
timeRecord = DatabaseController.getOpeningHoursTimeId(schoolId, weekdayId)
idRecord = DatabaseController.getOpeningHoursId(schoolId, weekdayId)
timeValue = int(timeRecord[0][0])
idValue = int(idRecord[0][0])
if openOrClosed == "open":
if timeValue == 0:
countRecord = DatabaseController.countRecordsInTimeTable()
countValue = int(countRecord[0][0])
newTimeId = countValue + 1
DatabaseController.insertNewTimeRecord(newTimeId, openingTime, closingTime, 0)
DatabaseController.setOpeningHoursTimeId(idValue, newTimeId)
else:
DatabaseController.updateExistingTimeRecord(timeValue, openingTime, closingTime)
else:
if timeValue > 0:
DatabaseController.deleteTimeRecord(timeValue)
DatabaseController.setOpeningHoursTimeId(idValue, 0)
DatabaseController.deleteTimetableRecordsByDay(schoolId, weekdayId)