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