// ======== CREATE ========
// insertOne
const result = await db.orders.insertOne({
  user_id: ObjectId("64f8b2c3e4b0a1234567890b"),
  status: "pending",
  items: [],
  created_at: new Date()
});
console.log(result.insertedId); // new ObjectId

// insertMany — bulk insert
await db.events.insertMany([
  { type: "page_view", url: "/home", user_id: "u1" },
  { type: "click", url: "/products/1", user_id: "u1" },
  { type: "add_to_cart", product_id: "p1", user_id: "u1" }
]);

// ======== READ ========
// Find by exact match
const order = await db.orders.findOne({ _id: ObjectId("...") });

// Find with filter
const pendingOrders = await db.orders.find({
  status: "pending",
  "items.0": { $exists: true }  // at least one item
}).sort({ created_at: -1 }).limit(20).toArray();

// Query operators
const expensiveOrders = await db.orders.find({
  total_agorot: { $gte: 50000, $lte: 500000 },  // between 500-5000 NIS
  status: { $in: ["confirmed", "shipped"] },
  created_at: { $gte: new Date("2025-01-01") }
}).toArray();

// ======== UPDATE ========
// Update one document
await db.orders.updateOne(
  { _id: OrderId },
  {
    $set: { status: "confirmed", confirmed_at: new Date() },
    $push: { status_history: { status: "confirmed", at: new Date() } }
  }
);

// Update with array operators
await db.products.updateOne(
  { _id: productId },
  {
    $inc: { stock: -2 },                // decrement
    $push: { restock_alerts: { threshold: 5, notified_at: new Date() } }
  }
);

// Upsert: insert or update
await db.user_preferences.updateOne(
  { user_id: userId },
  { $set: { theme: "dark", language: "he" } },
  { upsert: true }
);

// ======== DELETE ========
await db.sessions.deleteOne({ token: sessionToken });
await db.sessions.deleteMany({
  expires_at: { $lt: new Date() }  // clean up expired sessions
});
MongoDB — מסד נתונים מבוסס מסמכים

MongoDB — מסד נתונים מבוסס מסמכים

MongoDB — מסד נתונים מבוסס מסמכים
