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

diff --git a/vendor/doctrine/dbal/docs/examples/sharding/create_schema.php b/vendor/doctrine/dbal/docs/examples/sharding/create_schema.php
new file mode 100644
index 0000000..ac6b66c
--- /dev/null
+++ b/vendor/doctrine/dbal/docs/examples/sharding/create_schema.php
@@ -0,0 +1,51 @@
+<?php
+// create_schema.php
+use Doctrine\DBAL\Schema\Schema;
+use Doctrine\Shards\DBAL\SQLAzure\SQLAzureSchemaSynchronizer;
+
+require_once 'bootstrap.php';
+
+$schema = new Schema();
+
+$products = $schema->createTable('Products');
+$products->addColumn('ProductID', 'integer');
+$products->addColumn('SupplierID', 'integer');
+$products->addColumn('ProductName', 'string');
+$products->addColumn('Price', 'decimal', array('scale' => 2, 'precision' => 12));
+$products->setPrimaryKey(array('ProductID'));
+$products->addOption('azure.federated', true);
+
+$customers = $schema->createTable('Customers');
+$customers->addColumn('CustomerID', 'integer');
+$customers->addColumn('CompanyName', 'string');
+$customers->addColumn('FirstName', 'string');
+$customers->addColumn('LastName', 'string');
+$customers->setPrimaryKey(array('CustomerID'));
+$customers->addOption('azure.federated', true);
+$customers->addOption('azure.federatedOnColumnName', 'CustomerID');
+
+$orders = $schema->createTable('Orders');
+$orders->addColumn('CustomerID', 'integer');
+$orders->addColumn('OrderID', 'integer');
+$orders->addColumn('OrderDate', 'datetime');
+$orders->setPrimaryKey(array('CustomerID', 'OrderID'));
+$orders->addOption('azure.federated', true);
+$orders->addOption('azure.federatedOnColumnName', 'CustomerID');
+
+$orderItems = $schema->createTable('OrderItems');
+$orderItems->addColumn('CustomerID', 'integer');
+$orderItems->addColumn('OrderID', 'integer');
+$orderItems->addColumn('ProductID', 'integer');
+$orderItems->addColumn('Quantity', 'integer');
+$orderItems->setPrimaryKey(array('CustomerID', 'OrderID', 'ProductID'));
+$orderItems->addOption('azure.federated', true);
+$orderItems->addOption('azure.federatedOnColumnName', 'CustomerID');
+
+// Create the Schema + Federation:
+$synchronizer = new SQLAzureSchemaSynchronizer($conn, $shardManager);
+
+// Or jut look at the SQL:
+echo implode("\n", $synchronizer->getCreateSchema($schema));
+
+$synchronizer->createSchema($schema);
+