친구 관계 설정 API
Query logging
jwt 로그아웃
request.user를 가져와서 해당 친구 관계 가져올 시 lazy loading 관련 오류
Parent object <User> is not bound to a Session; lazy load operation of attribute cannot proceed
가 requets.user.friends
로 접근할 때 문제가 발생했다.starlette.request
에서 request.state.some_value
와 같이 원하는 값을 저장할 수 있었다. 그래서 request.state.db
에 넣어서 본 API 처리 함수에서 꺼내서 썼다.Authentication 미들웨어 효율성에 관한 의문
BEGIN (implicit)
SELECT users.id AS users_id, users.login_id AS users_login_id, users.username AS users_username, users.password AS users_password, users.nickname AS users_nickname, users.create_dt AS users_create_dt, users.update_dt AS users_update_dt
FROM users
WHERE users.id = %(pk_1)s
[generated in 0.00014s] {'pk_1': 1}
BEGIN (implicit)
SELECT users.id AS users_id, users.login_id AS users_login_id, users.username AS users_username, users.password AS users_password, users.nickname AS users_nickname, users.create_dt AS users_create_dt, users.update_dt AS users_update_dt
FROM users
WHERE users.id = %(pk_1)s
[cached since 1.909s ago] {'pk_1': 1}
SELECT users.id AS users_id, users.login_id AS users_login_id, users.username AS users_username, users.password AS users_password, users.nickname AS users_nickname, users.create_dt AS users_create_dt, users.update_dt AS users_update_dt
FROM users, friendships
WHERE %(param_1)s = friendships.user_id AND users.id = friendships.friend_id
[generated in 0.00011s] {'param_1': 1}
BEGIN (implicit)
SELECT users.id AS users_id, users.login_id AS users_login_id, users.username AS users_username, users.password AS users_password, users.nickname AS users_nickname, users.create_dt AS users_create_dt, users.update_dt AS users_update_dt
FROM users
WHERE users.id = %(pk_1)s
[generated in 0.00016s] {'pk_1': 1}
SELECT users.id AS users_id, users.login_id AS users_login_id, users.username AS users_username, users.password AS users_password, users.nickname AS users_nickname, users.create_dt AS users_create_dt, users.update_dt AS users_update_dt
FROM users, friendships
WHERE %(param_1)s = friendships.user_id AND users.id = friendships.friend_id
[generated in 0.00018s] {'param_1': 1}
request.user
를 사용할 때 발생한다. 해당 쿼리를 사용하지 않게 하는 방법은 아직까지 못찾았다.