def getBuildingHours(): connection, cursor = connect() cursor.execute("SELECT * FROM 'buildinghours';") building_hours_list = [] for row in cursor: building_hours = BuildingHours() building_hours.inflate(row) building_hours_list.append(building_hours) return building_hours_list
def save(): hours = BuildingHours() hours._id = request.POST.get('id') hours._name = request.POST.get('name') hours._days[0] = False if request.POST.get('sunday') is None else True hours._days[1] = False if request.POST.get('monday') is None else True hours._days[2] = False if request.POST.get('tuesday') is None else True hours._days[3] = False if request.POST.get('wednesday') is None else True hours._days[4] = False if request.POST.get('thursday') is None else True hours._days[5] = False if request.POST.get('friday') is None else True hours._days[6] = False if request.POST.get('saturday') is None else True hours._opentime = int(request.POST.get('openhour')) hours._closetime = int(request.POST.get('closehour')) if (hours._id == 'None'): database.save(hours) else: database.updateHours(hours)