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

๋ทฐ ์ˆ˜์ •

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

  • ์˜ˆ์ œ
  • ๋ทฐ ์‚ญ์ œ ๋ฐ ๋‹ค์‹œ ๋งŒ๋“ค๊ธฐ
  • collMod ๋ช…๋ น ์‚ฌ์šฉ

๋ทฐ๋ฅผ ์ˆ˜์ •ํ•˜๋ ค๋ฉด ๋‹ค์Œ ์ค‘ ํ•˜๋‚˜๋ฅผ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

lowStock์ด๋ผ๋Š” ์ด๋ฆ„์˜ ๋‹ค์Œ ๋ทฐ๋ฅผ ๊ฐ€์ •ํ•ด ๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค.

db.createView(
"lowStock",
"products",
[ { $match: { quantity: { $lte: 20 } } } ]
)

๋‹ค์Œ ๋ช…๋ น์€ ๋ทฐ๋ฅผ ์‚ญ์ œํ•˜๊ณ  ๋‹ค์‹œ ์ƒ์„ฑํ•˜์—ฌ lowStock์„ ์ˆ˜์ •ํ•ฉ๋‹ˆ๋‹ค.

db.lowStock.drop()
db.createView(
"lowStock",
"products",
[ { $match: { quantity: { $lte: 10 } } } ]
)

๋˜๋Š” collMod ๋ช…๋ น์„ ์‚ฌ์šฉํ•˜์—ฌ ๋ทฐ๋ฅผ ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

db.runCommand( {
collMod: "lowStock",
viewOn: "products",
"pipeline": [ { $match: { quantity: { $lte: 10 } } } ]
} )
โ†ย ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์ •๋ ฌ์„ ์‚ฌ์šฉํ•˜์—ฌ ๋ทฐ ๋งŒ๋“ค๊ธฐ