vendor/doctrine/dbal/docs/examples/sharding/insert_data_aftersplit.php

   1 <?php
   2 // insert_data_aftersplit.php
   3 require_once 'bootstrap.php';
   4
   5 $newCustomerId = 55;
   6
   7 $shardManager->selectShard($newCustomerId);
   8
   9 $conn->insert("Customers", array(
  10     "CustomerID" => $newCustomerId,
  11     "CompanyName" => "Microsoft",
  12     "FirstName" => "Brian",
  13     "LastName" => "Swan",
  14 ));
  15
  16 $conn->insert("Orders", array(
  17     "CustomerID" => 55,
  18     "OrderID" => 37,
  19     "OrderDate" => date('Y-m-d H:i:s'),
  20 ));
  21
  22 $conn->insert("OrderItems", array(
  23     "CustomerID" => 55,
  24     "OrderID" => 37,
  25     "ProductID" => 387,
  26     "Quantity" => 1,
  27 ));