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()