insert_data_aftersplit.php 547 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 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,
));