def getUser(net_id):
user = sess.query(Users)\
.filter(Users.net_id == net_id)\
.first()
if user is None:
print("it tis none")
user = Users(net_id=net_id,
contact=net_id + '@princeton.edu',
admin=False)
sess.add(user)
sess.commit()
return user
latitude=40.3496224,
longitude=-74.6526984)
# @40.3423081,-74.6596026
group1 = Groups(open_time=time(8, 00, 00), close_time=time(5, 00, 00))
group2 = Groups(open_time=time(8, 00, 00), close_time=time(20, 00, 00))
room1 = Rooms(building=firestone, room_name='101', group=group1)
room2 = Rooms(building=frist, room_name='102', group=group2)
room3 = Rooms(building=lewis, room_name='103', group=group1)
room4 = Rooms(building=firestone, room_name='104', group=group1)
room5 = Rooms(building=sherred, room_name='006', group=group2)
room6 = Rooms(building=philly, room_name='312', group=group1)
paul = Users(net_id="pe5", contact='*****@*****.**', admin=True)
bob = Users(net_id="rdondero", contact='*****@*****.**', admin=True)
saishaa = Users(net_id="saishaa", contact="*****@*****.**", admin=True)
suki = Users(net_id="sukiy", contact="*****@*****.**", admin=True)
amy = Users(net_id="jyxu", contact="*****@*****.**", admin=True)
jeanna = Users(net_id="jmjoseph", contact="*****@*****.**", admin=True)
event1 = Events(user=paul,
event_title="Paul's birthday",
start_time=datetime(2020, 11, 28, 23, 55, 59, 342380),
end_time=datetime(2020, 11, 29, 23, 55, 59, 0),
room=room1,
passed=False)
event2 = Events(user=saishaa,
