bulkWrite (database command)（数据库命令）

Create the pizzas example collection创建披萨饼示例集合

Run:运行：

db.pizzas.insertMany( [
   { _id: 0, type: "pepperoni", size: "small", price: 4 },
   { _id: 1, type: "cheese", size: "medium", price: 7 },
   { _id: 2, type: "vegan", size: "large", price: 8 }
] )

Modify the pizzas example collection修改pizza示例集合

Run the following bulkWrite command to perform insert, update, and delete operations on the pizzas collection:运行以下bulkWrite命令对pizzas集合执行插入、更新和删除操作：

db.adminCommand( {
   bulkWrite: 1,

   // The ops array contains the insert, update, and delete operations.ops数组包含插入、更新和删除操作。
   ops: [

      // Specify the namespace ID index immediately after在后面立即指定命名空间ID索引
      // the insert, update, and delete text.插入、更新和删除文本。
      // For example, "insert: 0" specifies the 0 namespace ID index,例如，“插入：0”指定了0命名空间ID索引，
      // which is the "test.pizzas" namespace in nsInfo at the end of the example.这是示例末尾nsInfo中的"test.pizzas"命名空间。

      // Insert a pizza.插入披萨饼q饼。
      { insert: 0, document: { _id: 4, type: "sausage",
        size: "small", price: 12 } },

      // Update the price for medium pizzas.更新中等披萨饼的价格。
      { update: 0, filter: { size: "medium" },
        updateMods: { $set: { price: 15 } } },

      // Delete the pizza with an _id of 2.删除_id为2的披萨饼。
      { delete: 0, filter: { _id: 2 } }
   ],

   // The nsInfo array contains the namespace to apply the previous operations to.nsInfo数组包含要应用前面操作的命名空间。
   nsInfo: [
      { ns: "test.pizzas" }  // Namespace ID index is 0.命名空间ID索引为0。
   ]
} )

The pizzas collection is in the default test database, so the ns namespace is "test.pizzas". pizzas集合位于默认test数据库中，因此ns命名空间为"test.pizzas"。The namespace ID index is 0, which is set in the first field of the insert, update, and delete operations in the ops array.命名空间ID索引为0，在ops数组中的插入、更新和删除操作的第一个字段中设置。

Examine the output检查输出

The following bulkWrite example output, with various ok: 1 fields and nErrors: 0, indicates all operations were successful:以下bulkWrite示例输出，带有各种ok: 1字段和nErrors: 0，表示所有操作都成功：

{
   cursor: {
      id: Long('0'),
      firstBatch: [
         { ok: 1, idx: 0, n: 1 },
         { ok: 1, idx: 1, n: 1, nModified: 1 },
         { ok: 1, idx: 2, n: 1 }
       ],
       ns: 'admin.$cmd.bulkWrite'
   },
   nErrors: 0,
   nInserted: 1,
   nMatched: 1,
   nModified: 1,
   nUpserted: 0,
   nDeleted: 1,
   ok: 1
}

For details about the output fields, see the earlier Output section.有关输出字段的详细信息，请参阅前面的输出部分。

Create the pizzas example collection创建披萨饼示例集合

If you already have the pizzas collection in your test database, use the db.collection.drop() method to drop it first and then run:如果您的测试数据库中已经有pizzas集合，请使用db.collection.drop()方法先删除它，然后运行：

db.pizzas.insertMany( [
   { _id: 0, type: "pepperoni", size: "small", price: 4 },
   { _id: 1, type: "cheese", size: "medium", price: 7 },
   { _id: 2, type: "vegan", size: "large", price: 8 }
] )

Create the pizza orders example collection创建披萨饼订单示例集合

Run:运行：

db.pizzaOrders.insertMany( [
   { _id: 0, type: "pepperoni", number: 5,
     orderDate: new Date( "2023-01-15T12:00:00Z" ) },
   { _id: 1, type: "cheese", number: 15,
     orderDate: new Date( "2023-01-23T11:12:32Z" ) },
   { _id: 2, type: "vegan", number: 20,
     orderDate: new Date( "2023-03-20T10:01:12Z" ) }
] )

Modify the example collections修改示例集合

Run the following bulkWrite command to perform insert, update, and delete operations on the example collections:运行以下bulkWrite命令，对示例集合执行插入、更新和删除操作：

db.adminCommand( {
   bulkWrite: 1,

   // The ops array contains the insert, update, and delete operations.ops数组包含插入、更新和删除操作。
   ops: [

      // Specify the namespace ID indexes immediately after the insert, update, and delete. For example, "insert: 0"在插入、更新和删除后立即指定命名空间ID索引。例如，“插入：0”
      // specifies the 0 namespace ID index, which is the "test.pizzas" namespace.指定0命名空间ID索引，即"test.pizzas"命名空间。
      // And, "insert: 1" specifies "test.pizzaOrders".而且，"insert: 1"指定"test.pizzaOrders"。

      // Insert pizzas.插入披萨饼。
      // Namespace ID is 0 for "test.pizzas", which is specified as "insert: 0".“testpizza”的命名空间ID为0，指定为“插入：0”。
      { insert: 0, document: { _id: 5, type: "sausage",
        size: "small", price: 12 } },
      { insert: 0, document: { _id: 6, type: "vegan cheese",
        size: "large", price: 25 } },

      // Update the price for cheese pizzas.更新奶酪披萨饼的价格。
      { update: 0, filter: { type: "cheese" },
        updateMods: { $set: { price: 15 } } },

      // Delete pizzas with a price less than 7.删除价格低于7的披萨饼。
      { delete: 0, filter: { price: { $lt: 7 } } },

      // Insert pizza orders.插入披萨饼订单。
      // Namespace ID is 1 for "test.pizzaOrders".“testpizza Orders”的命名空间ID为1。
      { insert: 1, document: { _id: 3, type: "sausage", number: 7,
        orderDate: new Date( "2023-04-15T12:02:15Z" ) } },
      { insert: 1, document: { _id: 4, type: "vegan", number: 16,
        orderDate: new Date( "2023-05-12T11:03:11Z" ) } },

      // Update the number of pizza orders for cheese pizzas.更新奶酪披萨饼的披萨饼订单数量。
      { update: 1, filter: { type: "cheese" },
        updateMods: { $set: { number: 50 } } },

      // Delete the pizza order with an _id of 2.删除_id为2的披萨饼订单。
      { delete: 1, filter: { _id: 2 } },

      // Delete pizza orders placed before March 15, 2023.删除2023年3月15日之前下的披萨饼订单。
      { delete: 1, filter: { orderDate:
        { $lte: ISODate( "2023-03-15T00:00:00Z" ) } } }
   ],

   // Namespaces命名空间
   nsInfo: [
      { ns: "test.pizzas" }, // Namespace ID index is 0.命名空间ID索引为0。
      { ns: "test.pizzaOrders" }  // Namespace ID index is 1.命名空间ID索引为1。
   ]
} )

Examine the output检查输出

The following bulkWrite example output indicates the operations were successful:以下bulkWrite示例输出表明操作成功：

{
   cursor: {
      id: Long('0'),
      firstBatch: [
         { ok: 1, idx: 0, n: 1 },
         { ok: 1, idx: 1, n: 1 },
         { ok: 1, idx: 2, n: 1, nModified: 1 },
         { ok: 1, idx: 3, n: 1 },
         { ok: 1, idx: 4, n: 1 },
         { ok: 1, idx: 5, n: 1 },
         { ok: 1, idx: 6, n: 1, nModified: 1 },
         { ok: 1, idx: 7, n: 1 },
         { ok: 1, idx: 8, n: 1 }
      ],
      ns: 'admin.$cmd.bulkWrite'
   },
   nErrors: 0,
   nInserted: 4,
   nMatched: 2,
   nModified: 2,
   nUpserted: 0,
   nDeleted: 3,
   ok: 1
}

Create the pizzas example collection创建披萨饼示例集合

If you already have the pizzas collection in your test database, use the db.collection.drop() method to drop it first and then run:如果您的test数据库中已经有pizzas集合，请使用db.collection.drop()方法先删除它，然后运行：

db.pizzas.insertMany( [
   { _id: 0, type: "pepperoni", size: "small", price: 4 },
   { _id: 1, type: "cheese", size: "medium", price: 7 },
   { _id: 2, type: "vegan", size: "large", price: 8 }
] )

Attempt to modify the pizzas example collection尝试修改pizza示例集合

Run the following bulkWrite command to perform insert, update, and delete operations on the pizzas collection:运行以下bulkWrite命令对pizzas集合执行插入、更新和删除操作：

db.adminCommand( {
   bulkWrite: 1,

   // The ops array contains the insert, update, and delete operations.ops数组包含插入、更新和删除操作。
   ops: [

      // The namespace ID indexes are specified immediately after the insert, update, and delete text.命名空间ID索引在插入、更新和删除文本后立即指定。
      // For example, "insert: 0" specifies the 0 namespace ID index, which is the "test.pizzas" namespace in nsInfo.例如，"insert: 0"指定了0命名空间ID索引，即nsInfo中的"test.pizzas"命名空间。

      // Attempt to add a duplicate document with an _id of 1, which already exists and causes an error.尝试添加_id为1的重复文档，该文档已存在并导致错误。
      { insert: 0, document: { _id: 1, type: "tomato",
        size: "small", price: 12 } },

      // Attempt to add another duplicate document.尝试添加另一个重复文档。
      { insert: 0, document: { _id: 2, type: "pepper",
        size: "small", price: 12 } },

      // Attempt to change the price for extra large pizzas, which don't exist. 尝试更改不存在的超大披萨的价格。
      //  This doesn't cause an error but doesn't update any documents.这不会导致错误，但不会更新任何文档。
      { update: 0, filter: { size: "extra large" },
        updateMods: { $set: { price: 15 } } },

      // Attempt to remove a document that doesn't exist.尝试删除不存在的文档。
      // This doesn't cause an error but doesn't delete any documents.这不会导致错误，但不会删除任何文档。
      { delete: 0, filter: { _id: 8 } }
   ],

   // The nsInfo array contains the namespace to apply the previous operations to.nsInfo数组包含要应用前面操作的命名空间。
   nsInfo: [
      { ns: "test.pizzas" }  // Namespace ID index is 0.命名空间ID索引为0。
   ],

   // Set the ordered field to false to run the remaining operations after an operation returns an error.将有序字段设置为false，以便在操作返回错误后运行其余操作。
   ordered: false
} )

Examine the output检查输出

The following bulkWrite example output shows the errors:以下bulkWrite示例输出显示了错误：

{
   cursor: {
      id: Long("0"),
      firstBatch: [
         {
            ok: 0,
            idx: 0,
            code: 11000,
            errmsg: 'E11000 duplicate key error collection:
            test.pizzas index: _id_ dup key: { _id: 1 }',
            keyPattern: { _id: 1 },
            keyValue: { _id: 1 },
            n: 0
         },
         {
            ok: 0,
            idx: 1,
            code: 11000,
            errmsg: 'E11000 duplicate key error collection:
            test.pizzas index: _id_ dup key: { _id: 2 }',
            keyPattern: { _id: 1 },
            keyValue: { _id: 2 },
            n: 0
         },
         { ok: 1, idx: 2, n: 0, nModified: 0 },
         { ok: 1, idx: 3, n: 0 }
      ],
      ns: 'admin.$cmd.bulkWrite'
   },
   nErrors: 2,
   nInserted: 0,
   nMatched: 0,
   nModified: 0,
   nUpserted: 0,
   nDeleted: 0,
   ok: 1
}

For details about the output fields, including the error codes and messages, see the earlier Output输出 section.有关输出字段的详细信息，包括错误代码和消息，请参阅前面的输出部分。

Create the pizzas example collection创建披萨饼示例集合

If you already have the pizzas collection in your test database, use the db.collection.drop() method to drop it first and then run:如果您的测试数据库中已经有pizzas集合，请使用db.collection.drop()方法先删除它，然后运行：

db.pizzas.insertMany( [
   { _id: 0, type: "pepperoni", size: "small", price: 4 },
   { _id: 1, type: "cheese", size: "medium", price: 7 },
   { _id: 2, type: "vegan", size: "large", price: 8 }
] )

Attempt to modify the pizzas example collection尝试修改pizza示例集合

Run the following bulkWrite command to perform insert, update, and delete operations on the pizzas collection with errorsOnly set to true:运行以下bulkWrite命令，在errorsOnly设置为true的情况下对pizzas集合执行插入、更新和删除操作：

db.adminCommand( {
   bulkWrite: 1,

   // The ops array contains the insert, update, and delete operations.ops数组包含插入、更新和删除操作。
   ops: [

      // The namespace ID indexes are specified immediately after the insert, update, and delete text.命名空间ID索引在插入、更新和删除文本后立即指定。
      // For example, "insert: 0" specifies the 0 namespace ID index,例如，“插入：0”指定了0命名空间ID索引，
      // which is the "test.pizzas" namespace in nsInfo.这是nsInfo中的"test.pizzas"命名空间。

      // Attempt to add a duplicate document with an _id of 1, which already exists and causes an error.尝试添加_id为1的重复文档，该文档已存在并导致错误。
      { insert: 0, document: { _id: 1, type: "tomato",
        size: "small", price: 12 } },

      // Attempt to add another duplicate document.尝试添加另一个重复文档。
      { insert: 0, document: { _id: 2, type: "pepper",
        size: "small", price: 12 } },

      // Attempt to change the price for extra large pizzas, which don't exist. 尝试更改并不存在的超大披萨饼的价格，
      // This doesn't cause an error but doesn't update any documents.这不会导致错误，但不会更新任何文档。
      { update: 0, filter: { size: "extra large" },
        updateMods: { $set: { price: 15 } } },

      // Attempt to remove a document that doesn't exist.尝试删除不存在的文档。
      // This doesn't cause an error but doesn't delete any documents.这不会导致错误，但不会删除任何文档。
      { delete: 0, filter: { _id: 8 } }
   ],

   // The nsInfo array contains the namespace to apply the previous operations to.nsInfo数组包含要应用前面操作的命名空间。
   nsInfo: [
      { ns: "test.pizzas" }  // Namespace ID index is 0.命名空间ID索引为0。
   ],

   // Set the ordered field to false to run the remaining operations after an operation returns an error.将有序字段设置为false，以便在操作返回错误后运行其余操作。
   ordered: false,

   // Set the errorsOnly field to true to only output the errors.将errorsOnly字段设置为true，仅输出错误。
   errorsOnly: true
} )

Examine the output检查输出

The following bulkWrite example output shows the errors:以下bulkWrite示例输出显示了错误：

{
   cursor: {
      id: Long("0"),
      firstBatch: [
         {
            ok: 0,
            idx: 0,
            code: 11000,
            errmsg: 'E11000 duplicate key error collection:
            test.pizzas index: _id_ dup key: { _id: 1 }',
            keyPattern: { _id: 1 },
            keyValue: { _id: 1 },
            n: 0
         },
         {
            ok: 0,
            idx: 1,
            code: 11000,
            errmsg: 'E11000 duplicate key error collection:
            test.pizzas index: _id_ dup key: { _id: 2 }',
            keyPattern: { _id: 1 },
            keyValue: { _id: 2 },
            n: 0
         },
      ],
      ns: 'admin.$cmd.bulkWrite'
   },
   nErrors: 2,
   nInserted: 0,
   nMatched: 0,
   nModified: 0,
   nUpserted: 0,
   nDeleted: 0,
   ok: 1
}