<?php
/*
* This is a sample for using the PHP Vitess client with VTGateV3.
*
* Before running this, start up a local V3 demo cluster by running:
* vitess/examples/demo$ ./run.py
*
* Then in another terminal:
* vitess/examples/demo$ php client.php --server=localhost:12346
*/
require_once __DIR__ . '/../../php/vendor/autoload.php';
use Vitess\Context;
use Vitess\VTGateConn;
use Vitess\Proto\Topodata\TabletType;
$opts = getopt('', array('server:'));
// Create a connection.
$ctx = Context::getDefault();
$conn = new VTGateConn(new \Vitess\Grpc\Client($opts['server'], ['credentials' => Grpc\ChannelCredentials::createInsecure()]));
// Insert something.
$tx = $conn->begin($ctx);
$tx->execute($ctx, 'INSERT INTO user (name) VALUES (:name)', array('name' => 'sugu'));
$tx->commit($ctx);
// Read it back.
$cursor = $conn->execute($ctx, 'SELECT * FROM user', array(), TabletType::MASTER);
while (($row = $cursor->next()) !== FALSE) {
print_r($row);
}
$conn->close();
/**
* Vitess constructor.
*
* @param string $connectionString
* @param Attributes $attributes
* @throws PDOException
* @SuppressWarnings(PHPMD.StaticAccess)
*/
public function __construct($connectionString, Attributes $attributes)
{
$this->attributes = $attributes;
try {
$this->ctx = Context::getDefault();
$credentials = ChannelCredentials::createInsecure();
$this->grpcClient = new Client($connectionString, ['credentials' => $credentials]);
$this->connection = new VTGateConn($this->grpcClient);
$this->clusterConfig = new ClusterConfig();
} catch (Exception $e) {
throw new PDOException("Error while connecting to vitess: " . $e->getMessage(), $e->getCode(), $e);
}
}