def adminRoomAdd():
if current_user.admin:
form = RoomForm()
filenames = []
facilities = [
'Microphone', 'DVD Player', 'Voting System', 'Interactive Monitor',
'Slide Projector', 'Laptop Connection', 'Split Screen'
]
if request.method == 'POST':
uploaded_files = request.files.getlist("file[]")
for file in uploaded_files:
filename = secure_filename(file.filename)
if filename == '':
return redirect(url_for('adminRoomAdd'))
else:
file.save(
os.path.join(app.config['UPLOAD_FOLDER'], filename))
filenames.append(filename)
roomLists = models.Room.query.all()
if form.validate_on_submit():
listOfFaclilties = ', '.join(request.form.getlist('facilities'))
listOfImages = ' '.join(filenames)
for room in roomLists:
if room.enabled == False and room.name == form.name.data:
room.enabled = True
room.city = form.city.data
room.address = form.address.data
room.roomType = form.roomType.data
room.capacity = form.capacity.data
room.facilities = listOfFaclilties
room.accessibility = form.accessibility.data
room.roomImage = listOfImages
db.session.commit()
return redirect(url_for('adminRoom'))
elif room.name == form.name.data:
flash('There is same room name on list')
break
else:
newRoom = models.Room(
name=form.name.data,
city=form.city.data,
capacity=form.capacity.data,
roomType=form.roomType.data,
address=form.address.data,
facilities=listOfFaclilties,
accessibility=form.accessibility.data,
roomImage=listOfImages,
enabled=True)
db.session.add(newRoom)
db.session.commit()
flash('New Room registered!')
return redirect(url_for('adminRoom'))
return render_template('adminRoomAdd.html',
title='Room management',
rooms=models.Room.query.filter_by(enabled=True),
facilities=facilities,
form=form)
def newRoom(r):
try:
r = models.Room(name=r.name, scheduled=r.scheduled, thermal_mass=r.thermal_mass, \
thermal_loss=r.thermal_loss, floorheating_mode=r.floorheating_mode)
db.session.add(r)
db.session.commit()
print('added room {}'.format(r.name))
except Exception as e:
db.session.rollback()
#print(str(e))
print('newRoom : {} bestaat al'.format(r.name))
def addRoom():
form = room_details.Rooms()
if form.validate_on_submit():
room = models.Room(
number=form.number.data,
type=form.type.data,
availability=True,
)
# Insert the room in the database
db.session.add(room)
db.session.commit()
flash('added room details sucessfully.', 'positive')
return redirect(url_for('index'))
return render_template('room/details.html', form=form, title='Room Details')
def createRooms():
names = ['RSLT03', 'RSLT18']
cities = ['Glasgow', 'Leeds', 'London']
streets = ['High Street', 'Station Road']
types = ['Lecture Theatre', 'Seminar Room', 'Teaching Space', 'Computer Cluster']
facilities = ['Microphone', 'DVD Player', 'Voting System', 'Interactive Monitor', 'Slide Projector', 'Laptop Connection', 'Split Screen']
paths = ['rslt03.jpg', 'rslt18.jpg']
boolValues = [True, False]
for i in range(0,2):
room = models.Room(name=names[i],
city=cities[i%3],
address=str(random.randrange(1,50))+' '+streets[i],
roomType=types[i%4],
capacity=(10+i),
facilities=facilities[i],
accessibility=boolValues[i%2],
roomImage=paths[i],
enabled=True)
db.session.add(room)
db.session.commit()
def fill_her_up():
'''fills the database with data'''
room_number = 'P235'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='15:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='17:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='12:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='15:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='17:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='12:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='15:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='12:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='13:00', end_time='14:00'))
room_number = 'P234'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='09:00', end_time='10:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='11:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='13:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='10:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='14:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='12:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='10:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='15:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='09:00', end_time='16:00'))
room_number = 'P233'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='09:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='13:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='09:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='14:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='17:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='13:00', end_time='15:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='10:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='14:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='09:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='14:00', end_time='15:00'))
room_number = 'P230'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='11:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='13:00', end_time='15:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='16:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tueday', start_time='10:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tueday', start_time='14:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='13:30', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='13:00', end_time='14:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='15:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='09:00', end_time='15:00'))
room_number = 'P227'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='11:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='10:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='14:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='09:00', end_time='14:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='15:00', end_time='16:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='09:00', end_time='15:00'))
room_number = 'P202'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='09:00', end_time='10:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='11:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='13:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='09:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='18:00', end_time='19:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='09:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='09:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='fruday', start_time='09:00', end_time='16:00'))
room_number = 'P203'
db.session.add(models.Room(room_number=room_number))
db.session.flush() # this lets us magically get the primary key without committing the db session
room = models.Room.get_by_room_number(room_number)
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='09:00', end_time='10:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='11:00', end_time='12:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='13:00', end_time='15:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='monday', start_time='16:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='09:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='tuesday', start_time='14:00', end_time='18:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='09:00', end_time='10:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='wednesday', start_time='11:00', end_time='14:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='12:00', end_time='14:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='thursday', start_time='15:00', end_time='17:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='09:00', end_time='13:00'))
db.session.add(models.Timetable(room_id=room.room_id, day='friday', start_time='14:00', end_time='15:00'))
db.session.commit()