presto-sdk 能让你快速接入数据平台的dbquery presto服务.
require(dirname(__DIR__) . '/vendor/autoload.php');
$url = 'https://digger.123u.com:8443/v2/dbquery';
$requestTimeOut = 60;
$catalog = 'kudu';
$db = 'yxs';
$action = 'presto-sync';
$sql = "SELECT stat_day, app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register from
(select stat_day,app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register
from data_center_hero_stat.user_basic_info where app_plat=1 ORDER BY stat_day DESC limit 15) as t ORDER BY stat_day ASC";
$queryObj = new HuanLe\DBQueryV2\QueryClient($url, $requestTimeOut);
$queryObj->setDb($db);
$queryObj->setCatalog($catalog);
$queryObj->setPage(true);
$queryObj->setAction($action);
$queryObj->setPageSize(20);
$queryObj->setCurrentPage(1);
$queryObj->setSql($sql);
//true 返回结果是否需要格式化为配置平台输出格式,false则是返回query服务原数据,不做任何处理
$queryObj->setIsDataFormat(true);
print_r($queryObj->getQueryResult());
The recommended way to install Guzzle is through Composer.
# Install Composer
curl -sS https://getcomposer.org/installer | php
Next, run the Composer command to install the latest stable version of db-query-sdk:
php composer.phar require 123u/db-query-sdk
After installing, you need to require Composer's autoloader:
require 'vendor/autoload.php';
You can then later update db-query-sdk using composer:
php composer.phar update
Version | Status | Packagist | Namespace | PHP Version |
---|---|---|---|---|
1.0.0 | EOL | 123u/presto-sdk |
HuanLe\DBQueryV2 |
>= 7.0.10 |