def on_put(self, request, response):
# TODO make sure the database is up, otherwise send status code 5xx
session_token = get_session(request)
ID = session.id_from_session(session_token)
current_student = get_student_by_id(ID)
group_id = None
if current_student:
group_id = current_student["gid"]
try:
rank = int(
request.params["rank"]) if "rank" in request.params else None
dorm_id = int(request.params["dorm_id"]
) if "dorm_id" in request.params else None
room_id = int(request.params["room_id"]
) if "room_id" in request.params else None
floor = int(
request.params["floor"]) if "floor" in request.params else None
except ValueError:
response.media = "Invalid paramaters"
return
if not group_id or not rank or not dorm_id:
response.media = "Missing paramaters"
return
sql_run_stored_proc(procs.put_group_wishlist, group_id, rank, dorm_id,
room_id, floor)
def on_put(self, request, response): # TODO make sure the database is up, otherwise send status code 5xx session_token = get_session(request) student_id = session.id_from_session(session_token) try: rank = int(get_val(request.params, "rank")) dorm_id = int(get_val(request.params, "dorm_id")) room_id = int(get_val(request.params, "room_id")) floor = int(get_val(request.params, "floor")) except ValueError: response.media = "Invalid paramaters" return except TypeError: pass if not rank or not dorm_id: response.media = "Missing paramaters" return connection = sql.SQL() connection.run_stored_proc(procs.put_student_wishlist, student_id, rank, dorm_id, room_id, floor) connection.commit()
def on_delete(self, request, response): session_token = get_session(request) sid = session.id_from_session(session_token) gid = get_val(request.params, "group_id") if gid is None: response.media = "Please provide a group id to decline" return sql_run_stored_proc(procs.decline_group_invite, sid, gid)
def on_put(self, request, response): session_token = get_session(request) params = json.loads(request.stream.read()) ID = session.id_from_session(session_token) gid = get_val(params, "group_id") if gid is None: response.media = "Need a group to accept" return sql_run_stored_proc(procs.accept_group_invite, sid, gid)
def on_get(self, request, response): session_token = get_session(request) sid = session.id_from_session(session_token) results = sql_run_stored_proc_for_multiple_items(procs.get_group_invites, sid) d = [] if results: for inv in results: d.append(models.group.Invitations(inv)) response.media = d
def on_get(self, request, response): # TODO make sure the database is up, otherwise send status code 5xx session_token = get_session(request) student_id = session.id_from_session(session_token) connection = sql.SQL() results = connection.run_stored_proc_for_multiple_items(procs.get_student_wishlist, student_id) data = [] for i in results: w = models.wishlist.Wishlist(i) data.append(w) response.media = data
def on_get(self, request, response):
session_token = get_session(request)
ID = None
try:
ID = int(get_val(request.params, "id"))
except ValueError:
response.media = "Invalid ID"
return
except TypeError:
ID = session.id_from_session(session_token)
student = get_student_by_id(ID)
response.media = student
def on_post(self, request, response): session_token = get_session(request) params = json.loads(request.stream.read()) ID = session.id_from_session(session_token) stud = get_student_by_id(ID) sid = get_val(params, "student_id") gid = stud["group_id"] if sid is None or gid is None: response.media = "Missing parameters" return sql_run_stored_proc(procs.invite_to_group, sid, gid)
def on_get(self, request, response):
# TODO make sure the database is up, otherwise send status code 5xx
session_token = get_session(request)
ID = session.id_from_session(session_token)
stud = get_student_by_id(ID)
gid = stud.info["group_id"]
results = sql_run_stored_proc_for_single_item(procs.get_group, gid)
if results:
g = group.GroupInfo(results)
response.media = g
else:
response.media = "{}"
def on_get(self, request, response):
response.media = {}
# TODO make sure the database is up, otherwise send status code 5xx
session_token = get_session(request)
ID = session.id_from_session(session_token)
stud = get_student_by_id(ID)
gid = stud.info["group_id"]
results = sql_run_stored_proc_for_multiple_items(procs.get_group_members, gid)
group_list = []
if results:
for person in results:
group_list.append(student.Student(person))
response.media = group_list
def on_delete(self, request, response): # TODO make sure the database is up, otherwise send status code 5xx session_token = get_session(request) student_id = session.id_from_session(session_token) try: rank = int(get_value(request.params, "rank")) except ValueError: response.media = "Invalid rank" return except TypeError: response.media = "Missing rank" return connection = sql.SQL() connection.run_stored_proc(procs.delete_student_wishlist, student_id, rank) connection.commit()
def on_get(self, request, response):
# TODO make sure the database is up, otherwise send status code 5xx
session_token = get_session(request)
ID = session.id_from_session(session_token)
current_student = get_student_by_id(ID)
group_id = None
if current_student:
group_id = int(current_student["group_id"])
# TODO Check this
results = sql_run_stored_proc_for_multiple_items(
procs.get_group_wishlist, group_id)
data = []
print(results)
for i in results:
w = models.wishlist.Wishlist(i)
data.append(w)
print(i)
response.media = data
def on_delete(self, request, response):
# TODO make sure the database is up, otherwise send status code 5xx
session_token = get_session(request)
ID = session.id_from_session(session_token)
current_student = get_student_by_id(ID)
group_id = None
if current_student:
group_id = current_student["gid"]
try:
rank = int(get_val(request.params, "rank"))
except ValueError:
response.media = "Invalid rank"
return
except TypeError:
response.media = "No rank provided"
return
if rank is None:
response.media = "Need a rank"
return
sql_run_stored_proc(procs.delete_group_wishlist, group_id, rank)
def on_delete(self, request, response): session_token = get_session(request) student_id = session.id_from_session(session_token) sql_run_stored_proc(procs.leave_group, student_id)
def authenticated(session_token):
return session.id_from_session(session_token) is not None
