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)
