온라인 MongoDB 에디터

db.users.insertMany([
  { name: "Alice", age: 25, city: "NYC" },
  { name: "Bob", age: 30, city: "LA" },
  { name: "Charlie", age: 35, city: "NYC" }
]);

db.users.find().forEach(printjson);

db.students.insertMany([
  { name: "Alice", age: 20, grade: 3.8 },
  { name: "Bob", age: 22, grade: 3.5 },
  { name: "Charlie", age: 21, grade: 3.9 }
]);

print("Count: " + db.students.countDocuments());
db.students.find({}, { _id: 0 }).forEach(printjson);

db.products.insertMany([
  { name: "Laptop", price: 999, category: "Electronics" },
  { name: "Book", price: 20, category: "Education" },
  { name: "Phone", price: 699, category: "Electronics" }
]);

db.products.find({
  price: { $gt: 100 },
  category: "Electronics"
}).forEach(printjson);

db.scores.insertMany([
  { student: "Alice", score: 92 },
  { student: "Bob", score: 78 },
  { student: "Charlie", score: 95 },
  { student: "Diana", score: 88 }
]);

db.scores.find({}, { _id: 0 })
  .sort({ score: -1 })
  .limit(3)
  .forEach(printjson);

db.users.insertMany([
  { name: "Alice", email: "alice@old.com" },
  { name: "Bob", email: "bob@mail.com" }
]);

db.users.updateOne(
  { name: "Alice" },
  { $set: { email: "alice@new.com" } }
);

db.users.find({}, { _id: 0 }).forEach(printjson);

db.sales.insertMany([
  { product: "A", region: "North", amount: 100 },
  { product: "A", region: "South", amount: 150 },
  { product: "B", region: "North", amount: 200 }
]);

db.sales.aggregate([
  { $group: { _id: "$product", total: { $sum: "$amount" } } },
  { $sort: { total: -1 } }
]).forEach(printjson);

db.logs.insertMany([
  { level: "INFO", msg: "App started", ts: new Date() },
  { level: "ERROR", msg: "Failed", ts: new Date() },
  { level: "INFO", msg: "Request OK", ts: new Date() }
]);

db.logs.createIndex({ level: 1 });
db.logs.find({ level: "ERROR" }, { _id: 0 }).forEach(printjson);

db.orders.insertOne({
  customer: "Alice",
  items: [
    { product: "Widget", qty: 3, price: 10 },
    { product: "Gadget", qty: 1, price: 25 }
  ],
  total: 55
});

db.orders.find(
  { "items.product": "Widget" },
  { _id: 0 }
).forEach(printjson);

db.accounts.createIndex({ email: 1 }, { unique: true });

db.accounts.insertOne({ name: "Alice", email: "alice@test.com" });

try {
  db.accounts.insertOne({ name: "Bob", email: "alice@test.com" });
} catch (e) {
  print("Error: " + e.message);
}

db.accounts.find({}, { _id: 0 }).forEach(printjson);

db.orders.insertMany([
  { product: "A", qty: 10, price: 5 },
  { product: "B", qty: 3, price: 20 },
  { product: "A", qty: 7, price: 5 },
  { product: "B", qty: 5, price: 20 }
]);

db.orders.aggregate([
  { $group: {
    _id: "$product",
    totalQty: { $sum: "$qty" },
    revenue: { $sum: { $multiply: ["$qty", "$price"] } }
  }},
  { $sort: { revenue: -1 } }
]).forEach(printjson);