[In-depth] django queryset + SQL
ยท
Django-rest-framework
3๋…„์ฐจ ๋ฐฑ์—”๋“œ ๊ฐœ๋ฐœ์ž๋กœ์„œ ํ•ญ์ƒ ์จ์™”๋˜ orm์ด์ง€๋งŒ, ์“ฐ๋˜๊ฒƒ๋งŒ ์‚ฌ์šฉํ•˜๋‹ค๋ณด๋‹ˆ ์ž˜ ์‚ฌ์šฉํ•˜์ง€ ์•Š๋Š” queyset ํ™œ์šฉ ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด์„œ๋Š” ์กฐ๊ธˆ ๋ฌด์ง€ํ–ˆ๋˜ ๊ฒƒ ๊ฐ™๋‹ค. ๊ทธ๋ž˜์„œ ๊ณต์‹ document๋ฅผ ๋ณด๊ณ  ์ฐจ๊ทผ์ฐจ๊ทผ ํ•˜๋‚˜ํ•˜๋‚˜ ์ •๋ฆฌ๋ฅผ ํ•ด๋ณด๋ฉฐ ํ•œ๋ฒˆ ๋” ๋จธ๋ฆฌ์— ์ƒˆ๊ธธ๋ ค๊ณ  ํ•œ๋‹ค. [Queryset API] filter(*args, **kwargs): ์กฐ๊ฑด์— ๋งž๋Š” ๊ฐ์ฒด๋“ค๋งŒ ๋‹ด์€ queryset์„ ๋ฐ˜ํ™˜, ์—ฌ๋Ÿฌ ์กฐ๊ฑด์„ ์ฃผ๋ฉด AND ์กฐ๊ฑด์œผ๋กœ ๋ฌถ์ธ๋‹ค.- lookups (method: filter(), exclude(), get())exact: ์ •ํ™•ํ•œ ์ผ์น˜ -> SQL: SELECT ... WHERE id = 14;iexact: ๋Œ€์†Œ๋ฌธ์ž ๊ตฌ๋ถ„ ์—†๋Š” ์ •ํ™•ํ•œ ์ผ์น˜-> SQL:SELECT ... WHERE name ILIKE 'beatles blo..