๋ฌธ์„œ ๋ฉ”๋‰ด
๋ฌธ์„œ ํ™ˆ
/
MongoDB ๋งค๋‰ด์–ผ
/ / /

๋‚˜๋ˆ„๊ธฐ(์ง‘๊ณ„)

์ด ํŽ˜์ด์ง€์˜ ๋‚ด์šฉ

  • ์ •์˜
  • ์˜ˆ์ œ
$divide

ํ•œ ์ˆซ์ž๋ฅผ ๋‹ค๋ฅธ ์ˆซ์ž๋กœ ๋‚˜๋ˆ„๊ณ  ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋ฐฐ์—ด์˜ $divide์— ์ธ์ˆ˜๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค.

$divide ํ‘œํ˜„์‹์˜ ๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

{ $divide: [ <expression1>, <expression2> ] }

์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๋Š” ํ”ผ์ œ์ˆ˜์ด๊ณ  ๋‘ ๋ฒˆ์งธ ์ธ์ˆ˜๋Š” ์ œ์ˆ˜์ž…๋‹ˆ๋‹ค. ์ฆ‰, ์ฒซ ๋ฒˆ์งธ ์ธ์ˆ˜๋ฅผ ๋‘ ๋ฒˆ์งธ ์ธ์ˆ˜๋กœ ๋‚˜๋ˆ•๋‹ˆ๋‹ค.

์ธ์ˆ˜๋Š” ์ˆซ์ž๋กœ ํ•ด์„๋˜๋Š” ํ•œ ์œ ํšจํ•œ ํ‘œํ˜„์‹ ์ด ๋  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํ‘œํ˜„์‹์— ๋Œ€ํ•œ ์ž์„ธํ•œ ๋‚ด์šฉ์€ ํ‘œํ˜„์‹์„ ์ฐธ์กฐํ•˜์„ธ์š” .

๋‹ค์Œ ๋ฌธ์„œ๊ฐ€ ํฌํ•จ๋œ conferencePlanning collection์„ ์ƒ๊ฐํ•ด ๋ณด์„ธ์š”.

db.conferencePlanning.insertMany( [
{ "_id" : 1, "city" : "New York", "hours" : 80, "tasks" : 7 },
{ "_id" : 2, "city" : "Singapore", "hours" : 40, "tasks" : 4 }
] )

๋‹ค์Œ ์ง‘๊ณ„๋Š” $divide ํ‘œํ˜„์‹์„ ์‚ฌ์šฉํ•˜์—ฌ hours ํ•„๋“œ๋ฅผ ๋ฆฌํ„ฐ๋Ÿด 8๋กœ ๋‚˜๋ˆ„์–ด ๊ทผ๋ฌด์ผ ์ˆ˜๋ฅผ ๊ณ„์‚ฐํ•ฉ๋‹ˆ๋‹ค.

db.planning.aggregate(
[
{ $project: { city: 1, workdays: { $divide: [ "$hours", 8 ] } } }
]
)

์ด ์—ฐ์‚ฐ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

{ "_id" : 1, "city" : "New York", "workdays" : 10 }
{ "_id" : 2, "city" : "Singapore", "workdays" : 5 }
โ†ย ํŒŒ์ƒ(์ง‘๊ณ„)

์ด ํŽ˜์ด์ง€์˜ ๋‚ด์šฉ