ytake / voltdb-client-wrapper
voltdb 客户端包装器
0.2.4
2014-10-05 09:21 UTC
Requires
- php: >=5.4.0
- ext-curl: *
Requires (Dev)
- mockery/mockery: 0.9.*
- phpunit/phpunit: 4.*
- satooshi/php-coveralls: dev-master
Suggests
- ext-voltdb: Required for VoltClient. use extension https://github.com/VoltDB/voltdb-client-php/tree/native
This package is auto-updated.
Last update: 2024-09-04 23:00:03 UTC
README
voltdb 客户端包装器 / json 接口支持。
所需扩展
curl
建议
voltdb-client-php(native branch)
##安装
"require": { "php": ">=5.4.0", "ext-curl": "*", "ext-voltdb": "*", "ytake/voltdb-client-wrapper": "0.*" },
##使用##VoltDB json API(简单)
$client = new \Ytake\VoltDB\HttpClient(new \Ytake\VoltDB\Parse); // get request $result = $client->request('http://localhost')->get(['Procedure' => 'allUser'])->getResult(); // post request $result = $client->request('http://localhost')->post([ 'Procedure' => 'addUser', 'Parameters' => [1, "voltdb"] ])->getResult();
###使用参数 JSON HTTP 接口
相同参数
// procedure-name 'Procedure' => null, // procedure-parameters 'Parameters' => null, // username for authentication 'User' => null, // password for authentication 'Password' => null, // Hashed password for authentication 'Hashedpassword' => null, // true|false 'admin' => false, // function-name 'jsonp' => null
###获取 SystemInformation
// default "OVERVIEW" $client->request('http://localhost')->info()->getResult(); // DEVELOPMENT $client->request('http://localhost')->info("DEPLOYMENT")->getResult();
##VoltClient 包装器###AdHoc 查询
$connection = new \Ytake\VoltDB\Client(new \VoltClient, new \Ytake\VoltDB\Parse); $connection->connect()->excute("SELECT * FROM users");
不支持预定义语句
JDBC 驱动(Java)支持或存储过程(DDL)
###存储过程
$connection = new \Ytake\VoltDB\Client(new \VoltClient, new \Ytake\VoltDB\Parse); $connection->connect()->procedure("Procedure-Name");
###异步存储过程
$connection = new \Ytake\VoltDB\Client(new \VoltClient, new \Ytake\VoltDB\Parse); $async = $connection->connect()->asyncProcedure("allUser"); // blocking and get result $async->drain(); $async->asyncResult();