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

diff --git a/vendor/doctrine/dbal/docs/examples/sharding/insert_data.php b/vendor/doctrine/dbal/docs/examples/sharding/insert_data.php
new file mode 100644
index 0000000..57aeda6
--- /dev/null
+++ b/vendor/doctrine/dbal/docs/examples/sharding/insert_data.php
@@ -0,0 +1,132 @@
+<?php
+// insert_data.php
+require_once "bootstrap.php";
+
+$shardManager->selectShard(0);
+
+$conn->insert("Products", array(
+    "ProductID" => 386,
+    "SupplierID" => 1001,
+    "ProductName" => 'Titanium Extension Bracket Left Hand',
+    "Price" => 5.25,
+));
+$conn->insert("Products", array(
+    "ProductID" => 387,
+    "SupplierID" => 1001,
+    "ProductName" => 'Titanium Extension Bracket Right Hand',
+    "Price" => 5.25,
+));
+$conn->insert("Products", array(
+    "ProductID" => 388,
+    "SupplierID" => 1001,
+    "ProductName" => 'Fusion Generator Module 5 kV',
+    "Price" => 10.50,
+));
+$conn->insert("Products", array(
+    "ProductID" => 389,
+    "SupplierID" => 1001,
+    "ProductName" => 'Bypass Filter 400 MHz Low Pass',
+    "Price" => 10.50,
+));
+
+$conn->insert("Customers", array(
+    'CustomerID' => 10,
+    'CompanyName' => 'Van Nuys',
+    'FirstName' => 'Catherine',
+    'LastName' => 'Abel',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 20,
+    'CompanyName' => 'Abercrombie',
+    'FirstName' => 'Kim',
+    'LastName' => 'Branch',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 30,
+    'CompanyName' => 'Contoso',
+    'FirstName' => 'Frances',
+    'LastName' => 'Adams',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 40,
+    'CompanyName' => 'A. Datum Corporation',
+    'FirstName' => 'Mark',
+    'LastName' => 'Harrington',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 50,
+    'CompanyName' => 'Adventure Works',
+    'FirstName' => 'Keith',
+    'LastName' => 'Harris',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 60,
+    'CompanyName' => 'Alpine Ski House',
+    'FirstName' => 'Wilson',
+    'LastName' => 'Pais',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 70,
+    'CompanyName' => 'Baldwin Museum of Science',
+    'FirstName' => 'Roger',
+    'LastName' => 'Harui',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 80,
+    'CompanyName' => 'Blue Yonder Airlines',
+    'FirstName' => 'Pilar',
+    'LastName' => 'Pinilla',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 90,
+    'CompanyName' => 'City Power & Light',
+    'FirstName' => 'Kari',
+    'LastName' => 'Hensien',
+));
+$conn->insert("Customers", array(
+    'CustomerID' => 100,
+    'CompanyName' => 'Coho Winery',
+    'FirstName' => 'Peter',
+    'LastName' => 'Brehm',
+));
+
+$conn->executeUpdate("
+    DECLARE @orderId INT
+
+    DECLARE @customerId INT
+
+    SET @orderId = 10
+    SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Hensien' and FirstName = 'Kari'
+
+    INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+    VALUES (@customerId, @orderId, GetDate())
+
+    INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+    VALUES (@customerId, @orderId, 388, 4)
+
+    SET @orderId = 20
+    SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Harui' and FirstName = 'Roger'
+
+    INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+    VALUES (@customerId, @orderId, GetDate())
+
+    INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+    VALUES (@customerId, @orderId, 389, 2)
+
+    SET @orderId = 30
+    SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Brehm' and FirstName = 'Peter'
+
+    INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+    VALUES (@customerId, @orderId, GetDate())
+
+    INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+    VALUES (@customerId, @orderId, 387, 3)
+
+    SET @orderId = 40
+    SELECT @customerId = CustomerId FROM Customers WHERE LastName = 'Pais' and FirstName = 'Wilson'
+
+    INSERT INTO Orders (CustomerId, OrderId, OrderDate)
+    VALUES (@customerId, @orderId, GetDate())
+
+    INSERT INTO OrderItems (CustomerID, OrderID, ProductID, Quantity)
+    VALUES (@customerId, @orderId, 388, 1)");