X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=vendor%2Fdoctrine%2Fdbal%2Fdocs%2Fexamples%2Fsharding%2Finsert_data_aftersplit.php;fp=vendor%2Fdoctrine%2Fdbal%2Fdocs%2Fexamples%2Fsharding%2Finsert_data_aftersplit.php;h=312e90b235b7cb871eb2e0feb3254c9a4ced8dfe;hb=8b04b2d11798dee4f3e1358e4f43e97a6df851f6;hp=0000000000000000000000000000000000000000;hpb=73568cf05a785a45f94ca3f2351d9e07bf917958;p=zf2.biz%2Fapplication_blanche.git

diff --git a/vendor/doctrine/dbal/docs/examples/sharding/insert_data_aftersplit.php b/vendor/doctrine/dbal/docs/examples/sharding/insert_data_aftersplit.php
new file mode 100644
index 0000000..312e90b
--- /dev/null
+++ b/vendor/doctrine/dbal/docs/examples/sharding/insert_data_aftersplit.php
@@ -0,0 +1,27 @@
+<?php
+// insert_data_aftersplit.php
+require_once 'bootstrap.php';
+
+$newCustomerId = 55;
+
+$shardManager->selectShard($newCustomerId);
+
+$conn->insert("Customers", array(
+    "CustomerID" => $newCustomerId,
+    "CompanyName" => "Microsoft",
+    "FirstName" => "Brian",
+    "LastName" => "Swan",
+));
+
+$conn->insert("Orders", array(
+    "CustomerID" => 55,
+    "OrderID" => 37,
+    "OrderDate" => date('Y-m-d H:i:s'),
+));
+
+$conn->insert("OrderItems", array(
+    "CustomerID" => 55,
+    "OrderID" => 37,
+    "ProductID" => 387,
+    "Quantity" => 1,
+));