def droptables(): # Drops all the data we have currently. deleteAll_Password = '******' deleteAll_ExceptUsers = 'delete' if request.method == 'POST' and request.form['verify'] == deleteAll_Password: db.drop_all() db.create_all() createDefaultAccounts() createSampleGuests() createSampleBuildings() createSampleRooms() print("TABLES REBUILT") return render('basic.html',title="Tables erased.",content="Data has been reset") elif request.method == 'POST' and request.form['verify'] == deleteAll_ExceptUsers: db.drop_all(bind=Reservation) db.create_all() createDefaultAccounts() print("TABLES REBUILT") return render('basic.html',title="Tables erased.",content="SOME data has been reset") else: content = 'Type the password to verify. <form action="/droptables" method="POST">' content += '<input type="text" name="verify">' content += '<input type="submit" value="Delete All Data">' return render('basic.html',title="Drop Table Verification",content=content)
def page_create_all(): try: db.drop_all() db.create_all() createDefaultAccounts() db.session.add(Building(name="Miller", numfloors=8, status=CONST.ready_status, description="Contains numerous two person rooms and two elevators.", notes="This building is available for the summer.")) db.session.add(Building(name="Dieseth", numfloors=8, status=CONST.ready_status, description="Contains numerous two person rooms and a single elevator.", notes="This building is available for the summer.")) db.session.add(Building(name="Brandt", numfloors=5, status=CONST.ready_status, description="First year hall that has both three person and two person rooms.", notes="This building is used for parents for graduation and some camps.")) db.session.add(Building(name="Farwell", numfloors=8, status=CONST.ready_status, description="Rooms are set up and organized around central rooms.", notes="This building is available for the summer school students.")) db.session.add(Building(name="Larsen", numfloors=4, status=CONST.inactive_status, description="Larsen has heaters in each room and contains a wardrobe in each room as well.", notes="This building is unavailable.")) db.session.add(Building(name="Ylvisaker", numfloors=5, status=CONST.ready_status, description="First year hall that has numerous two person rooms. The hallways are a bit smaller here.", notes="This building is available for the summer.")) db.session.add(Building(name="Olson", numfloors=3, status=CONST.ready_status, description="Olson has many two person rooms and suites that are two person rooms with a central room between those two.", notes="This building is available for the summer.")) db.session.commit() for j in range(1, 16): db.session.add(Room(roomnumber= j, buildingID='3', capacity='2', description="Room in Brandt", status=CONST.ready_status, notes="Groud Floor")) for i in range(1, 9): for j in range(1, 31): db.session.add(Room(roomnumber=(i * 100 + j), buildingID='1', capacity='2', description="Room in Miller", status=CONST.ready_status, notes="")) db.session.add(Room(roomnumber=(i * 100 + j), buildingID='2', capacity='2', description="Room in Dieseth", status=CONST.ready_status, notes="")) db.session.add(Room(roomnumber=(i * 100 + j), buildingID='4', capacity='2', description="Room in Farwell", status=CONST.ready_status, notes="")) if i < 5: db.session.add(Room(roomnumber=(i * 100 + j), buildingID='3', capacity='2', description="Room in Brandt", status=CONST.ready_status, notes="")) db.session.add(Room(roomnumber=(i * 100 + j + 30), buildingID='3', capacity='3', description="Room in Brandt", status=CONST.ready_status, notes="Three person room")) db.session.add(Room(roomnumber=(i * 100 + j), buildingID='5', capacity='2', description="Room in Larsen", status=CONST.inactive_status, notes="")) if i != 4: db.session.add(Room(roomnumber=(i * 100 + j), buildingID='7', capacity='4', description="Room in Olson", status=CONST.ready_status, notes="")) db.session.add(Room(roomnumber=(i * 100 + j), buildingID='6', capacity='2', description="Room in Ylvi", status=CONST.ready_status, notes="")) db.session.commit() fnlist = ["Bruce", "Tom", "Harry", "David", "Henry", "Thomas", "Isaac", "Katie", "Susan", "Peter", "Kelly", "Emilay", "Alahna", "Morgan", "Neil", "Kierra", "Leah", "Lucia", "Marissa", "Melissa", "Aidan"] lnlist = ["Bennett", "Dhondup", "Stekel", "Miller", "Lee", "Ranum", "Newton", "Smith", "Brown", "Davidson", "Robinson", "Schroeder", "Keil", "Mortenson", "Anderson", "Blackstad", "Williams", "Holte", "Wales", "Hrdlicka", "Cook"] hatlist = ["Beanie", "Coonskin Hat", "Top Hat", "Sombrero", "Trucker Hat"] for i in range(0, len(fnlist)): for j in range(0, len(lnlist)): db.session.add(Guest(fnlist[i], lnlist[j], lnlist[j][:4].lower() + fnlist[i][:2].lower() + "*****@*****.**", "563" + "-" + str(495-i*7) + "-" + str(9321 - j*17), str(i*100 + j * 10 + j%10) + " College Drive, Decorah IA", payment=(i * 10 + j), notes="Wears a " + hatlist[i%len(hatlist)])) #still need to add reservations db.session.commit() from RoomReserve.admin.rooms import getRoomByID myiter = 0 for i in range(1, len(fnlist)*len(lnlist)): #change the month below to 5 for when we present myiter += 1 while getRoomByID(myiter).status == CONST.inactive_status: myiter += 1 x = int(i%20+1) mydate = date(2016, 5, x) mydate2 = mydate + timedelta(days=(randint(1, 30))) if datetime.today().date() < mydate: mystatus = CONST.ready_status else: if datetime.today().date() < mydate2: mystatus = CONST.checkedin_status getRoomByID(myiter).set_status(CONST.occupied_status) else: mystatus = CONST.checkedout_status getRoomByID(myiter).set_status(CONST.unclean_status) db.session.add(Reservation(i , 1, myiter, mydate, mydate2, mystatus, "Beds need lofting.")) db.session.commit() return redirect(url_for("page_rooms")) except: print("Hit the except statement") return render("basic.html", content=str(traceback.format_exc()).replace('\n', '<br>'))