def get_room_attendance_check(data, db):
req_list = ['user_id', 'room_id']
check_data(data, req_list)
room = db.query(Room).filter(Room.id == data['room_id']).first()
if not room.master_id == int(data['user_id']): # 마스터가 아님
raise Forbidden
attendance_checks = db.query(AttendanceCheck).filter(
AttendanceCheck.room_id == data['room_id'],
AttendanceCheck.is_valid.is_(True)).all()
result = {
'checked': {},
'unchecked': {},
}
for attendance_check in attendance_checks:
if attendance_check.is_checked is True:
result['checked'][str(attendance_check.user_id)] = serialize(
db.query(User).filter(
User.id == attendance_check.user_id).first())
else:
result['unchecked'][str(attendance_check.user_id)] = serialize(
db.query(User).filter(
User.id == attendance_check.user_id).first())
return jsonify(result)
def put_room_management(data, db): # 방 정보 수정
req_list = ['user_id', 'room_id', 'title', 'maximum_population']
check_data(data, req_list)
user = db.query(User).filter(
User.id == data['user_id']).first() # 유저 객체 가져옴
if not user: # 해당 유저가 존재하지 않음
raise NotFound
room = db.query(Room).filter(
Room.id == data['room_id'],
Room.deleted_on.is_(None),
).first()
if not room: # 해당 방이 존재하지 않음
raise NotFound
if not user.id == room.master_id: # 해당 유저가 마스터가 아니어서 수정 권한이 없음
raise Forbidden
room.title = data['title']
room.maximum_population = data['maximum_population']
db.commit()
return jsonify(serialize(room))
def get_room_attendance_all(data, db): # 학생 한명의 출석 현황을 보는 함수
req_list = ['user_id', 'room_id']
check_data(data, req_list)
user = db.query(User).filter(User.id == data['user_id']).first()
if not user:
raise NotFound
room = db.query(Room).filter(Room.id == data['room_id']).first()
if not room:
raise NotFound
attendance_checks = db.query(AttendanceCheck).filter(
AttendanceCheck.room_id == data['room_id'],
AttendanceCheck.user_id == data['user_id'],
).all()
if not attendance_checks:
raise NotFound
result = {}
for attendance_check in attendance_checks:
result[str(
attendance_check.created_on)[0:10]] = serialize(attendance_check)
return jsonify({'Date': result})
def post_room_management(data, db): # 방 생성
req_list = ['user_id', 'title']
check_data(data, req_list)
master = db.query(User).filter(
User.id == data['user_id']).first() # 유저 객체를 가져옴
if not master: # 해당 유저가 존재 하지 않음
raise NotFound
new_room = Room(
master_id=master.id, # 새로운 방 생성
title=data['title'])
if 'maximum_population' in data: # 최대 인원을 제한했다면 정보 넣어줌
new_room.maximum_population = data['maximum_population']
db.add(new_room)
db.commit()
new_room_member = RoomMember(
room=new_room, # 룸 멤버로 마스터를 생성함
member_id=master.id)
db.add(new_room_member)
db.commit()
return jsonify(serialize(new_room))
def post_room_member_management(data, db): # 방 가입 함수
req_list = ['user_id', 'invite_code']
check_data(data, req_list)
user = db.query(User).filter(User.id == data['user_id']).first()
if not user: # 해당 유저 존재하지 않음
raise NotFound
room = db.query(Room).filter(
Room.invite_code == data['invite_code'],
Room.deleted_on.is_(None),
).first()
if not room: # 해당 초대코드 존재하지 않음
raise NotFound
room_member = db.query(RoomMember).filter(
RoomMember.member_id == data['user_id'], RoomMember.room_id == room.id,
RoomMember.deleted_on.is_(None)).first()
if room_member: # 이미 가입된 방
raise Conflict
all_room_member_count = db.query(RoomMember).filter(
RoomMember.member_id == data['user_id'],
RoomMember.deleted_on.is_(None),
).count()
if room.maximum_population == all_room_member_count: # 가입 가능 인원수 초과
raise Conflict
new_room_member = RoomMember(room_id=room.id, member_id=data['user_id'])
db.add(new_room_member)
db.commit()
return jsonify(serialize(room))
def post_authorization_login(data, db):
req_list = ['email', 'pw']
check_data(data, req_list)
user = db.query(User).filter(User.email == data['email'],
User.pw == data['pw']).first()
if not user: # email 또는 pw이 틀림
return jsonify({'reason': 'login fail'}), 404
return jsonify(serialize(user))
def get_room_management(data, db): # 해당 방의 정보를 가져옴
req_list = ['room_id']
check_data(data, req_list)
room = db.query(Room).filter(
Room.id == data['room_id'],
Room.deleted_on.is_(None),
).first()
if not room: # 해당 방이 존재하지 않음
raise NotFound
return jsonify(serialize(room))
def get_room_member_all(data, db): # 해당 방의 정보를 가져옴
req_list = ['room_id']
check_data(data, req_list)
room = db.query(Room).filter(
Room.id == data['room_id'],
Room.deleted_on.is_(None),
).first()
if not room: # 해당 방이 존재하지 않음
raise NotFound
room_members = db.query(RoomMember).filter(
RoomMember.room_id == data['room_id'],
RoomMember.deleted_on.is_(None),
).all()
if not room_members: # 해당 방에 멤버가 없음
raise NotFound
result = dict()
for room_member in room_members:
attendance_checks = db.query(AttendanceCheck).filter(
AttendanceCheck.room_id == data['room_id'],
AttendanceCheck.user_id == room_member.member_id,
).all()
temp = {
'checked': 0,
'unchecked': 0,
}
for attendance_check in attendance_checks:
if attendance_check.is_checked:
temp['checked'] = temp['checked'] + 1
else:
temp['unchecked'] = temp['unchecked'] + 1
if temp['unchecked'] < 1:
if temp['checked'] > 0:
temp['rate'] = 1.0
else:
temp['rate'] = 0.0
else:
temp['rate'] = temp['checked'] / (temp['checked'] +
temp['unchecked'])
user = db.query(User).filter(User.id == room_member.member_id).first()
suser = serialize(user)
suser['rate_info'] = temp
result[str(user.id)] = suser
return jsonify({'User': result})
def get_room_member_management(data, db): # 가입된 방을 모두 가져오는 함수
req_list = ['user_id']
check_data(data, req_list)
user = db.query(User).filter(
User.id == data['user_id']).first() # 유저 객체 가져옴
if not user: # 해당 유저가 존재하지 않음
raise NotFound
room_members = db.query(RoomMember).filter(
RoomMember.member_id == user.id,
RoomMember.deleted_on.is_(None),
).all() # 유저가 가입된 방을 모두 가져옴
if not room_members: # 가입된 방이 없음
raise NotFound
result = {}
for index, room_member in enumerate(room_members):
room = db.query(Room).filter(Room.id == room_member.room_id).first()
result[str(index)] = serialize(room)
return jsonify(result)