[SQLAlchemy] SQLAlchemy ๋กœ๋”ฉ ์ „๋žต
ยท
SQLAlchemy
`joinedload`: ๊ด€๊ณ„๋œ ๊ฐ์ฒด๋ฅผ ์ฆ‰์‹œ ๋กœ๋“œํ•˜๊ธฐ ์œ„ํ•ด sql join์„ ์‚ฌ์šฉ# ๋ถ€๋ชจ ๊ฐ์ฒด์™€ ์ž์‹ ๊ฐ์ฒด๋ฅผ ํ•จ๊ป˜ ์ฆ‰์‹œ ๋กœ๋“œํ•ด์•ผํ•  ๋•Œ ์‚ฌ์šฉfrom sqlalchemy.orm import joinedloadquery = session.query(Parent).options(joinedload(Parent.children)) `subqueryload`: ๊ด€๊ณ„๋œ ๊ฐ์ฒด๋ฅผ ์„œ๋ธŒ์ฟผ๋ฆฌ๋กœ ๋กœ๋“œ# ๋ถ€๋ชจ ๊ฐ์ฒด๋ฅผ ๋จผ์ € ๋กœ๋“œํ•˜๊ณ , ๊ทธ ํ›„ ์„œ๋ธŒ์ฟผ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ž์‹ ๊ฐ์ฒด๋ฅผ ๋กœ๋“œํ•  ๋•Œ ์ ํ•ฉfrom sqlalchemy.orm import subqueryloadquery = session.query(Parent).options(subqueryload(Parent.children)) `selectinload`: ๊ด€๊ณ„๋œ ๊ฐ์ฒด๋ฅผ ๋ณ„๋„์˜..